[GitHub] [arrow-datafusion] dbr commented on issue #2374: Arrow2: Identifiers are made lower-case in SQL query

[GitBox <gi...@apache.org>]

dbr commented on issue #2374:
URL: https://github.com/apache/arrow-datafusion/issues/2374#issuecomment-1113118289

   Oh this is acting same in latest `master` branch! 7a9b86526e2bd12deccb9ff30cead2ba6323409a
   
   ```sh
   $ git rev-parse HEAD
   7a9b86526e2bd12deccb9ff30cead2ba6323409a
   $ git diff
   diff --git a/datafusion-examples/examples/memtable.rs b/datafusion-examples/examples/memtable.rs
   index 11793a83..80cb65fc 100644
   --- a/datafusion-examples/examples/memtable.rs
   +++ b/datafusion-examples/examples/memtable.rs
   @@ -36,7 +36,7 @@ async fn main() -> Result<()> {
        // Register the in-memory table containing the data
        ctx.register_table("users", Arc::new(mem_table))?;
    
   -    let dataframe = ctx.sql("SELECT * FROM users;").await?;
   +    let dataframe = ctx.sql("SELECT Bank_Account FROM users;").await?;
    
        timeout(Duration::from_secs(10), async move {
            let result = dataframe.collect().await.unwrap();
   @@ -71,6 +71,6 @@ fn create_record_batch() -> Result<RecordBatch> {
    fn get_schema() -> SchemaRef {
        SchemaRef::new(Schema::new(vec![
            Field::new("id", DataType::UInt8, false),
   -        Field::new("bank_account", DataType::UInt64, true),
   +        Field::new("Bank_Account", DataType::UInt64, true),
        ]))
    }
   $ cargo run --example memtable
       Finished dev [unoptimized + debuginfo] target(s) in 0.36s
        Running `./target/debug/examples/memtable`
   Error: Plan("Invalid identifier '#bank_account' for schema fields:[users.id, users.Bank_Account], metadata:{}")
   ```


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