[
https://issues.apache.org/jira/browse/CALCITE-3154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
TANG Wen-hui updated CALCITE-3154:
----------------------------------
Description:
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.
was:
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.
> 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
> Priority: Major
>
> 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)
