[jira] [Created] (CALCITE-5123) Calcite errors on columns starting with a digit

["Laurens Versluis (Jira)" <ji...@apache.org>]

Laurens Versluis created CALCITE-5123:
-----------------------------------------

             Summary: Calcite errors on columns starting with a digit
                 Key: CALCITE-5123
                 URL: https://issues.apache.org/jira/browse/CALCITE-5123
             Project: Calcite
          Issue Type: Bug
         Environment: Calcite 1.30.0 on Java 11. Ran the example PySpark using Python 3.9 with Spark 3.1.2
            Reporter: Laurens Versluis
         Attachments: image-2022-04-28-09-41-03-535.png

Not sure if this is related solely to Spark:

 

Parsing the following query errors in Calcite:
{code:java}
public static void main(String[] args) throws SqlParseException {
    String sqlQuery = "SELECT a AS 1a FROM FakeTable";
    SqlParser.create(sqlQuery, SparkSqlDialect.DEFAULT.configureParser(SqlParser.config())).parseQuery();
} {code}
{noformat}
Exception in thread "main" org.apache.calcite.sql.parser.SqlParseException: Encountered "1" at line 1, column 13.
{noformat}
However, Spark does accept such queries:

!image-2022-04-28-09-41-03-535.png!



--
This message was sent by Atlassian Jira
(v8.20.7#820007)