Serge Rielau created SPARK-46068: ------------------------------------ Summary: Improve error message when using a string literal where only an identifier can go Key: SPARK-46068 URL: https://issues.apache.org/jira/browse/SPARK-46068 Project: Spark Issue Type: Improvement Components: Spark Core Affects Versions: 3.4.2 Reporter: Serge Rielau
The following: {noformat} *nospark-sql (default)> select * from "t"; [PARSE_SYNTAX_ERROR] Syntax error at or near '"t"'. SQLSTATE: 42601 (line 1, pos 14) == SQL == select * from "t" --------------^^^ {noformat} .. is confusing if one is used to double quotes for identifiers. Similarly, it is easy to mix up ' and `. So we would like to return an error that clearly states that a string was given where an identifier was expected. We can also propose using spark.sql.ansi.double_quoted_identifiers in that case. -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org