Mysql 5.5 to Mysql 5.6 upgrade Insert query is breaking
in 5.6.12:  (Well, not really an answer, but more info.)

mysql&gt; insert into se108833 (product_id,product_id_nn) values ('','');
Query OK, 1 row affected, 2 warnings (0.00 sec)

mysql&gt; show warnings;
+---------+------+-----------------------------------------------------------------+
| Level   | Code | Message                                                         |
+---------+------+-----------------------------------------------------------------+
| Warning | 1366 | Incorrect integer value: '' for column 'product_id' at row 1    |
| Warning | 1366 | Incorrect integer value: '' for column 'product_id_nn' at row 1 |
+---------+------+-----------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql&gt; select * from se108833;
+------------+---------------+
| product_id | product_id_nn |
+------------+---------------+
|          0 |             0 |
+------------+---------------+
1 row in set (0.00 sec)

mysql&gt; show variables like 'sql_mode';
+---------------+------------------------+
| Variable_name | Value                  |
+---------------+------------------------+
| sql_mode      | NO_ENGINE_SUBSTITUTION |  -- not "strict" mode
+---------------+------------------------+
1 row in set (0.00 sec)

mysql&gt; set session sql_mode = 'strict_all_tables';
Query OK, 0 rows affected (0.00 sec)

mysql&gt; insert into se108833 (product_id,product_id_nn) values ('','');
ERROR 1366 (HY000): Incorrect integer value: '' for column 'product_id' at row 1