[
https://issues.apache.org/jira/browse/CALCITE-542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14251673#comment-14251673
]
Jesus Camacho Rodriguez edited comment on CALCITE-542 at 12/18/14 2:17 PM:
---------------------------------------------------------------------------
Just to clarify, the problem in the test query:
{noformat}
SELECT TABLE1.ID, TABLE2.ID FROM
(SELECT GROUPING(A) AS ID FROM T1
GROUP BY ROLLUP(A,B)) TABLE1
JOIN
(SELECT GROUPING(A) AS ID FROM T1
GROUP BY ROLLUP(A,B)) TABLE2 "
ON TABLE1.ID = TABLE2.ID
{noformat}
is in the results, not in the metadata. In particular:
{code:xml}
Expected: <[ID=1; ID=1, ID=0; ID=0]>
but: was <[ID=1; ID=1, ID=0; ID=0 x 25]>
{code}
If you agree, I can skip the results check in this test, and open a new JIRA
for this.
was (Author: jcamachorodriguez):
Just to clarify, the problem in the test query:
{noformat}
SELECT TABLE1.ID, TABLE2.ID FROM
(SELECT GROUPING(A) AS ID FROM T1
GROUP BY ROLLUP(A,B)) TABLE1
JOIN
(SELECT GROUPING(A) AS ID FROM T1
GROUP BY ROLLUP(A,B)) TABLE2 "
ON TABLE1.ID = TABLE2.ID
{noformat}
is in the results, not in the metadata. In particular:
{noformat}
Expected: <[ID=1; ID=1, ID=0; ID={color=red}0{color}]>
but: was <[ID=1; ID=1, ID=0; ID={color=red}0 x 25{color}]>
{noformat}
If you agree, I can skip the results check in this test, and open a new JIRA
for this.
> Support for Aggregate with grouping sets in RelMdColumnOrigins
> --------------------------------------------------------------
>
> Key: CALCITE-542
> URL: https://issues.apache.org/jira/browse/CALCITE-542
> Project: Calcite
> Issue Type: Bug
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
>
> When we call {{getColumnOrigins}} on an {{Aggregate}} operator with grouping
> sets, an error arrises if we are trying to derive the origin of an indicator
> column associated to a grouping column.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
