Zhenning Zhang created KYLIN-5279:
-------------------------------------
Summary: Default null collation for Kylin5.0 sqls should be
null-last for ASC order and null-first for DESC order.
Key: KYLIN-5279
URL: https://issues.apache.org/jira/browse/KYLIN-5279
Project: Kylin
Issue Type: Bug
Components: Query Engine
Reporter: Zhenning Zhang
Assignee: Zhenning Zhang
Fix For: 5.0-alpha
Attachments: image-2022-10-20-15-12-12-967.png
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:
!image-2022-10-20-15-12-12-967.png|width=1320,height=743!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
