1 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/include/strict_autoinc.inc b/mysql-test/include/strict_autoinc.inc
new file mode 100644
index 00000000..3298008b
--- /dev/null
+++ b/mysql-test/include/strict_autoinc.inc
@@ -0,0 +1,33 @@
+#
+# Test for strict-mode autoincrement
+#
+
+--disable_warnings
+drop table if exists t1;
+--enable_warnings
+
+set @org_mode=@@sql_mode;
+eval create table t1
+(
+  `a` tinyint(4) NOT NULL auto_increment,
+  primary key (`a`)
+) engine = $type ;
+set @@sql_mode='strict_all_tables';
+--error ER_WARN_DATA_OUT_OF_RANGE
+insert into t1 values(1000);
+select count(*) from t1;
+
+set auto_increment_increment=1000;
+set auto_increment_offset=700;
+--error 167
+insert into t1 values(null);
+select count(*) from t1;
+
+set @@sql_mode=@org_mode;
+--error 167
+insert into t1 values(null);
+select * from t1;
+
+drop table t1;
+
+# End of test