You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "liyang (JIRA)" <ji...@apache.org> on 2015/11/16 03:48:10 UTC

[jira] [Created] (CALCITE-969) Order by (A, B) and order by (A) treats NULL differently

liyang created CALCITE-969:
------------------------------

             Summary: 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)