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

Posted to dev@calcite.apache.org by "EveyWu (Jira)" <ji...@apache.org> on 2024/01/19 15:59:00 UTC

[jira] [Created] (CALCITE-6213) The default behavior of NullCollation in Presto is LAST

EveyWu created CALCITE-6213:
-------------------------------

             Summary: The default behavior of NullCollation in Presto is LAST
                 Key: CALCITE-6213
                 URL: https://issues.apache.org/jira/browse/CALCITE-6213
             Project: Calcite
          Issue Type: Bug
            Reporter: EveyWu
         Attachments: image-2024-01-19-23-54-26-383.png, image-2024-01-19-23-57-00-252.png

[https://prestodb.io/docs/0.285/sql/select.html]

Presto default null ordering is NULLS LAST

!image-2024-01-19-23-54-26-383.png|width=511,height=168!

 

Demo：select by presto with nulls last 
{code:java}
select * from product order by brand_name; {code}
!image-2024-01-19-23-57-00-252.png|width=517,height=83!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)