vtgate - possible query parsing regression using index hints

[guidoiaquinti]

Overview of the Issue

Possible regression in vtgate query parsing from Vitess 8 to 9 using index hints.

Reproduction Steps

Disclaimer: I didn't test the repro on vanilla Vitess but our internal version shouldn't differ a lot (at least in the query parsing)

• Vitess 8.0

  > SELECT id FROM blog_posts USE INDEX (PRIMARY) WHERE id = 10;
  +------+
  |   id |
  |------|
  |   10 |
  +------+
  1 row in set
  Time: 0.004s
  

• Vitess 9.0

  > SELECT id FROM blog_posts USE INDEX (PRIMARY) WHERE id = 10;
  (1105, "vtgate: http://vtgate:15000/: syntax error at position 67 near 'PRIMARY'")
  

Binary version

See above.

[guidoiaquinti]

Thank you! 🙇