You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "mrhhsg (via GitHub)" <gi...@apache.org> on 2023/03/08 10:03:32 UTC

[GitHub] [doris] mrhhsg opened a new issue, #17568: [Bug] Got incorrect result with scan keys for boolean column

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

   ### 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
   
   * master
   * 1.2
   
   ### What's Wrong?
   
   1. create the table and insert data:
   ```sql
   create table test_null (id boolean null,value int null) duplicate key(id) DISTRIBUTED BY HASH(id) buckets 1 PROPERTIES ("replication_allocation" = "tag.location.default: 1");
   
   insert into test_null values(1, null), (1,1), (null, 2), (1,2), (0, 3), (0, 4);
   ```
   2. check the table's rows
   ```sql
   select * from test_null;
   ```
   got result:
   ```
   +------+-------+
   | id   | value |
   +------+-------+
   | NULL |     2 |
   |    0 |     4 |
   |    0 |     3 |
   |    1 |     2 |
   |    1 |     1 |
   |    1 |  NULL |
   +------+-------+
   ```
   
   3. test with `is null`
   ```sql
   select * from test_null where id is null;
   ```
   got result:
   ```
   +------+-------+
   | id   | value |
   +------+-------+
   | NULL |     2 |
   |    0 |     4 |
   |    0 |     3 |
   +------+-------+
   ```
   
   ### What You Expected?
   
   got result:
   ```
   +------+-------+
   | id   | value |
   +------+-------+
   | NULL |     2 |
   +------+-------+
   ```
   
   ### How to Reproduce?
   
   _No response_
   
   ### 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] yiguolei closed issue #17568: [Bug] Got incorrect result with scan keys for boolean column

Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei closed issue #17568: [Bug] Got incorrect result with scan keys for boolean column
URL: https://github.com/apache/doris/issues/17568


-- 
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