Trivadis/plsql-formatter-settings

Concatenation Bars being split apart invalidating strings

Samccull-Bunnings opened this issue · 2 comments

Samccull-Bunnings commented

Based on the character count in a line the Abs bars can be split into separate lines which makes the code invalid
E.G.
image
becomes
image

(attached a text file copy for reference)
file.txt

PhilippSalvisberg commented

I used the SQL Developer 23.1 and the following formatter settings

image

to format your provided file (you know you can embedd it in Markdown):

begin
   DBMS_OUTPUT.put_line('wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww' || 'wwwwww');
end;

and the formatter result is

begin
   DBMS_OUTPUT.put_line('wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww' ||
   'wwwwww');
end;

Which looks good.

Could you please let me know the following things to make the issue reproducible:

  • SQL Developer version
  • OS and version
  • Advanced Format Settings in SQL Developer

Thank you.

PhilippSalvisberg commented

I can reproduce the issue when using the trivadis_advanced_format.xml and by using the default Arbori program provided by the SQL Developer team.

image

I cannot reproduce it with the Arbori program provided in this repository (trivadis_custom_format.arbori.

I kindly ask you to seek help in the SQL Developer forum regarding issues with the default Arbori program. Thank you.

  • 👍1