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

 

 

 

1

Please sign in to leave a comment.