You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Jorge Leitão (Jira)" <ji...@apache.org> on 2020/12/27 11:05:00 UTC

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

     [ https://issues.apache.org/jira/browse/ARROW-9911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jorge Leitão reassigned ARROW-9911:
-----------------------------------

    Assignee: Ruihang Xia

> [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: Improvement
>          Components: Rust, Rust - DataFusion
>            Reporter: Andrew Lamb
>            Assignee: Ruihang Xia
>            Priority: Minor
>              Labels: beginner, pull-request-available
>             Fix For: 3.0.0
>
>          Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> 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)