[CALCITE-6213] The default behavior of NullCollation in Presto is LAST

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.37.0
• Labels: pull-request-available
• Assignee: EveyWu
• Reporter: EveyWu
• Created: 19/Jan/24 15:58
• Updated: 06/May/24 22:19
• Resolved: 24/Jan/24 09:54

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; 

Issue Links

• links to: GitHub Pull Request #3639