You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "scsmithr (via GitHub)" <gi...@apache.org> on 2023/04/15 00:03:53 UTC

[GitHub] [arrow-datafusion] scsmithr opened a new issue, #6017: Unsupported operator (VALUES) in subquery plan

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: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] waynexia closed issue #6017: Unsupported operator (VALUES) in subquery plan

Posted by "waynexia (via GitHub)" <gi...@apache.org>.
waynexia closed issue #6017: Unsupported operator (VALUES) in subquery plan
URL: https://github.com/apache/arrow-datafusion/issues/6017


-- 
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@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org