[jira] [Created] (ARROW-11323) [Rust][DataFusion] with queries with ORDER BY or GROUP BY that return no

["Andrew Lamb (Jira)" <ji...@apache.org>]

Andrew Lamb created ARROW-11323:
-----------------------------------

             Summary: [Rust][DataFusion]  with queries with ORDER BY or GROUP BY that return no 
                 Key: ARROW-11323
                 URL: https://issues.apache.org/jira/browse/ARROW-11323
             Project: Apache Arrow
          Issue Type: Bug
            Reporter: Andrew Lamb


If you run a SQL query in datafusion which has predicates that produces no rows that also includes a GROUP BY or ORDER BY clause, you get the following error:

Error of "ArrowError(ComputeError("concat requires input of at least one array"))"

Here are two test cases that show the problem: https://github.com/apache/arrow/blob/master/rust/datafusion/src/execution/context.rs#L889

{code}
    #[tokio::test]
    async fn sort_empty() -> Result<()> {
        // The predicate on this query purposely generates no results
        let results =
            execute("SELECT c1, c2 FROM test WHERE c1 > 100000 ORDER BY c1 DESC, c2 ASC", 4).await?;
        assert_eq!(results.len(), 0);
        Ok(())
    }


    #[tokio::test]
    async fn aggregate_empty() -> Result<()> {
        // The predicate on this query purposely generates no results
        let results = execute("SELECT SUM(c1), SUM(c2) FROM test where c1 > 100000", 4).await?;
        assert_eq!(results.len(), 0);
        Ok(())
    }

{code{



--
This message was sent by Atlassian Jira
(v8.3.4#803005)