[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
luoping.zhang updated CALCITE-5656: ----------------------------------- Summary: RelToSqlConverter has an error using ordinal for ORDER BY (was: RelToSqlConverter has an error using ordinal ORDER BY) > RelToSqlConverter has an error using ordinal for 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 > Priority: Critical > > 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)