Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2799

Allow alias in having clause for aggregate functions

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Won't Fix
    • 1.18.0
    • 1.19.0
    • None
    • None

    Description

      Currently alias is not allowed in having for aggregate functions.
      MySql supports such cases and taking into account that alias in having clause is allowed only for the following conformance levels: MYSQL_5, LENIENT, BABEL, it makes sense to allow alias in having for aggregate functions.

       /**
   * Whether to allow aliases from the {@code SELECT} clause to be used as
   * column names in the {@code HAVING} clause.
   *
   * <p>Among the built-in conformance levels, true in
   * {@link SqlConformanceEnum#BABEL},
   * {@link SqlConformanceEnum#LENIENT},
   * {@link SqlConformanceEnum#MYSQL_5};
   * false otherwise.
   */
  boolean isHavingAlias();

      Attachments

        Issue Links

          Dependent

          Bug - A problem which impairs or prevents the functions of the product. DRILL-6995 Count() function is not working with columns alias

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-3936 RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

          • Major - Major loss of function.
          • Closed

          Activity

            People

              julianhyde Julian Hyde
              arina Arina Ielchiieva
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: