Test showing how MySQL sql_mode STRICT_TRANS_TABLE fails

strict_trans_table_test.sql

CREATE SCHEMA IF NOT EXISTS test;
USE test;
DROP TABLE IF EXISTS strict_test;
CREATE TABLE strict_test(
    i1 INT UNSIGNED NOT NULL AUTO_INCREMENT, 
    c1 VARCHAR(10) NOT NULL, 
    i2 TINYINT NOT NULL DEFAULT '1', 
    PRIMARY KEY (i1)
) ENGINE=InnoDB;
SET GLOBAL sql_mode='NO_ENGINE_SUBSTITUTION';
\r
SELECT @@sql_mode;
INSERT INTO strict_test(i2) VALUES(2);
SHOW WARNINGS;
SELECT * FROM strict_test;

SET GLOBAL sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
\r
SELECT @@sql_mode;
INSERT INTO strict_test(i2) VALUES(3);
SELECT * FROM strict_test;