You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/07/01 09:23:59 UTC

[GitHub] [doris] luozenglin opened a new issue, #10544: [Bug] BinaryPredicate contains DecimalLiteral in some cases can not query the data

luozenglin opened a new issue, #10544:
URL: https://github.com/apache/doris/issues/10544

   ### 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?
   
   BinaryPredicate contains DecimalLiteral in some cases can not query the data.
   
   ### What You Expected?
   
   Return the correct query result.
   
   ### How to Reproduce?
   
   ```
   CREATE TABLE `cost2` (
     `id` bigint(20) NULL COMMENT "",
     `cost` bigint(20) SUM NULL COMMENT ""
   ) ENGINE=OLAP
   AGGREGATE KEY(`id`)
   COMMENT "OLAP"
   DISTRIBUTED BY HASH(`id`) BUCKETS 8
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   
   insert into cost2 values(1, 100);
   insert into cost2 values(12345678901, 100);
   
   mysql> select * from cost2;
   +-------------+------+
   | id          | cost |
   +-------------+------+
   | 12345678901 |  100 |
   |           1 |  100 |
   +-------------+------+
   2 rows in set (0.05 sec)
   
   mysql> select * from cost2 where id = 1.0;
   +------+------+
   | id   | cost |
   +------+------+
   |    1 |  100 |
   +------+------+
   1 row in set (0.04 sec)
   
   mysql> select * from cost2 where id = 12345678901.0;
   Empty set (0.04 sec)
   ```
   
   ### Anything Else?
   
   _No response_
   
   ### 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: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] EmmyMiao87 closed issue #10544: [Bug] BinaryPredicate contains DecimalLiteral in some cases can not query the data

Posted by GitBox <gi...@apache.org>.
EmmyMiao87 closed issue #10544: [Bug] BinaryPredicate contains DecimalLiteral in some cases can not query the data
URL: https://github.com/apache/doris/issues/10544


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org