13671653088 opened a new issue #8741: URL: https://github.com/apache/incubator-doris/issues/8741
### 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 PALO-1.0.0-preview2 ### What's Wrong? column = 1.0 可以查询出整型字段中值为1得内容 column = 0.0无法查出 涉及bigint int tinyint booleanl类型 ### What You Expected? 能正常查询出数值 ### How to Reproduce? drop table test.ingtest; CREATE TABLE test.ingtest ( id int NOT NULL COMMENT "", a varchar(50) NOT NULL COMMENT "", b int NOT NULL COMMENT "", c bigint NOT NULL COMMENT "", d tinyint NOT NULL COMMENT "", e boolean NOT NULL COMMENT "", f float NOT NULL COMMENT "", g double NOT NULL COMMENT "" ) ENGINE=OLAP duplicate KEY( id) COMMENT "OLAP" DISTRIBUTED BY HASH(id) BUCKETS 12 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "in_memory" = "false", "storage_format" = "V2" ); insert into test.ingtest select 1,'1.0',1,1,1,1,1,1; insert into test.ingtest select 2,'0.0',0,0,0,0,0,0; select * from test.ingtest where a= 1; select * from test.ingtest where b= 1.0; select * from test.ingtest where c= 1.0; select * from test.ingtest where d= 1.0; select * from test.ingtest where e= 1.0; select * from test.ingtest where f= 1.0; select * from test.ingtest where g= 1.0; select * from test.ingtest where a= 0; select * from test.ingtest where b= 0.0; select * from test.ingtest where c= 0.0; select * from test.ingtest where d= 0.0; select * from test.ingtest where e= 0.0; select * from test.ingtest where f= 0.0; select * from test.ingtest where g= 0.0; ### 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]
