[jira] [Created] (CALCITE-5656) RelToSqlConverter has an error using ordinal ORDER BY

["luoping.zhang (Jira)" <ji...@apache.org>]

luoping.zhang created CALCITE-5656:
--------------------------------------

             Summary: RelToSqlConverter has an error using ordinal ORDER BY
                 Key: CALCITE-5656
                 URL: https://issues.apache.org/jira/browse/CALCITE-5656
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.34.0
            Reporter: luoping.zhang


 For example:
Query SQL is 
{code:java}
 select a from table order by coalesce(a,b){code}
When we convert this sql to relNode and convert it back to SQL by RelToConverter, the result is:
{code:java}
select a from table order by 2{code}
But this sql syntax is wrong because there is no ordinal 2



--
This message was sent by Atlassian Jira
(v8.20.10#820010)