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)