Etienne Pelissier created CALCITE-7934:
------------------------------------------

             Summary: Aggregate uniqueness metadata uses incorrect column 
ordinals
                 Key: CALCITE-7934
                 URL: https://issues.apache.org/jira/browse/CALCITE-7934
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Etienne Pelissier


Broken quidem test:
{code:java}
!set hep-rules "
+CoreRules.AGGREGATE_PROJECT_MERGE,
+CoreRules.AGGREGATE_REMOVE"

select distinct count(*) filter (where col1) as s
from (values
    (true, 1),
    (true, 2)) as t(col1, col2)
group by col2;
+---+
| S |
+---+
| 1 |
+---+
(1 row){code}
The result produced by Calcite contains two rows instead of one.



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

Reply via email to