I installed the 4.2 early adopter version a couple of days ago, and as expected, one of the biggest differences (if not the biggest) I saw was related to the code formatter.
On 4.1, I have my formatter set so that this query:
SELECT * FROM emp WHERE deptno = 10 AND sal > 3000 ORDER BY sal;
gets formatted to:
SELECT *
FROM emp
WHERE deptno = 10
AND sal > 3000
ORDER BY sal;
I don't seem to be able to get the new formatter to produce the same results.
In 4.2 I can't get it to stop adding a line break after the SELECT keyword when I select * instead of individual columns, even though I have that option deselected in the formatter settings (see image below).
Also, for some reason, there is no option to break before boolean connectors, which is odd because "On comma" and "On concatenation" have options to break before, after or no-break, but for boolean connectors the only options are "after" and "no breaks".
Am I doing something wrong, or is there some workaround to get it to format SQL code like in my example above?
Thanks!
