-
Notifications
You must be signed in to change notification settings - Fork 796
Closed
Description
Describe the bug
I have a specific case where formatting the sql in a query window inserts an empty line inside a function between function arguments. The 2nd argument is also moved too much to the right.
I have never changed any formatting preferences, those are all default
To Reproduce
- Paste this sql:
SELECT W.OBJECTID,
G.SHAPE
FROM POINTS W
LEFT JOIN POLYGONS G ON ST_CONTAINS(G.SHAPE, W.SHAPE)
- Format the SQL (Ctrl+Shift+K)
- The result looks like this (scrolll to the right):
SELECT W.OBJECTID,
G.SHAPE
FROM POINTS W
LEFT JOIN POLYGONS G ON ST_CONTAINS(G.SHAPE,
W.SHAPE)
Expected behavior
Code should be formatted as:
SELECT W.OBJECTID,
G.SHAPE
FROM POINTS W
LEFT JOIN POLYGONS G ON ST_CONTAINS(G.SHAPE, W.SHAPE)
or maybe line up the arguments on separate lines:
SELECT W.OBJECTID,
G.SHAPE
FROM POINTS W
LEFT JOIN POLYGONS G ON ST_CONTAINS(G.SHAPE,
W.SHAPE)
Desktop (please complete the following information):
- OS: Windows 11
- Version: 7.6
- Mode: Desktop