[Bug] order by time field by value is null will casue be process exit.

McClone commented 11 months ago

Search before asking

[X] I had searched in the issues and found no similar issues.

Version

2.0.1

What's Wrong?

order by time field by value is null will casue be process exit.

What You Expected?

order by time field by value is null will casue be process not exit.

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

[ ] Yes I am willing to submit a PR!

Code of Conduct

[X] I agree to follow this project's Code of Conduct

DongLiang-0 commented 11 months ago

Can you provide the specific BE error information? It would be better if the corresponding query statements and table creation statements could be provided.

wyx123654 commented 11 months ago

CREATE TABLEtbl1( idbigint(20) NOT NULL, birthdate NULL , moneybigint(20) SUM NULL DEFAULT "0", ) ENGINE=OLAP AGGREGATE KEY(id,birth) COMMENT 'OLAP' DISTRIBUTED BY HASH(id`) BUCKETS 3 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "is_being_synced" = "false", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false"

insert into tbl1 values (1,null,1),(2,'2020-06-09',2),(3,null,3),(4,'2021-04-28',4)

select * from tbl1 order by birth; ` Version 2.0.1 can run normally, you can send your case.

apache / doris