I just stumbled across another problem with the formatter in the context of comments.
If you format the following statement:
select
t.dummy t_dummy,
m.dummy m_fummy
from
/*Comment*/
(
select
*
from
dual
) t,
/*Comment*/
(
select
*
from
dual
) m
where t.dummy = m.dummy
;
you get this:
SELECT t.dummy t_dummy, m.dummy m_fummy
FROM /*Comment*/
(SELECT * FROM DUAL) t, /*Comment*/
(SELECT * FROM DUAL) m
WHERE t.dummy = m.dummy;
This is not what I would expect, but the problem is that after reformatting, the result is not the same, but the following:
SELECT t.dummy t_dummy, m.dummy m_fummy
FROM /*Comment*/ (SELECT * FROM DUAL) t, /*Comment*/ (SELECT * FROM DUAL) m
WHERE t.dummy = m.dummy;
These are my formatter settings for comments:
