Zhimin Wu created KYLIN-5830: -------------------------------- Summary: When the query connects two or more tables, the query results are inconsistent whether the order by field is in the select field or not Key: KYLIN-5830 URL: https://issues.apache.org/jira/browse/KYLIN-5830 Project: Kylin Issue Type: New Feature Components: Query Engine Affects Versions: 5.0-beta Reporter: Zhimin Wu Assignee: Zhimin Wu Fix For: 5.0.0
Q1: {{}} {code:java} select CUSTOMER.C_PHONE -- ,LO_PARTKEY from SSB.CUSTOMER left join SSB.LINEORDER on CUSTOMER.C_CUSTKEY=LINEORDER.LO_CUSTKEY order by LINEORDER.LO_PARTKEY NULLS LAST LIMIT 500{code} {{}} Calcite Plan: {{}} {code:java} KapProjectRel(C_PHONE=[$6], ctx=[]) KapLimitRel(ctx=[], fetch=[500]) KapSortRel(sort0=[$12], dir0=[ASC], ctx=[]) KapJoinRel(condition=[=($0, $11)], joinType=[left], ctx=[]) KapTableScan(table=[[SSB, CUSTOMER]], ctx=[1@NDataflow [test]], fields=[[0, 1, 2, 3, 4, 5, 6, 7, 8]]) KapTableScan(table=[[SSB, LINEORDER]], ctx=[2@NDataflow [test1]], fields=[[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17]]){code} {{}} Q2: {{}} {code:java} select CUSTOMER.C_PHONE ,LO_PARTKEY from SSB.CUSTOMER left join SSB.LINEORDER on CUSTOMER.C_CUSTKEY=LINEORDER.LO_CUSTKEY order by LINEORDER.LO_PARTKEY NULLS LAST LIMIT 500{code} {{}} Calcite Plan {{}} {code:java} KapLimitRel(ctx=[], fetch=[500]) KapSortRel(sort0=[$1], dir0=[ASC], ctx=[]) KapProjectRel(C_PHONE=[$6], LO_PARTKEY=[$12], ctx=[]) KapJoinRel(condition=[=($0, $11)], joinType=[left], ctx=[]) KapTableScan(table=[[SSB, CUSTOMER]], ctx=[1@NDataflow [test]], fields=[[0, 1, 2, 3, 4, 5, 6, 7, 8]]) KapTableScan(table=[[SSB, LINEORDER]], ctx=[2@NDataflow [test1]], fields=[[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17]]) {code} {{}} -- This message was sent by Atlassian Jira (v8.20.10#820010)