alamb commented on issue #1190:
URL:
https://github.com/apache/arrow-datafusion/issues/1190#issuecomment-953846176
Actually, I tried several variations and Inlist works well!
```shell
echo "1" > /tmp/foo.csv
cargo run -p datafusion-cli
```
```sql
CREATE EXTERNAL TABLE foo(x int)
STORED AS CSV
LOCATION '/tmp/foo.csv';
> SELECT NULL in (1, 2);
+---------------+
| Boolean(NULL) |
+---------------+
| |
+---------------+
1 row in set. Query took 0.002 seconds.
> SELECT NULL in (NULL, 2);
+---------------+
| Boolean(NULL) |
+---------------+
| |
+---------------+
1 row in set. Query took 0.002 seconds.
> SELECT 1 in (NULL, 2);
+---------------+
| Boolean(NULL) |
+---------------+
| |
+---------------+
1 row in set. Query took 0.002 seconds.
> SELECT x in (NULL, 2);
Plan("Invalid identifier '#x' for schema ")
> SELECT x in (NULL, 2) from foo;
+-------------------------------------------------------+
| foo.x IN (Map { iter: Iter([Utf8(NULL), Int64(2)]) }) |
+-------------------------------------------------------+
| |
+-------------------------------------------------------+
1 row in set. Query took 0.011 seconds.
```
--
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]
