calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rui Wang (Jira)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-4021) EnumerableUnion should preserve ordering when all inputs have the same collation
Date Sat, 23 May 2020 17:31:00 GMT
Rui Wang created CALCITE-4021:
---------------------------------

             Summary: EnumerableUnion should preserve ordering when all inputs have the same
collation
                 Key: CALCITE-4021
                 URL: https://issues.apache.org/jira/browse/CALCITE-4021
             Project: Calcite
          Issue Type: Improvement
            Reporter: Rui Wang


For query:

"select name from sales_dept
union 
select name from it_dept
order by mgr"

We could generate a plan based on https://issues.apache.org/jira/browse/CALCITE-4017:

{code:java}
EnumerableUnion
    EnumerableProject
        EnumerableSort
           EnumerableTableScan[name="sales_dept"]
    EnumerableProject
        EnumerableSort
           EnumerableTableScan[name="it_dept"]
{code}

So EnumerableUnion should preserve ordering when all input have the same collation to make
sure result of query is correct.





--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message