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

FORCE INDEX is not parsed correctly

Open BackEndTea opened this issue 2 years ago • 0 comments

This first query results in the following errors when linting, while the second one has no problems

#1: Unexpected token. (near "=" at position 58)
#2: Unexpected token. (near "uno" at position 60)
#3: Unexpected token. (near "." at position 63)
#4: Unexpected token. (near "id" at position 64)
SELECT *
FROM uno
JOIN dos FORCE INDEX (two_id) ON dos.id = uno.id
SELECT *
FROM uno
JOIN dos  ON dos.id = uno.id

BackEndTea avatar Aug 14 '23 08:08 BackEndTea