Formatting changes as of 2017.3.1
Looks like the 2017.3.1 update might have broken/modified the newline logic in SQL styles, Its not identifying the need for newlines for each AND within the query anymore. This was functioning properly as of 2017.3.0.
Example query:
SELECT A.COL1, A.COL2, A.COL3
FROM A
INNER JOIN B ON A.COL1 = B.COL1 AND A.COL2 =B.COL2 AND A.COL3 = C.COL3
WHERE B.COL4 = 1 AND B.COL5 = 2
Expected formatting:
SELECT
A.COL1
, A.COL2
, A.COL3
FROM A
INNER JOIN B
ON A.COL1 = B.COL1
AND A.COL2 = B.COL2
AND A.COL3 = C.COL3
WHERE
B.COL4 = 1
AND B.COL5 = 2
Formatted output:
SELECT
A.COL1
, B.COL2
, C.COL3
FROM A
INNER JOIN B
ON A.COL1 = B.COL1 AND A.COL2 = B.COL2 AND A.COL3 = C.COL3
WHERE
B.COL4 = 1 AND B.COL5 = 2
Please sign in to leave a comment.