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
