XiaozongCui created SPARK-45806:
-----------------------------------
Summary: GROUP BY ALL don't work in ansi mode
Key: SPARK-45806
URL: https://issues.apache.org/jira/browse/SPARK-45806
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.5.0, 3.4.0
Reporter: XiaozongCui
I noticed that we treat 'ALL' in 'GROUP BY ALL' as an Identifier in parsing,
and this will cause problem when I turn on ansi keyword behavior
*set spark.sql.ansi.enabled=true;*
*set spark.sql.ansi.enforceReservedKeywords=true;*
spark-sql (default)> select a,b,c, count(*) from values(1,2,3)t(a,b,c) group by
all;
[PARSE_SYNTAX_ERROR] Syntax error at or near 'all'.(line 1, pos 59)
== SQL ==
select a,b,c, count(*) from values(1,2,3)t(a,b,c) group by all
-----------------------------------------------------------^^^
can we allow this reserved keyword in ansi mode ?
--
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
