[jira] [Created] (ARROW-9911) [Rust][DataFusion] SELECT with no FROM clause should produce a single row of output

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

Andrew Lamb created ARROW-9911:
----------------------------------

             Summary: [Rust][DataFusion] SELECT <expression> with no FROM clause should produce a single row of output
                 Key: ARROW-9911
                 URL: https://issues.apache.org/jira/browse/ARROW-9911
             Project: Apache Arrow
          Issue Type: Bug
            Reporter: Andrew Lamb


This is somewhat of a special case, but it is useful for demonstration / testing expressions. 

A select expression with no where clause, such as "select 1" should produce a single row. Today datafusion accepts the query but produces no rows.

Actual output:
{code}
arrow/rust$ cargo run --release  --bin datafusion-cli 
    Finished release [optimized] target(s) in 0.25s
     Running `target/release/datafusion-cli`
> select 1 ;
0 rows in set. Query took 0 seconds.
{code}

Expected output is a single row, with the value 1. Here is an example using SQLLite :

{code}
$ sqlite3 
SQLite version 3.28.0 2019-04-15 14:49:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> select 1;
1
sqlite> 
{code}



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