From c32f7ed235f12d4e63f3145d09d5a57fb948d947 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Wed, 31 Oct 2018 18:18:48 +0100 Subject: MDEV-17377 invalid gap in auto-increment values after LOAD DATA reset lex->many_values for LOAD DATA, as it's used for auto-inc range size estimation. --- mysql-test/t/auto_increment_ranges_innodb.test | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'mysql-test/t/auto_increment_ranges_innodb.test') diff --git a/mysql-test/t/auto_increment_ranges_innodb.test b/mysql-test/t/auto_increment_ranges_innodb.test index c2afee7ac66..3317153c31a 100644 --- a/mysql-test/t/auto_increment_ranges_innodb.test +++ b/mysql-test/t/auto_increment_ranges_innodb.test @@ -5,3 +5,14 @@ --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; -- cgit v1.2.1 From b7eca63620df2d4626faa54a171cf0a190cf6924 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Thu, 1 Nov 2018 18:47:53 +0100 Subject: fix the test to clean after itself followup for c32f7ed235f --- mysql-test/t/auto_increment_ranges_innodb.test | 2 ++ 1 file changed, 2 insertions(+) (limited to 'mysql-test/t/auto_increment_ranges_innodb.test') diff --git a/mysql-test/t/auto_increment_ranges_innodb.test b/mysql-test/t/auto_increment_ranges_innodb.test index 3317153c31a..016ca16bd91 100644 --- a/mysql-test/t/auto_increment_ranges_innodb.test +++ b/mysql-test/t/auto_increment_ranges_innodb.test @@ -16,3 +16,5 @@ 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 -- cgit v1.2.1