caseykneale commented on issue #7394:
URL:
https://github.com/apache/arrow-datafusion/issues/7394#issuecomment-1691990787
I have distilled the query down specifically to a `NOT EXIST` OR a `LEFT
JOIN` by creating in memory tables of the join queries. My segfaulting query
looks like this:
```SQL
SELECT
lhs.primary_key,
lhs.uuid,
lhs.thing,
lhs.other_thing,
lhs.other_other_thing
FROM lhs
WHERE NOT EXISTS (
SELECT * FROM rhs
WHERE lhs.uuid = rhs.uuid
AND lhs.thing = rhs.thing
AND lhs.other_thing = rhs.other_thing
AND lhs.other_other_thing = rhs.other_other_thing
)
```
where all types are nullable strings, or int64s.
At first I thought it had to do with nesting, now I am wondering if it has
to do with nullable comparisons inside of a not exist?
--
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]
