scsmithr opened a new issue, #6017: URL: https://github.com/apache/arrow-datafusion/issues/6017
### Describe the bug Using VALUES in a subquery results in an error. See below: ``` DataFusion CLI v22.0.0 ❯ create table t as (select 1 as a); 0 rows in set. Query took 0.015 seconds. ❯ select * from t where a = (select max(j) from (values (1)) as s1(j)); Error during planning: Unsupported operator in the subquery plan. ``` ### To Reproduce See above ### Expected behavior The query is able to execute. ### Additional context Fails with same error in 21.0.0 Works as expected in 20.0.0: ``` DataFusion CLI v20.0.0 ❯ create table t as (select 1 as a); 0 rows in set. Query took 0.007 seconds. ❯ select * from t where a = (select max(j) from (values (1)) as s1(j)); +---+ | a | +---+ | 1 | +---+ 1 row in set. Query took 0.010 seconds. ``` -- 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]
