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