how to mask out "USE INDEX" in MySQL query running on h2
<p>I am testing a MySQL query using local h2 for a java application. The problem is that h2 does not support "USE INDEX" (index hint) in the MySQL query. It reports "Syntax error in SQL statement". Is there a way to run this query with the USE INDEX masked out in h2?</p>

<p>I tried to use an alias to replace USE INDEX part with an empty string:</p>

<pre><code>CREATE ALIAS `USE INDEX` FOR "&lt;java-function-that-returns-empty-string&gt;"
</code></pre>

<p>but it did not work, i.e. still reports "Syntax error in SQL statement".  I suspect it's because 'USE INDEX' is two words, not supported by alias? but I am not sure. Any suggestions? Thanks.</p>