Index hint syntax not recognized

[ibennetch]

See https://dev.mysql.com/doc/refman/8.0/en/index-hints.html and phpmyadmin/phpmyadmin#14482

Syntactical valid statements include FORCE INDEX, USE INDEX, and IGNORE INDEX, and FORCE KEY, USE KEY, and IGNORE KEY.

./vendor/bin/highlight-query --query "SELECT * FROM address FORCE INDEX(idx_fk_city_id) WHERE city_id<0"

SELECT
    *
FROM
    address FORCE INDEX(idx_fk_city_id)
WHERE
    city_id < 0

./vendor/bin/lint-query --query "SELECT * FROM address FORCE INDEX(idx_fk_city_id) WHERE city_id<0"

#1: Unrecognized keyword. (near "FORCE" at position 22)
#2: Unrecognized keyword. (near "INDEX" at position 28)
#3: Unexpected token. (near "(" at position 33)
#4: Unexpected token. (near "idx_fk_city_id" at position 34)
#5: Unexpected token. (near ")" at position 48)

[ibennetch]

This seems to be valid MySQL at least as far back as version 5.5 and is part of MariaDB as well: https://mariadb.com/kb/en/library/index-hints-how-to-force-query-plans/