You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "2010YOUY01 (via GitHub)" <gi...@apache.org> on 2025/09/03 12:54:41 UTC

[I] Schema error in a query with `RIGHT ANTI JOIN` (SQLancer) [datafusion]

2010YOUY01 opened a new issue, #17390:
URL: https://github.com/apache/datafusion/issues/17390

   ### Describe the bug
   
   datafusion-cli is compiled from the latest main commit https://github.com/apache/datafusion/commit/d19bf524e384bc24e509c70f1806b6f330829529
   
   ```sql
   -- Setup
   
   -- Tables
   CREATE TABLE t0 (id INT, flag BOOLEAN);
   CREATE TABLE t1 (id INT);
   CREATE TABLE t2 (id INT);
   
   -- Tiny data (values don’t matter for planning/binding)
   INSERT INTO t0 VALUES (1, TRUE);
   INSERT INTO t1 VALUES (10);
   INSERT INTO t2 VALUES (100);
   ```
   
   ```sh
   DataFusion CLI v49.0.2
   
   > SELECT *
   FROM t0
   RIGHT ANTI JOIN t1 ON TRUE
   RIGHT ANTI JOIN t2 ON t0.flag;
   
   Schema error: No field named t0.flag. Valid fields are t1.id, t2.id.
   ```
   
   ### To Reproduce
   
   _No response_
   
   ### Expected behavior
   
   This query seems valid to me, it should be runnable
   
   ### Additional context
   
   Found by SQLancer https://github.com/apache/datafusion/issues/11030


-- 
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] Schema error in a query with `RIGHT ANTI JOIN` (SQLancer) [datafusion]

Posted by "2010YOUY01 (via GitHub)" <gi...@apache.org>.
2010YOUY01 closed issue #17390: Schema error in a query with `RIGHT ANTI JOIN` (SQLancer)
URL: https://github.com/apache/datafusion/issues/17390


-- 
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] Schema error in a query with `RIGHT ANTI JOIN` (SQLancer) [datafusion]

Posted by "kumarUjjawal (via GitHub)" <gi...@apache.org>.
kumarUjjawal commented on issue #17390:
URL: https://github.com/apache/datafusion/issues/17390#issuecomment-3257605678

   @2010YOUY01 isn't logical schema for `Right AntI` intentionally “right-only”. So any references to the left-side table (t0) are out of scope once you’ve applied a `RightAntI join`.


-- 
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] Schema error in a query with `RIGHT ANTI JOIN` (SQLancer) [datafusion]

Posted by "2010YOUY01 (via GitHub)" <gi...@apache.org>.
2010YOUY01 commented on issue #17390:
URL: https://github.com/apache/datafusion/issues/17390#issuecomment-3257704065

   > [@2010YOUY01](https://github.com/2010YOUY01) isn't logical schema for `Right AntI` intentionally “right-only”. So any references to the left-side table (t0) are out of scope once you’ve applied a `RightAntI join`.
   
   Thanks for the triage, you're absolutely right.


-- 
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] Schema error in a query with `RIGHT ANTI JOIN` (SQLancer) [datafusion]

Posted by "kumarUjjawal (via GitHub)" <gi...@apache.org>.
kumarUjjawal commented on issue #17390:
URL: https://github.com/apache/datafusion/issues/17390#issuecomment-3257064838

   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