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 2020/08/22 02:42:15 UTC
[GitHub] [incubator-doris] chaoyli opened a new issue #4426: Wrong answer of boolean type
chaoyli opened a new issue #4426:
URL: https://github.com/apache/incubator-doris/issues/4426
```
CREATE TABLE t1 (c0 BOOLEAN NOT NULL )
AGGREGATE KEY (c0)
DISTRIBUTED BY HASH (c0)
buckets 3
properties("replication_num"="1") ;
```
----------------------------------------------------------------
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.
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] [incubator-doris] chaoyli commented on issue #4426: Wrong answer of boolean type
Posted by GitBox <gi...@apache.org>.
chaoyli commented on issue #4426:
URL: https://github.com/apache/incubator-doris/issues/4426#issuecomment-678583028
```
INSERT INTO t1 VALUES (true), (false);
```
```
select c0 from t1 where c0 = 0;
+------+
| c0 |
+------+
| 0 |
+------+
```
----------------------------------------------------------------
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.
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] [incubator-doris] yangzhg commented on issue #4426: Wrong answer of boolean type
Posted by GitBox <gi...@apache.org>.
yangzhg commented on issue #4426:
URL: https://github.com/apache/incubator-doris/issues/4426#issuecomment-681624709
there also has another bug https://github.com/apache/incubator-doris/issues/4276
----------------------------------------------------------------
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.
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] [incubator-doris] chaoyli commented on issue #4426: Wrong answer of boolean type
Posted by GitBox <gi...@apache.org>.
chaoyli commented on issue #4426:
URL: https://github.com/apache/incubator-doris/issues/4426#issuecomment-678583069
You should set buckets > 2 to reproduce the bug.
----------------------------------------------------------------
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.
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] [incubator-doris] chaoyli edited a comment on issue #4426: Wrong answer of boolean type
Posted by GitBox <gi...@apache.org>.
chaoyli edited a comment on issue #4426:
URL: https://github.com/apache/incubator-doris/issues/4426#issuecomment-678583028
```
INSERT INTO t1 VALUES (true), (false);
```
```
select c0 from t1 where c0 = 0;
+------+
| c0 |
+------+
| 0 |
+------+
```
```
SELECT c0 FROM t1 where c0 = false;
Empty set (0.00 sec)
```
----------------------------------------------------------------
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.
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