title: SQL_CALC_FOUND_ROWS gives syntax error for H2 db
body: <p>I am using H2 for JUnit of my Spring Boot application.</p>
  
  <p>One of my DAO classes uses <code>SQL_CALC_FOUND_ROWS</code> in a query for pagination, which produces syntax error for H2 db while running the JUnit test. I am using MySQL for dev.</p>
  
  <p>My query looks like </p>
  
  <pre><code>SELECT SQL_CALC_FOUND_ROWS column1, column2 
  FROM table
  </code></pre>
  
  <p>and the error is</p>
  
  <blockquote>
    <p>org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT SQL_CALC_FOUND_ROWS column1, column2 from <code>table</code>;]; nested exception is org.h2.jdbc.JdbcSQLException: Column "SQL_CALC_FOUND_ROWS" not found; SQL statement:
    ELECT SQL_CALC_FOUND_ROWS column1, column2 from <code>table</code>; [42122-196]</p>
  </blockquote>
  
  <p>What could be work around to make it work for both?</p>
  
  <p>Note: It is more of a dev related question, putting it here incase any <code>DBA</code> can help.</p>