jiangzhx opened a new issue, #6279:
URL: https://github.com/apache/arrow-datafusion/issues/6279
### Describe the bug
- `select count(1) from t1 where (select t1.c1 from t1 where c2<0) IS NULL`
- `select count(1) from t1 where (select t1.c1 from t1 where c2>0) IS NULL`
response some result.
### To Reproduce
```
CREATE EXTERNAL TABLE t1 (
c1 VARCHAR NOT NULL,
c2 INT NOT NULL,
c3 SMALLINT NOT NULL,
c4 SMALLINT NOT NULL,
c5 INT NOT NULL,
c6 BIGINT NOT NULL,
c7 SMALLINT NOT NULL,
c8 INT NOT NULL,
c9 BIGINT NOT NULL,
c10 VARCHAR NOT NULL,
c11 FLOAT NOT NULL,
c12 DOUBLE NOT NULL,
c13 VARCHAR NOT NULL
)
STORED AS CSV
WITH HEADER ROW
LOCATION 'testing/data/csv/aggregate_test_100.csv';
```
- `select count(1) from t1 where (select t1.c1 from t1 where c2<0) IS NOT
NULL`
- `select count(1) from t1 where (select t1.c1 from t1 where c2>0) IS NOT
NULL`
response some result
### Expected behavior
_No response_
### Additional context
datafusion 23.0.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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
