Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3104 Enable Phoenix test cases with Calcite-Phoenix
  3. PHOENIX-3712

Column alias can't be resolved in GROUP BY clause

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      There are quite a few test cases written like:
      select v1 - 1 as v, sum(v2) from t group by v in Phoenix test suite, and calcite does not allow using aliases defined in SELECT list to be referred by GROUP BY clause (ok for ORDER BY though), shall we change those test cases? FYI, julianhyde, jamestaylor, rajeshbabu, kliew

      Attachments

        1. PHOENIX-3712.patch
          0.8 kB
          Rajeshbabu Chintaguntla

        Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-1306 Allow GROUP BY and HAVING to reference SELECT expressions by ordinal and alias

          • Major - Major loss of function.
          • Closed

          Activity

            People

              rajeshbabu Rajeshbabu Chintaguntla
              maryannxue Wei Xue
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: