Beautifier & CASE statement following an IF-THEN

[MikeM]

Version 7.0 and before gives this (misplaces the END IF):

DECLARE
    b BOOLEAN := TRUE;
    c VARCHAR2(1) := 'A';
BEGIN
    IF b THEN
        CASE c
            WHEN 'A' THEN
                NULL;
            WHEN 'B' THEN
                NULL;
        END CASE; END IF;
END;

when it should be this:

DECLARE
    b BOOLEAN := TRUE;
    c VARCHAR2(1) := 'A';
BEGIN
    IF b THEN
        CASE c
            WHEN 'A' THEN
                NULL;
            WHEN 'B' THEN
                NULL;
        END CASE;
    END IF;
END;

Thanks,
Mike

 

[Marco Kalter]

This is indeed a known issue. It will be fixed in an upcoming 7.0 patch (probably 7.0.1).

 

[DARRIB]

You can solve like this

DECLARE
  b BOOLEAN := TRUE;
  c VARCHAR2(1) := 'A';
BEGIN
  IF b THEN
    CASE c
      WHEN 'A' THEN
        NULL;
      WHEN 'B' THEN
        NULL;
    END CASE; /**/
  END IF;
END;