Beautifier fails on MERGE with embeded CASE

[jschmied]

Hi!

If I try to format:

MERGE INTO kunde k
USING (SELECT DISTINCT kdnr, vb, gkz, kb FROM import_vb WHERE recnr BETWEEN v_dsnr_start AND v_dsnr_ende) i
ON (k.kdnr = i.kdnr)
WHEN MATCHED THEN
UPDATE SET k.gkz = i.gkz, k.kb = i.kb, k.vb = i.vb, k.dataset_fk = v_dataset, k.kunde_seit = CASE
WHEN(k.kunde_seit IS NULL) THEN v_date
WHEN(k.kunde_seit > v_date) THEN v_date ELSE k.kunde_seit END, k.vbkz_version = g_vbkz_version
WHEN NOT MATCHED THEN
INSERT
(k.kdnr, k.gkz, k.kb, k.vb, k.dataset_fk, k.kunde_seit, k.vb_version)
VALUES
(i.kdnr, i.gkz, i.kb, i.vb, v_dataset, v_date, g_vb_version);

the result its a bit ugly.

Thanks!

J

 

[Marco Kalter]

This is on the to-do list.