You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/04/29 16:37:29 UTC

[GitHub] [arrow-datafusion] andygrove opened a new issue, #2381: SQL parser does not support all forms of nested subquery

andygrove opened a new issue, #2381:
URL: https://github.com/apache/arrow-datafusion/issues/2381

   **Describe the bug**
   See unit test below.
   
   **To Reproduce**
   ``` rust
   #[tokio::test]
   async fn nested_subquery() -> Result<()> {
       let ctx = SessionContext::new();
       let schema = Schema::new(vec![
           Field::new("id", DataType::Int16, false),
           Field::new("a", DataType::Int16, false),
       ]);
       let empty_table = Arc::new(EmptyTable::new(Arc::new(schema)));
       ctx.register_table("t1", empty_table.clone())?;
       ctx.register_table("t2", empty_table)?;
       let sql = "SELECT COUNT(*) \
       FROM (\
           (SELECT id FROM t1) EXCEPT \
           (SELECT id FROM t2)\
           ) foo";
       let actual = execute_to_batches(&ctx, sql).await;
       // the purpose of this test is just to make sure the query produces a valid plan
       let expected = vec!["++", "++"];
       assert_batches_eq!(expected, &actual);
       Ok(())
   }
   ```
   
   Fails with:
   
   ```
   NotImplemented(\"Query (SELECT id FROM t1) not implemented yet\")
   ```
   
   **Expected behavior**
   Test should pass
   
   **Additional context**
   None
   


-- 
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] andygrove closed issue #2381: SQL parser does not support all forms of nested subquery

Posted by GitBox <gi...@apache.org>.
andygrove closed issue #2381: SQL parser does not support all forms of nested subquery
URL: https://github.com/apache/arrow-datafusion/issues/2381


-- 
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

[GitHub] [arrow-datafusion] comphead commented on issue #2381: SQL parser does not support all forms of nested subquery

Posted by GitBox <gi...@apache.org>.
comphead commented on issue #2381:
URL: https://github.com/apache/arrow-datafusion/issues/2381#issuecomment-1114644700

   @andygrove please check the PR above


-- 
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