Trivadis/plsql-formatter-settings

Line breaks in values_clause of insert statement lost

PhilippSalvisberg opened this issue · 0 comments

This input (and expected output)

create or replace trigger dept_br_u
before update of department_id,department_name
on departments for each row
begin
   insert into departments_log (
      department_id
     ,department_name
     ,modification_date)
   values (:old.department_id
     ,:old.department_name
     ,sysdate);
end;
/

produces this formatter result:

create or replace trigger dept_br_u
before update of department_id,department_name
on departments for each row
begin
   insert into departments_log (
      department_id
     ,department_name
     ,modification_date)
   values (:old.department_id,:old.department_name,sysdate);
end;
/

This different behavior was introduced in sqldev-22.2.0. Worked as expected in sqldev-21.4.3

Default settings, changed the following:

  • Line Breaks On Comma: Before
  • White Space After Comma: unchecked