[jira] [Created] (CALCITE-5470) VolcanoPlanner removes a necessary sort

["Thomas Rebele (Jira)" <ji...@apache.org>]

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)