[ASTERIXDB-2356] Syntax error when parsing CASE expression

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Component/s: SQL - Translator SQL++
• Assignee: Dmitry Lychagin
• Reporter: Dmitry Lychagin
• Created: 05/Apr/18 22:37
• Updated: 20/Apr/18 04:28
• Resolved: 20/Apr/18 04:28

Description

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 ...