title: MySQL showing SQL Error: 1048 as a warning instead of error
body: <p>When updating a not null column to a null value locally it will throw an error, but when running against an AWS RDS instance it will be ok and report a warning.</p>
  
  <p>eg. Against AWS RDS:</p>
  
  <pre><code>2018-05-31 15:41:23,066 [][][localhost]  WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper:232 - SQL Warning Code: 1048, SQLState: null
  2018-05-31 15:41:23,068 [][][localhost]  WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper:233 - Column 'xxxxx' cannot be null
  </code></pre>
  
  <p>And against my local:</p>
  
  <pre><code>2018-05-31 15:02:07,023 [][][localhost]  WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper:144 - SQL Error: 1048, SQLState: 23000
  2018-05-31 15:02:07,024 [][][localhost] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper:146 - Column 'xxxxx' cannot be null
  2018-05-31 15:02:07,029 [][][localhost]  INFO org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl:208 - HHH000010: On release of batch it still contained JDBC statements
  2018-05-31 15:02:07,035 [][][localhost]  WARN net.sourceforge.stripes.exception.DefaultExceptionHandler:90 - Unhandled exception caught by the Stripes default exception handler.
  org.hibernate.exception.ConstraintViolationException: could not execute statement
  </code></pre>
  
  <p>From my reading the sql_mode property handles this but changing the value has no effect. Setting my local to the same values as remote does not reproduce the behavior:</p>
  
  <pre><code>show variables where Variable_name like '%sql_mode%';
  'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'
  </code></pre>
  
  <p><strong>What is the setting that allows my AWS RDS instance to show a warning when locally it is an error?</strong></p>
  
  <p>Additional information:</p>
  
  <ul>
  <li>Column definition: <code>xxxxx</code> int(11) unsigned NOT NULL</li>
  <li>Storage engine: InnoDB</li>
  <li>Local Version: 5.6.33-log and 5.6.27 (observed the issue in two different areas)</li>
  <li>Remote Version: 5.6.39-log</li>
  </ul>