Line breaks in values_clause of insert statement lost
PhilippSalvisberg opened this issue · 0 comments
PhilippSalvisberg commented
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