buraksenn commented on issue #16134:
URL: https://github.com/apache/datafusion/issues/16134#issuecomment-4914825174
From what I can see this was fixed by #21240.
```
➜ datafusion git:(main) cargo run --bin datafusion-cli -p datafusion-cli
Finished [`dev` profile [unoptimized +
debuginfo]](https://doc.rust-lang.org/cargo/reference/profiles.html#default-profiles)
target(s) in 5.44s
Running `target/debug/datafusion-cli`
DataFusion CLI v54.0.0
> SELECT s.*, (SELECT * FROM (VALUES (1),(2)) t(x)) sub FROM (VALUES
('a'),('b')) s(a);
Execution error: Scalar subquery returned more than one row
> \?
```
If datafusion.optimizer.enable_physical_uncorrelated_scalar_subquery flag is
set to `false` but that is not recommended by the docs.
I think there are two actions:
- Close this issue
- Add a regression test for this exact query to subquery.slt, then close.
WDYT?
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
