You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "Zhenning Zhang (Jira)" <ji...@apache.org> on 2022/10/20 07:16:00 UTC
[jira] [Created] (KYLIN-5279) Default null collation for Kylin5.0 sqls should be null-last for ASC order and null-first for DESC order.
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)