Wang Yanlin created CALCITE-3664: ------------------------------------ Summary: Lost sort in subquery when converting SqlNode to Relnode Key: CALCITE-3664 URL: https://issues.apache.org/jira/browse/CALCITE-3664 Project: Calcite Issue Type: Bug Reporter: Wang Yanlin
Lost sort in subquery when converting a SqlNode to Relnode, making its semantics changed. The test case to reproduce {code:java} // SqlToRelConverterTest @Test public void testSortInSubquery() { final String sql = "select ename from (select ename from emp order by ename) a"; sql(sql).ok(); } {code} This test case will success with this plan. {code:java} <TestCase name="testSortInSubquery"> <Resource name="sql"> <![CDATA[select ename from (select ename from emp order by ename) a]]> </Resource> <Resource name="plan"> <![CDATA[ LogicalProject(ENAME=[$1]) LogicalTableScan(table=[[CATALOG, SALES, EMP]]) ]]> </Resource> </TestCase> {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)