diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-11-07 13:11:04 +0200 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-11-07 13:11:04 +0200 |
commit | 862af4d255cade35f9b1f65fd11dba30874fd8fc (patch) | |
tree | bf46bbba8b838db3e890e368c6839a07e2bd5c24 /mysql-test/main/auto_increment_ranges_innodb.result | |
parent | 54b2e1c1bea357ca37ce537e24c6c120a43f5958 (diff) | |
parent | e82ebb8f06674a22d959b91415c084ed34fe994d (diff) | |
download | mariadb-git-862af4d255cade35f9b1f65fd11dba30874fd8fc.tar.gz |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/auto_increment_ranges_innodb.result')
-rw-r--r-- | mysql-test/main/auto_increment_ranges_innodb.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/main/auto_increment_ranges_innodb.result b/mysql-test/main/auto_increment_ranges_innodb.result index 1d827a5a166..0471a5a33ba 100644 --- a/mysql-test/main/auto_increment_ranges_innodb.result +++ b/mysql-test/main/auto_increment_ranges_innodb.result @@ -264,3 +264,17 @@ delete from t1 where a=32767; insert into t1 values(NULL); ERROR 22003: Out of range value for column 'a' at row 1 drop table t1; +create table t1 (pk int auto_increment primary key, f varchar(20)); +insert t1 (f) values ('a'), ('b'), ('c'), ('d'); +select null, f into outfile 'load.data' from t1 limit 1; +load data infile 'load.data' into table t1; +insert t1 (f) values ('<==='); +select * from t1; +pk f +1 a +2 b +3 c +4 d +5 a +6 <=== +drop table t1; |