[GitHub] [arrow-datafusion] alamb commented on issue #2978: SELECT on column with uppercase column name fails with FieldNotFound error

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

alamb commented on issue #2978:
URL: https://github.com/apache/arrow-datafusion/issues/2978#issuecomment-1241162837

   >  Is there a plan to support backtick (`) for "Quoted identifier"?
   
   I don't know of any plans @ray-andrew  -- I think the backtick is a mysql syntax  where the postgres dialect, that DataFusion follows,  uses `"`
   
   Here is mysql:
   
   ```sql
   mysql> select * from bar;
   +------+
   | x    |
   +------+
   |    1 |
   | NULL |
   +------+
   2 rows in set (0.01 sec)
   
   mysql> select `x` from bar;
   +------+
   | x    |
   +------+
   |    1 |
   | NULL |
   +------+
   2 rows in set (0.00 sec)
   
   mysql> select "x" from bar;
   +---+
   | x |
   +---+
   | x |
   | x |
   +---+
   2 rows in set (0.00 sec)
   ```


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