[jira] [Created] (SPARK-45806) GROUP BY ALL don't work in ansi mode

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

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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org