You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "AdamGS (via GitHub)" <gi...@apache.org> on 2026/04/01 23:24:23 UTC
[I] Mark joins don't support null mark columns [datafusion]
AdamGS opened a new issue, #21309:
URL: https://github.com/apache/datafusion/issues/21309
From the [Story of Joins](https://www.cs.cmu.edu/~15721-f24/papers/Story_of_Joins.pdf) paper, for queries like:
```sql
select Title, ECTS = any (select ECTS from Courses c2
where Lecturer = 123) someE‘ual
from Courses c1
```
> The result column someEqual can have the values TRUE, FALSE, and NULL (i.e.,
unknown). Accordingly, some care is needed to implement the mark join correctly, as we
will discuss in Section 5. But the great benefit is that we now translate arbitrary exists/not
exists/unique/quantified-comparison queries into a join construct and eventually, after
further optimizations, obtain an efficient evaluation strategy.
This seems like desirable behavior, and consistent with the general direction of subquery de-correlation.
--
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: github-unsubscribe@datafusion.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Mark joins don't support null mark columns [datafusion]
Posted by "AdamGS (via GitHub)" <gi...@apache.org>.
AdamGS commented on issue #21309:
URL: https://github.com/apache/datafusion/issues/21309#issuecomment-4721747711
I've started splitting up my PR because its too big IMO and its a pain to handle, first part is #22981 which is mostly the SLT tests I had, documenting some of the current behavior.
--
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: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Mark joins don't support null mark columns [datafusion]
Posted by "AdamGS (via GitHub)" <gi...@apache.org>.
AdamGS commented on issue #21309:
URL: https://github.com/apache/datafusion/issues/21309#issuecomment-4173542210
take
--
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: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Mark joins don't support null mark columns [datafusion]
Posted by "AdamGS (via GitHub)" <gi...@apache.org>.
AdamGS commented on issue #21309:
URL: https://github.com/apache/datafusion/issues/21309#issuecomment-4189729585
I have a branch locally that somewhat works, it needs some more work and thinking
--
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: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Mark joins don't support null mark columns [datafusion]
Posted by "neilconway (via GitHub)" <gi...@apache.org>.
neilconway commented on issue #21309:
URL: https://github.com/apache/datafusion/issues/21309#issuecomment-4189719504
Cool! I'm also interested in this area.
--
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: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Mark joins don't support null mark columns [datafusion]
Posted by "AdamGS (via GitHub)" <gi...@apache.org>.
AdamGS closed issue #21309: Mark joins don't support null mark columns
URL: https://github.com/apache/datafusion/issues/21309
--
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: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org