[Bug] decimalv3 as query condition type #30205
Description
Search before asking
- I had searched in the issues 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
- I agree to follow this project's Code of Conduct