diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-11-07 08:17:47 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-11-07 08:17:47 +0200 |
| commit | 89f948c766721a26e110bc9da0ca5ebc20f65112 (patch) | |
| tree | 14acae07e4a4790b6af1c97c321a8012f1d0d00b /mysql-test/t/auto_increment_ranges_innodb.test | |
| parent | 04789ec801b6d0955c70b0387973f017424062b4 (diff) | |
| parent | 59c82dde09984d10f16417c9c82cd759f81d770c (diff) | |
| download | mariadb-git-89f948c766721a26e110bc9da0ca5ebc20f65112.tar.gz | |
Merge 10.1 into 10.2
Diffstat (limited to 'mysql-test/t/auto_increment_ranges_innodb.test')
| -rw-r--r-- | mysql-test/t/auto_increment_ranges_innodb.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/auto_increment_ranges_innodb.test b/mysql-test/t/auto_increment_ranges_innodb.test index c2afee7ac66..016ca16bd91 100644 --- a/mysql-test/t/auto_increment_ranges_innodb.test +++ b/mysql-test/t/auto_increment_ranges_innodb.test @@ -5,3 +5,16 @@ --source include/have_innodb.inc set default_storage_engine=innodb; --source auto_increment_ranges.inc + +# +# MDEV-17377 invalid gap in auto-increment values after LOAD DATA +# +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; +drop table t1; +--let $datadir=`select @@datadir` +--remove_file $datadir/test/load.data |