Open
Description
Formatter doesn't handle CASE expressions and CASE statements.
Related to #272.
Examples:
CASE expression:
-- original
SELECT CASE 1
WHEN 1 THEN
'one'
WHEN 2 THEN
'two'
ELSE
'more'
END;
-- formatted
SELECT CASE
1 WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'more'
END;
CASE statement:
-- original
CREATE PROCEDURE p()
BEGIN
DECLARE
v INT DEFAULT 1;
CASE v
WHEN 2 THEN
SELECT v;
WHEN 3 THEN
SELECT 0;
ELSE
BEGIN
END;
END CASE;
END;
-- formatted
CREATE PROCEDURE p()
BEGIN
DECLARE
v INT DEFAULT 1; CASE v WHEN 2 THEN
SELECT
v; WHEN 3 THEN
SELECT
0; ELSE
BEGIN
END
;
END CASE;
END;