comphead commented on issue #10100:
URL: https://github.com/apache/datafusion/issues/10100#issuecomment-2077561885
Full test to reproduce
```
#[tokio::test]
async fn test_() -> Result<()> {
let ctx: SessionContext = SessionContext::new();
let sql = "set datafusion.optimizer.prefer_hash_join = false;";
let _ = ctx.sql(sql).await?.collect().await?;
let sql = "
with
t1 as (select 1 a, 2 b)
select * from t1 where exists (select 1 from t1 t2 where t2.a =
t1.a and t2.b != t1.a);
";
let _ = ctx.sql(sql).await?.collect().await?;
Ok(())
}
```
--
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-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
