Beautifier does not format merge/case Statements correct

[orca777]

Hello,
PLSDEV : 6.0.5.931

After a case expression in the update branch of a merge statement all following attributes are 'merged' into on line:

MERGE INTO Iimabilatb Iima
      USING Impmabilatb Impma
      ON (Iima.Kundenr = Impma.Kundenr AND Iima.Posnr = Impma.Posnr)
      WHEN MATCHED THEN
        UPDATE
           SET Iima.Prodtag  = Impma.Prodtag,
               Iima.Stichtag = Impma.Stichtag,
               Iima.Bilart   = Impma.Bilart,
               Iima.Bilkz    = Impma.Bilkz,
               Iima.Vonzeitr = Impma.Vonzeitr,
               Iima.Erfassa  = Impma.Erfassa,
               Iima.Rechtfs  = CASE
      WHEN(Nvl(Translate(Impma.Rechtfs, '0123456789', '__________'), '##') = '__') THEN To_Number(Rechtfs) ELSE - 1 END, Iima.Anzbesch = Impma.Anzbesch, Iima.Waehnum = Impma.Waehnum, Iima.Testat = Impma.Testat, Iima.Mabilajn = Impma.Mabilajn, Iima.Poswertc = Impma.Poswertc, Iima.Poswert = Impma.Poswert
      WHEN NOT MATCHED THEN
        INSERT
          (Iima.Kundenr,
           Iima.Posnr,
           Iima.Prodtag,
           Iima.Stichtag,
           Iima.Bilart,
           Iima.Bilkz,
           Iima.Vonzeitr,
           Iima.Erfassa,
           Iima.Rechtfs,
           Iima.Anzbesch,
           Iima.Waehnum,
           Iima.Testat,
           Iima.Mabilajn,
           Iima.Poswertc,
           Iima.Poswert)
        VALUES
          (Impma.Kundenr,
           Impma.Posnr,
           Impma.Prodtag,
           Impma.Stichtag,
           Impma.Bilart,
           Impma.Bilkz,
           Impma.Vonzeitr,
           Impma.Erfassa,
           Impma.Rechtfs,
           Impma.Anzbesch,
           Impma.Waehnum,
           Impma.Testat,
           Impma.Mabilajn,
           Impma.Poswertc,
           Impma.Poswert);

Regards
Carl

 

[Marco Kalter]

This is indeed a known problem that will be fixed in the next release.

 

[orca777]

Thx!

Carl