[
https://issues.apache.org/jira/browse/CALCITE-969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15006197#comment-15006197
]
Julian Hyde commented on CALCITE-969:
-------------------------------------
[~liyang.g...@gmail.com], Can you post the EXPLAIN of each of the queries?
> Order by (A, B) and order by (A) treats NULL differently
> --------------------------------------------------------
>
> Key: CALCITE-969
> URL: https://issues.apache.org/jira/browse/CALCITE-969
> Project: Calcite
> Issue Type: Bug
> Reporter: liyang
> Assignee: Julian Hyde
>
> NULL first or NULL last is not clearly defined by sql spec, but should be
> consistent in calcite.
> I spot order by (A desc) returns NULL last, but order by (A desc, B) returns
> NULL first.
> E.g. "select cal_dt, country, ... from xxx order by COUNTRY DESC" returns
> 2013-08-11 US ....
> 2013-08-18 FR ....
> 2013-03-31 null ....
> 2013-11-10 null ....
> E.g. "select cal_dt, country, ... from xxx order by COUNTRY DESC, CAL_DT
> ASC" returns
> 2013-03-31 null ....
> 2013-11-10 null ....
> 2013-08-11 US ....
> 2013-08-18 FR ....
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
