Repository navigation
Parser failing on nested case statements #1306
Description
SELECT CASE
WHEN 'USD' = 'USD'
THEN 0
ELSE CASE
WHEN 'USD' = 'EURO'
THEN ( CASE
WHEN 'A' = 'B'
THEN 0
ELSE 1
END * 100 )
ELSE 2
END
END AS "column1"
FROM test_schema.table_name
However it works correctly when I put brackets around inner case statement.
The query given above is a valid query.
Activity
manticore-projects commentedon Aug 18, 2021
Greetings,
thank you for reporting. I will look at it.
Fixes JSQLParser#1306
Fixes #1306 (#1311)
Fix Gradle PMD and Checkstyle (#1318)
Update sets (JSQLParser#1317)