Thomas Rebele created CALCITE-5470:
--------------------------------------
Summary: VolcanoPlanner removes a necessary sort
Key: CALCITE-5470
URL: https://issues.apache.org/jira/browse/CALCITE-5470
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.32.0
Reporter: Thomas Rebele
A logical plan that roughly corresponds to SELECT a*a FROM
(VALUES(-10),(2),(3)) T(a) ORDER BY a*a produces a physical plan that is not
sorted:
{noformat}
logical plan:
LogicalSort(sort0=[$0], dir0=[ASC])
LogicalProject($f0=[*($0, $0)])
LogicalValues(tuples=[[{ -10 }, { 2 }, { 3 }]])
{noformat}
The result should be 4, 9, 100.
{noformat}
physical plan:
EnumerableProject($f0=[*($0, $0)])
EnumerableValues(tuples=[[{ -10 }, { 2 }, { 3 }]]){noformat}
If I understand the physical plan correctly, its result would be 100, 4, 9.
Using sqlline gives the correct result (see attached log), so the problem could
be in the test itself.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
