TANG Wen-hui created CALCITE-3154:
-------------------------------------
Summary: RelToSqlConverter generated Nulls Last and Nulls First
when convert RexOver to sql using MysqlSqlDialect.
Key: CALCITE-3154
URL: https://issues.apache.org/jira/browse/CALCITE-3154
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.19.0
Reporter: TANG Wen-hui
Assignee: TANG Wen-hui
As for sql :
{code:java}
String query = "SELECT row_number() over (order by \"hire_date\") FROM
\"employee\"";
{code}
using RelToSqlConverter to generate a sql for mysql , the result is :
{code:java}
SELECT ROW_NUMBER() OVER (ORDER BY `hire_date` NULLS LAST)
FROM `foodmart`.`employee`
{code}
However, mysql does not support NULLS LAST.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
