gj-zhang opened a new issue, #9544: URL: https://github.com/apache/incubator-doris/issues/9544
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version 1.0.0-rc03 ### What's Wrong?  ### What You Expected? result one row ### How to Reproduce? ```sql CREATE TABLE `left_table` ( `id` text NULL COMMENT "", `device_id` text NULL COMMENT "" ) ENGINE = OLAP UNIQUE KEY(`id`) COMMENT "OLAP" DISTRIBUTED BY HASH(`id`) BUCKETS 4 PROPERTIES ( "replication_allocation" = "tag.location.default: 2", "in_memory" = "false", "storage_format" = "V2" ); insert into left_table values ('1', '1'),('2', '2'), ('3', '3'), ('4', '4'); CREATE TABLE `right_table` ( `device_id` text NULL COMMENT "", `device_name` text NULL COMMENT "" ) ENGINE = OLAP UNIQUE KEY(`device_id`) COMMENT "OLAP" DISTRIBUTED BY HASH(`device_id`) BUCKETS 4 PROPERTIES ( "replication_allocation" = "tag.location.default: 2", "in_memory" = "false", "storage_format" = "V2" ); insert into right_table values ('1', 'device_name1'), ('3', null); select count(left_table.device_id), rt.device_name from left_table left join right_table rt on left_table.device_id = rt.device_id where rt.device_name is null group by rt.device_name order by rt.device_name nulls first ``` ### 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](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
