yuxuan-luo opened a new issue, #30205: URL: https://github.com/apache/doris/issues/30205
### 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 1.2.8 ### What's Wrong? CREATE TABLE `test` ( `id` bigint(20) NOT NULL COMMENT '主键ID', `score` decimalv3(3, 1) NULL , `score_new` decimalv3(4, 1) NULL ) ENGINE=OLAP UNIQUE KEY(`id`) DISTRIBUTED BY HASH(`id`) BUCKETS 2 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "in_memory" = "false", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false" ); MySQL [hugo]> select * from test ua where ua.score =100; ERROR 1105 (HY000): errCode = 2, detailMessage = (172.16.49.160)[INVALID_ARGUMENT] MySQL [hugo]> select * from test ua where ua.score =100.0; Empty set (0.00 sec) decimalv3 类型，在1.2上作为 where 语句条件查询时需要与类型严格匹配，不能写 100 只能写 100.0 ，但是 2.0 可以写 100 ### What You Expected? 与 2.0 保持一致 ### How to Reproduce? _No response_ ### 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]
