yongjinhou opened a new issue, #39777: URL: https://github.com/apache/doris/issues/39777
### 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.0.12 & 2.0.13 ### What's Wrong? 过滤条件中varchar字段加引号与不加引号查询结果不一致，加引号后的查询结果是错误的。 <img width="985" alt="image" src="https://github.com/user-attachments/assets/ae9b7b79-546e-47db-b620-5b9743faf751";> ### What You Expected? 过滤条件中varchar字段加引号与不加引号查询结果一致且结果正确 ### How to Reproduce? 1. 建表 `CREATE TABLE `temp_table` ( `event_day` date NOT NULL DEFAULT "0000-01-01" COMMENT '日期分区', `user_id` VARCHAR(200) NOT NULL DEFAULT "0" COMMENT '用户id', `source` VARCHAR(200) NOT NULL DEFAULT "yiyan" COMMENT '来源,yiyan,qianfan,dasou' ) ENGINE=OLAP DUPLICATE KEY(`event_day`, `user_id`) DISTRIBUTED BY HASH(`event_day`) BUCKETS 10 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "is_being_synced" = "false", "storage_medium" = "hdd", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" );` 2. 导入数据 `insert into temp_table values("2023-03-10","118454562","baidu"),("2023-03-10","1275155607","baidu"),("2023-03-10","133566964","baidu");` 3. 查询 select user_id from temp_table where NOT ( user_id BETWEEN 118454562 AND 133566964 ); select user_id from temp_table where NOT ( user_id BETWEEN "118454562" AND "133566964" ); ### Anything Else? 无 ### 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]
