[FORMATTING] Parse error: Ambiguous grammar

[mashalzia]

BETWEEN operator with range, combined with another condition, without parenthesis is causing parse error. For example BETWEEN 25 AND 30 AND state_code = 'NY' doesn't work. BETWEEN (25 AND 30) AND state_code = 'NY' works.

Input data

SELECT * FROM users WHERE age BETWEEN 25 AND 35 AND state_code = 'NY'

Expected Output

SELECT
  *
FROM
  users
WHERE
  age BETWEEN 25 AND 35
  AND state_code  = 'NY'

Actual Output
Parse error: Ambiguous grammar

[nene]

Thanks for reporting.

This is duplicate of #534