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)