[KYLIN-5279] Default null collation for Kylin5.0 sqls should be null-last for ASC order and null-first for DESC order. - ASF JIRA

Agile Board

Attach files

Attach Screenshot

Voters

Stop watching

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 5.0-alpha
Component/s: Query Engine
Labels:
None

Description

according to pgsql: https://www.postgresql.org/docs/current/queries-order.html

"By default, null values sort as if larger than any non-null value; that is, NULLS FIRST is the default for DESC order, and NULLS LAST otherwise."

currently, the result is:

Attachments

image-2022-10-20-15-12-12-967.png
20/Oct/22 07:12
276 kB
Zhenning Zhang

Activity

Comment

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

Cancel

People

Assignee:: Zhenning Zhang

Reporter:: Zhenning Zhang

Votes:: 0 Vote for this issue

Watchers:: 4 Stop watching this issue

Dates

Created:: 20/Oct/22 07:15

Updated:: 29/Mar/23 06:46

Resolved:: 29/Mar/23 06:46

Agile

View on Board

Default null collation for Kylin5.0 sqls should be null-last for ASC order and null-first for DESC order.

Details

Description

Attachments

Attachments

Activity

People

Dates

Agile

Slack

Issue deployment