[GitHub] [arrow-datafusion] liukun4515 edited a comment on issue #1432: Field names containing period such as `f.c1` cannot be named in SQL query

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

liukun4515 edited a comment on issue #1432:
URL: https://github.com/apache/arrow-datafusion/issues/1432#issuecomment-991051157


   In my opinion, this `f1.c1` style is illegal for SQL syntax.
   For example in Mysql and PG
   ```
   mysql>  create table t5("f.c1" int);
   ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"f.c1" int)' at line 1
   
   
   postgres=# create table t5("f.c1" int);
   CREATE TABLE
   ```
   In the SparkSQL 
   ```
   spark-sql> create table t5("f.c1" int);
   Error in query:
   no viable alternative at input '("f.c1"'(line 1, pos 16)
   
   == SQL ==
   create table t5("f.c1" int)
   ```


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