zenoyang opened a new issue, #9120: URL: https://github.com/apache/incubator-doris/issues/9120
### 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 master ### What's Wrong? If the cache is turned on(enable_sql_cache=true), if the two sql contents are only different in Chinese, and the Chinese length is the same, the wrong cached result will be queried. ### What You Expected? Correct cached results. ### How to Reproduce? ```sql set enable_sql_cache=true; ADMIN SET FRONTEND CONFIG ('cache_last_version_interval_second' = '0'); create database db1; use db1; CREATE TABLE `tbl1` ( k1 INT DEFAULT '0', k2 VARCHAR(32) DEFAULT '', k3 BIGINT SUM DEFAULT '0' ) AGGREGATE KEY(k1, k2) DISTRIBUTED BY HASH(k1) BUCKETS 10 PROPERTIES("replication_num" = "1"); insert into tbl1 values(1, '北京', 1); mysql> select * from tbl1 where k2='北京'; +------+--------+------+ | k1 | k2 | k3 | +------+--------+------+ | 1 | 北京 | 1 | +------+--------+------+ mysql> select * from tbl1 where k2='上海'; +------+--------+------+ | k1 | k2 | k3 | +------+--------+------+ | 1 | 北京 | 1 | +------+--------+------+ ``` ### Anything Else? none ### Are you willing to submit PR? - [X] 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]
