# # BUG#29480: Under sql_mode=STRICT_TRANS_TABLES the second # INSERT/INSERT ... SELECT stmt hangs on the implicit assignment # to a field without a default value. # SET @tmp=@@sql_mode; SET sql_mode='STRICT_TRANS_TABLES'; CREATE TABLE t1 (c1 INT, c2 INT NOT NULL); INSERT INTO t1 (c1, c2) VALUES (1, 2); --error 1364 INSERT INTO t1 (c1) VALUES (3); SHOW WARNINGS; --error 1364 INSERT INTO t1 (c1) SELECT 4; SHOW WARNINGS; SET sql_mode=@tmp; DROP TABLE t1;