[GitHub] [arrow-datafusion] alamb commented on issue #108: [Datafusion] Datafusion queries involving a column name that begins with a number produces unexpected results

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

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


   Comment from Ben Sully(sd2k) @ 2020-11-08T11:46:18.008+0000:
   <pre>This behaviour seems consistent with Postgres at least:
   
   
   {{❯ psql}}
   {{psql (12.4)}}
   {{Type "help" for help.}}
   
   {{ben=# create table foo ("16_20mph" integer, "21_25mph" integer);}}
   {{CREATE TABLE}}
   {{ben=# insert into foo values (1, 2), (3, 4);}}
   {{INSERT 0 2}}
   {{ben=# SELECT 16_20mph, 21_25mph FROM foo;}}
   {{ _20mph | _25mph }}
   {{--------+--------}}
   {{ 16 | 21}}
   {{ 16 | 21}}
   {{(2 rows)}}
   
   {{ben=# SELECT "16_20mph", "21_25mph" FROM foo;}}
   {{ 16_20mph | 21_25mph }}
   {{----------+----------}}
   {{ 1 | 2}}
   {{ 3 | 4}}
   {{(2 rows)}}</pre>


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org