title: CF10 , MYSQL SQL_SELECT_LIMIT=DEFAULT
body: <p>I just set up CF10, win2008, IIS 7.5 with mysql 5.6. But we are getting this error:</p>
  
  <pre><code>Error Executing Database Query.
  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT
  </code></pre>
  
  <p>This error is removed when I explicitly set "LIMIT" to the queries.</p>
  
  <p><strong>(Update from comments)</strong></p>
  
  <p>Here is an example: </p>
  
  <pre><code>&lt;cfquery name="dds" datasource ="#Request.Datasource#"&gt; 
      SELECT * 
      FROM   tblaccounts 
      LIMIT 100 
  &lt;/cfquery&gt; 
  </code></pre>
  
  <p>As far as my research shows, it's an incompatibility with the new version of mysql 5.6.</p>