[jira] [Created] (SPARK-19472) [SQL]SQLParser fails to resolve nested CASE WHEN statement with parentheses

[StanZhai (JIRA)]

StanZhai created SPARK-19472:
--------------------------------

             Summary: [SQL]SQLParser fails to resolve nested CASE WHEN 
statement with parentheses
                 Key: SPARK-19472
                 URL: https://issues.apache.org/jira/browse/SPARK-19472
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.1.0
            Reporter: StanZhai


SQLParser fails to resolve nested CASE WHEN statement like this:

select case when
  (1) +
  case when 1>0 then 1 else 0 end = 2
then 1 else 0 end
from tb

==================== Exception ====================
Exception in thread "main" org.apache.spark.sql.catalyst.parser.ParseException: 
mismatched input 'then' expecting {'.', '[', 'OR', 'AND', 'IN', NOT, 'BETWEEN', 
'LIKE', RLIKE, 'IS', 'WHEN', EQ, '<=>', '<>', '!=', '<', LTE, '>', GTE, '+', 
'-', '*', '/', '%', 'DIV', '&', '|', '^'}(line 5, pos 0)

== SQL ==

select case when
  (1) +
  case when 1>0 then 1 else 0 end = 2
then 1 else 0 end
^^^
from tb

But，remove parentheses will be fine：

select case when
  1 +
  case when 1>0 then 1 else 0 end = 2
then 1 else 0 end
from tb




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org