Beautifier error on nested case statements

[MSA]

Beautifier fails with internal error on nested case statements see example.
Example:
SELECT CASE
WHEN 1 = 4 THEN
CASE
WHEN 2 IS NOT NULL THEN 1 ELSE 0
END
WHEN 1 = 3 THEN
CASE
WHEN 2 IS NOT NULL THEN 1 ELSE 0
END
ELSE 1 END
FROM dual

 

[Bo Pedersen]

If you add parenthesis around the inner case expressions then the beautifier will not give an internal error. But it still looks horrible.

If the case expression is used in PL/SQL then the parenthesis are not needed. It just looks horrible in another way:

declare
  x pls_integer;
begin
  x := CASE WHEN :p1 = 4 THEN CASE WHEN :p2 IS NOT NULL THEN 1 ELSE 0 END WHEN :p1 = 3 THEN CASE WHEN :p2 IS NOT NULL THEN 1 ELSE 0 END ELSE 1 END;
end;

Enhancement request: beautifier shall handle nested case expresssion both in SQL and PL/SQL.

Note that nested case statements seems to be handled fine.

 

[Marco Kalter]

This is indeed a known problem. It will be fixed.

 

[MSA]

Is this problem fixed in new 7.0.3 ?

 

[Marco Kalter]

No, this is planned for 7.1.