Skip to content
This repository was archived by the owner on Aug 30, 2024. It is now read-only.
This repository was archived by the owner on Aug 30, 2024. It is now read-only.

Line breaks in values_clause of insert statement lost #214

@PhilippSalvisberg

Description

@PhilippSalvisberg

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

Metadata

Metadata

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions