Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6213

The default behavior of NullCollation in Presto is LAST

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.37.0
    • None

    Description

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

      Presto default null ordering is NULLS LAST

       

      Demo：select by presto with nulls last 

      select * from product order by brand_name;

      Attachments

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            eveywu EveyWu
            eveywu EveyWu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment