sql-formatter icon indicating copy to clipboard operation
sql-formatter copied to clipboard

Wrong indentation for more conditions in JOIN

Open nothrem opened this issue 9 years ago • 0 comments

When JOIN uses more conditions, it gets formatted as:

FROM 
    data as d
    JOIN more as m ON d.id = m.id
    AND d.name = m.name

Better would be (more compressed)

FROM 
    data as d
    JOIN more as m ON d.id = m.id AND d.name = m.name

or (less compressed)

FROM 
    data as d
    JOIN more as m 
        ON d.id = m.id 
        AND d.name = m.name

nothrem avatar Jun 10 '16 08:06 nothrem