SQL Dev: Doubled blank lines before comments about plsql-formatter-settings HOT 7 CLOSED

Ok, thank you very much for your quick response. I can ask the SQL Developer Team if they can take a look at it.

from plsql-formatter-settings.

Thanks @markushohloch for reporting this issue. Could you please provide a little example? Thank you.

from plsql-formatter-settings.

Ok, I can reproduce it.

select * from dual;

-- test comment
select * from dual;

First format result under macOS. I can repeat formatting it. Result stays the same.

SELECT *
  FROM dual;

-- test comment
SELECT *
  FROM dual;

First format result under Windows:

SELECT *
  FROM dual;


-- test comment
SELECT *
  FROM dual;

Second format result under Windows:

SELECT *
  FROM dual;




-- test comment
SELECT *
  FROM dual;

I guess the problem is the preference Line breaks -> After statements -> Preserve original.

Obviously Preserve original does not work on any platform. I tried to change it to Single break. This seams to work.

However, the behavior is still strange. This time on macOS where the number of lines is reduced by every formatter call until it's just one empty line. I consider this a bug of the formatter Java class and not of the Arbori program. So we have to inform the SQL Developer team to fix that.

from plsql-formatter-settings.

I checked with default settings. For Line breaks -> After statements -> Double break. This works differently under Windows and macOS as well.

Adding "spaces" on empty lines changes the behavior as well. Really strange.

Using Single break or Double break seems to be the only feasible workaround for the time being.

from plsql-formatter-settings.

Yes, please. Could you also post the link here? Thanks a lot.

from plsql-formatter-settings.

You're welcome. https://twitter.com/MarkusHohloch/status/1250110284032806919

from plsql-formatter-settings.

https://community.oracle.com/message/15597056#15597056

from plsql-formatter-settings.