[jira] [Created] (CALCITE-3154) RelToSqlConverter generated Nulls Last and Nulls First when convert RexOver to sql using MysqlSqlDialect.

["TANG Wen-hui (JIRA)" <ji...@apache.org>]

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)