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

When group by is same as sub-query, grouping sets are missing

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • None
    • core
    • None

    Description

      For example:

      SELECT
t.ID, t.NAME, count(t.AGE) T_AGE
FROM
(SELECT u.ID, u.NAME, u.AGE
FROM USERS u
GROUP BY u.ID, u.NAME, u.AGE
) t
GROUP BY t.ID, t.NAME, t.AGE
GROUPING SETS(
(t.ID, t.NAME),
(t.ID, t.NAME, t.AGE)
)

      will be

      SELECT u.ID, u.NAME, u.AGE
FROM USERS u
GROUP BY u.ID, u.NAME, u.AGE

      groupings set is missing
       

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4665 Allow Aggregate.groupSet to contain columns not in any of the groupSets

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              jiajunbernoulli Jiajun Xie
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: