Dmitry Lychagin created ASTERIXDB-2356:
------------------------------------------
Summary: Syntax error when parsing CASE expression
Key: ASTERIXDB-2356
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2356
Project: Apache AsterixDB
Issue Type: Bug
Components: SQL - Translator SQL++
Reporter: Dmitry Lychagin
Assignee: Dmitry Lychagin
The following query fails with syntax error
SELECT
CASE WHEN get_year(current_date()) > 0 THEN "abc" ELSE "def" END LIKE "a%" as
v1
The workaround is to put parentheses around CASE expression: (CASE ...) LIKE ...
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)