ChaseHuangxu opened a new issue, #19614: URL: https://github.com/apache/doris/issues/19614
### 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 Apache Doris 1.2.2 RELEASE ### What's Wrong? I'm trying to add Apache Doris support to SQLancer, this may be a logic bug found by @[SQLancer](https://github.com/sqlancer/sqlancer). In the two SQL statements in the figure below, the left side shows the result of t1 and t2 join, it's correct. But if I add select `select 'Up6hGly' like t1.c` in SQL statement, the query result is as shown in the right figure, the actual result is all 0, but from the logic there should be a record of 1, which is a very strange bug <img width="581" alt="image" src="https://github.com/apache/doris/assets/91189188/a8518ef0-c990-49d1-9416-851201404fb4";> ### What You Expected? The result of `select 'Up6hGly' like t1.c0 from t1, t2;` SQL statement should be: +--------------------------+ | 'Up6hGly' LIKE `t1`.`c0` | +--------------------------+ | 0 | | 0 | | 1 | | 0 | | 0 | | 0 | +--------------------------+ 6 rows in set (0.02 sec) ### How to Reproduce? You can reproduce this error from the following steps. 1. data prepare ``` CREATE TABLE t1(c0 VARCHAR(141)) UNIQUE KEY(c0) DISTRIBUTED BY HASH (c0) BUCKETS 28 PROPERTIES ("replication_num" = "1"); CREATE TABLE t2(c0 DATE) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); INSERT INTO t1 (c0) VALUES (''),('fe8lih'),('LaZV'), ('M'), ('HlxfTe'), ('Up6hGly'); INSERT INTO t2 (c0) VALUES (DATE '1970-10-15'); ``` 2. check table datas <img width="229" alt="image" src="https://github.com/apache/doris/assets/91189188/2f4b9486-cb30-4cb3-b393-b28b145e1b5f";> 3. execute `select 'Up6hGly' like t1.c0 from t1;`, the result below is correct <img width="318" alt="image" src="https://github.com/apache/doris/assets/91189188/f2e9a9f9-4b6c-4e38-8e99-ed7ca610c417";> 4. execute `select 'Up6hGly' like t1.c0 from t1, t2;`, the result below is wrong, there should be a record that is 1. <img width="667" alt="image" src="https://github.com/apache/doris/assets/91189188/fc65a7df-4b08-47be-8c29-b3a33585fb5b";> ### 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
