alamb commented on issue #1082:
URL:
https://github.com/apache/arrow-datafusion/issues/1082#issuecomment-942288321
I am not sure `is distinct from` is needed
Trying it out with postgres:
```sql
alamb=# select * from foo;
x
---
1
2
(3 rows)
alamb=# select * from bar;
x
---
2
(2 rows)
alamb=# select * from foo intersect select * from bar;
x
---
2
(2 rows)
```
And if `bar` does not have any nulls:
```sql
alamb=# select * from foo;
x
---
1
2
(3 rows)
alamb=# select * from bar;
x
---
2
(1 row)
alamb=# select * from foo intersect select * from bar;
x
---
2
(1 row)
```
Which I believe is the same semantics as semi-join using an equality
predicate (though now that I type this, perhaps since `NULL = NULL` is not
true, then semi join with equality isn't correct. 🤔
--
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]
