Another Small Sql Formatter Issue (with "between")

[vygi]

Code:

SELECT * FROM table1 WHERE field1 BETWEEN 1 AND 2 AND field2 > 3

is being formatted as:

Code:

SELECT *
FROM table1
WHERE field1 BETWEEN 1
AND 2
AND field2 > 3

Should be:

Code:

SELECT *
FROM table1
WHERE field1 BETWEEN 1 AND 2
AND field2 > 3

(first AND after BETWEEN should remain in the same line)

[peterlaursen]

.. and it does not even help to add paranthesis's like

Code:

SELECT * FROM table1 WHERE (field1 BETWEEN 1 AND 2) AND (field2 > 3)

I am afraid this will be a tough one. The formatter does not know the meaning of SQL. It recognizes string patterns using regular expressions. But maybe some additional condition can be added to that reqex when keyword BETWEEN appears in the string (like first AND after BETWEEN has anohter meaning that what AND normally has).

[Author]

Posts