title: H2 delete query limit
body: <p>I'm trying to delete records from a h2 database (version 1.0.71) but I get a query syntax error. The query I perform is:</p>
  
  <pre><code>DELETE FROM TABLE_NAME WHERE QUERY_FIELD LIKE '%somevalue%' LIMIT 1000;
  </code></pre>
  
  <p>The error message I get is (and which isn't very helpful to me):</p>
  
  <pre><code>Syntax error in SQL statement DELETE FROM TABLE_NAME WHERE QUERY_FIELD LIKE '%somevalue%' LIMIT[*] 1000;
  </code></pre>
  
  <p>The <code>LIMIT</code> part seems to be the problem, isn't this supported in h2 1.0.71?</p>
  
  <p>When I perform the similar <code>SELECT</code> query:</p>
  
  <pre><code>SELECT * FROM TABLE_NAME WHERE QUERY_FIELD LIKE '%somevalue%' LIMIT 1000;
  </code></pre>
  
  <p>It gives me the expected results. Is the combination of <code>LIKE</code> and <code>LIMIT</code> perhaps problematic?</p>