Multi INDEX HINTS not supported.

[LPX-E5BD8]

multi INDEX HINTS will be parsed error.

tbl_name [[AS] alias] [index_hint_list]

index_hint_list:
    index_hint [index_hint] ...

index_hint:
    USE {INDEX|KEY}
      [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list])
  | IGNORE {INDEX|KEY}
      [FOR {JOIN|ORDER BY|GROUP BY}] (index_list)
  | FORCE {INDEX|KEY}
      [FOR {JOIN|ORDER BY|GROUP BY}] (index_list)

index_list:
    index_name [, index_name] ...

[LPX-E5BD8]

there is a same problem with create temporary table.

CREATE TEMPORARY TABLE t (c CHAR(20)

&vterrors.vtError{code:3, err:"syntax error at position 23 near 'table'"}

[sougou]

We can't currently support temp tables. See #3945.
Multi-index should be possible.

[tomkrouper]

👍 on needing this. In our testing, we have an ignore index in a query that is failing.

[christianlang]

+1 for adding this support. We have several queries with IGNORE INDEX FOR ORDER BY (PRIMARY) which currently result in a syntax error from Vitess.

[mattlord]

I wanted to note that you can use SQL comments to pass these hints down to MySQL: https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html

Is this sufficient, at least for the time being?

[christianlang]

We're still on MySQL 5.7 and the optimizer hints require 8.0.20 or newer, so we can't use this, unfortunately. Otherwise this would be a great work-around.

[glortho]

Great to see this land! Do you have a sense of when this might be released?