title: Mariadb - Getting "Field 'xxx' doesn't have a default value" error even though there is no null values for the Field
body: <p>When I run replace query then I get &quot;Field 'xxx' doesn't have a default value&quot;
  The replace query has select query. so I ran the select query to find which row has the null value.. but all rows in result have proper Int values.</p>
  <p>I can't change the column default value to null because that column is the primary key.</p>
  <p>I have no idea from where should I start to find.. any ideas?</p>
  <p>(I can't write the query here because of security issue.. sorry)</p>