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

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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, Julian Hyde, James R. Taylor, Rajeshbabu Chintaguntla, Kevin Liew

        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

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

                Dates

                • Created:
                  Updated:
                  Resolved: