malwaregarry opened a new issue, #36342: URL: https://github.com/apache/doris/issues/36342
### 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? if there is a where clause with `(TIMESTAMP 'CURRENT_TIMESTAMP' IS NULL);`, we might retrieve records not in the original select without the where clause. ``` CREATE TABLE t0(c0 INT) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); CREATE TABLE t1(c0 INT) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); INSERT INTO t0 (c0) VALUES (1); INSERT INTO t1 (c0) VALUES (1); ``` This returns 0 rows: `SELECT t1.c0, t0.c0 FROM t1 INNER JOIN t0 ON (false) GROUP BY t1.c0, t0.c0;` This returns 1 row `SELECT t1.c0 FROM t0 INNER JOIN t1 ON (false) WHERE (TIMESTAMP 'CURRENT_TIMESTAMP' IS NULL);` The bug also exists for HAVING clauses ### What You Expected? a where / having clause should only reduce the number of records returned ### How to Reproduce? ``` DROP DATABASE IF EXISTS doris0; CREATE DATABASE doris0; USE doris0; CREATE TABLE t0(c0 int) DISTRIBUTED BY RANDOM PROPERTIES ("replication_num" = "1"); CREATE TABLE t1(c0 int) DISTRIBUTED BY RANDOM PROPERTIES ("replication_num" = "1"); INSERT INTO t1 (c0) VALUES (1); INSERT INTO t0 (c0) VALUES (1); SELECT t1.c0 FROM t0 INNER JOIN t1 ON (false); SELECT t1.c0 FROM t0 INNER JOIN t1 ON (false) WHERE (TIMESTAMP 'CURRENT_TIMESTAMP' IS NULL); ``` ``` DROP DATABASE IF EXISTS doris1; CREATE DATABASE doris1; USE doris1; CREATE TABLE t0(c0 INT) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); CREATE TABLE t1(c0 INT) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); INSERT INTO t0 (c0) VALUES (1); INSERT INTO t1 (c0) VALUES (1); SELECT t1.c0, t0.c0 FROM t1 INNER JOIN t0 ON (false) GROUP BY t1.c0, t0.c0; SELECT t1.c0, t0.c0 FROM t1 INNER JOIN t0 ON (false) GROUP BY t1.c0, t0.c0 HAVING ((TIMESTAMP 'CURRENT_TIMESTAMP') 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]
