-
Notifications
You must be signed in to change notification settings - Fork 3.8k
Open
Description
neither postgres / modern syntax
SELECT DIM_ISO3, c.NAMEWORKEN, INDICATOR, YEAR, Sum(VALUE) AS Total
FROM pipeline_examples.RLS_DATA r WITH (NOLOCK)
INNER JOIN [pipeline_examples].[REF_COUNTRIES] c WITH (NOLOCK)
ON c.CODE = r.DIM_ISO3
GROUP BY ROLLUP(DIM_ISO3, c.NAMEWORKEN, INDICATOR, YEAR)or legacy WITH ROLLUP syntax
SELECT DIM_ISO3, c.NAMEWORKEN, INDICATOR, YEAR, Sum(VALUE) AS Total
FROM pipeline_examples.RLS_DATA r WITH (NOLOCK)
INNER JOIN [pipeline_examples].[REF_COUNTRIES] c WITH (NOLOCK)
ON c.CODE = r.DIM_ISO3
GROUP BY DIM_ISO3, c.NAMEWORKEN, INDICATOR, YEAR WITH ROLLUPare supported.
Same for ROLLUP, CUBE specification of SQL Server.
as we can see the lines are commented out in the PARSER
grammars-v4/sql/tsql/TSqlParser.g4
Lines 4081 to 4086 in ec9ccb7
| group_by_item | |
| : expression | |
| /*| rollup_spec | |
| | cube_spec | |
| | grouping_sets_spec | |
| | grand_total*/ |
Will push the fix in the same branch than my current PR #4651
Metadata
Metadata
Assignees
Labels
No labels