1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/main/strict_autoinc_3heap.result b/mysql-test/main/strict_autoinc_3heap.result
new file mode 100644
index 00000000000..21eea537af5
--- /dev/null
+++ b/mysql-test/main/strict_autoinc_3heap.result
@@ -0,0 +1,26 @@
+drop table if exists t1;
+set @org_mode=@@sql_mode;
+create table t1
+(
+`a` tinyint(4) NOT NULL auto_increment,
+primary key (`a`)
+) engine = 'MEMORY'  ;
+set @@sql_mode='strict_all_tables';
+insert into t1 values(1000);
+ERROR 22003: Out of range value for column 'a' at row 1
+select count(*) from t1;
+count(*)
+0
+set auto_increment_increment=1000;
+set auto_increment_offset=700;
+insert into t1 values(null);
+ERROR 22003: Out of range value for column 'a' at row 1
+select count(*) from t1;
+count(*)
+0
+set @@sql_mode=@org_mode;
+insert into t1 values(null);
+ERROR 22003: Out of range value for column 'a' at row 1
+select * from t1;
+a
+drop table t1;