malwaregarry opened a new issue, #36343: URL: https://github.com/apache/doris/issues/36343
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.1.4 ### What's Wrong? Could be related to #36072 ``` CREATE TABLE t0(c0 INT) UNIQUE KEY(c0) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); CREATE TABLE t1(c0 INT NOT NULL) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); INSERT INTO t0 (c0) VALUES (1); ``` This returns value 0, but there is no value 0 in t1.c0: `SELECT DISTINCT t1.c0 FROM t0 LEFT JOIN t1 ON (true) WHERE ((t1.c0) IS NULL);` ### What You Expected? This returns null: `SELECT DISTINCT t1.c0 FROM t0 LEFT JOIN t1 ON (true) WHERE ((t1.c0) IS NULL);` ### How to Reproduce? ``` DROP DATABASE IF EXISTS doris2; CREATE DATABASE doris2; USE doris2; CREATE TABLE t0(c0 INT) UNIQUE KEY(c0) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); CREATE TABLE t1(c0 INT NOT NULL) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); INSERT INTO t0 (c0) VALUES (1); SELECT DISTINCT t1.c0 FROM t0 LEFT JOIN t1 ON (true); SELECT DISTINCT t1.c0 FROM t0 LEFT JOIN t1 ON (true) WHERE ((t1.c0) IS NULL); ``` ### 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]
