8.0 Beautifier Regression

[jlcox]

This statement produces a beautifier parse error:

merge into table1 dest
  using (select field1, field2, field3
           from table(xform.etl_transform(cursor (select * from stg_table)))) src
  on (dest.field4 = src.field4)
  when matched then
    update
       set dest.field1 = src.field1,
           dest.field2 = src.field2,
           dest.field3 = src.field3
  when not matched then
    insert
      (field1, field2, field3, field4)
    values
      ( case etl.merge_counter(etl.c_inserting)
                 when 0 then
                          src.field1
              end,src.field2,
       src.field3,
       src.field4);

However, earlier beta versions of 8.0 beautified this properly

 

[Marco Kalter]

This seems to be cause by the case expression. We'll fix it.