[
https://issues.apache.org/jira/browse/CALCITE-969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-969:
--------------------------------
Summary: EnumerableSort with DESC, composite reverses NULLS FIRST/LAST
(was: Order by (A, B) and order by (A) treats NULL differently)
> EnumerableSort with DESC, composite reverses NULLS FIRST/LAST
> -------------------------------------------------------------
>
> Key: CALCITE-969
> URL: https://issues.apache.org/jira/browse/CALCITE-969
> Project: Calcite
> Issue Type: Bug
> Reporter: liyang
> Assignee: Julian Hyde
> Fix For: 1.6.0
>
>
> 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)
