You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "codenohup (via GitHub)" <gi...@apache.org> on 2023/05/08 05:12:11 UTC
[GitHub] [doris] codenohup opened a new issue, #19374: [Bug] Different result of `having not ($value in column)` and `having ($value not in column)`
codenohup opened a new issue, #19374:
URL: https://github.com/apache/doris/issues/19374
### 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
Apache Doris 1.2.2 RELEASE
### What's Wrong?
I'm trying to add Apache Doris support to SQLancer, this may be a logic bug found by @[SQLancer](https://github.com/sqlancer/sqlancer).
These two similar SQL statements obtained different results, which is confusing.
1. `select t11.c0 from t11 group by t11.c0 having not ('1' in (t11.c0));`
2. `select t11.c0 from t11 group by t11.c0 having ('1' not in (t11.c0));`
### What You Expected?
I think these two similar SQL statements should have the same result, and I guess this error is due to incorrect execution of the `"having $value in column sentense` statement
### How to Reproduce?
You can reproduce this error from the following steps.
1. data prepare
```
CREATE TABLE t11(c0 CHAR(109) NOT NULL) DISTRIBUTED BY HASH (c0) BUCKETS 13 PROPERTIES ("replication_num" = "1");
insert into t11 values ('1'), ('1'), ('2'), ('2'), ('3'), ('4');
```
2. `select t11.c0 from t11 group by t11.c0 having ('1' not in (t11.c0));`
3. `select t11.c0 from t11 group by t11.c0 having not ('1' in (t11.c0));`
### Anything Else?
_No response_
### 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: 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] morrySnow closed issue #19374: [Bug] Different result of `having not ($value in column)` and `having ($value not in column)`
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow closed issue #19374: [Bug] Different result of `having not ($value in column)` and `having ($value not in column)`
URL: https://github.com/apache/doris/issues/19374
--
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