Debian Codegraph @

mysql-test/suite/innodb/t/insert_into_empty_notembedded.test

raw
1 --source include/not_embedded.inc
2 --source include/have_innodb.inc
3 --source include/innodb_page_size.inc
4 --source include/maybe_debug.inc
5
6 --echo #
7 --echo # Start of 10.6 tests
8 --echo #
9
10 --echo #
11 --echo # MDEV-27214 Import with disabled keys corrupts meta-data like rows, indexes, ...
12 --echo #
13
14 CREATE DATABASE db1;
15 CREATE TABLE db1.t1 (id int, a int,PRIMARY KEY (id)) ENGINE=InnoDB
16 STATS_PERSISTENT=1 STATS_AUTO_RECALC=1;
17 INSERT INTO db1.t1 VALUES (1,2),(2,3),(3,4);
18 --let $file = $MYSQLTEST_VARDIR/tmp/dump.sql
19 --exec $MYSQL_DUMP db1 t1 >$file
20 DROP DATABASE IF EXISTS db1;
21
22 CREATE DATABASE db1;
23 --exec $MYSQL db1 < $file
24 --remove_file $file
25 --echo # Wait till statistics update after bulk insert operation
26 let $wait_condition= select n_rows > 0 from mysql.innodb_table_stats
27 where database_name='db1' and table_name='t1';
28 source include/wait_condition.inc;
29 SELECT TABLE_ROWS, AVG_ROW_LENGTH>0 FROM INFORMATION_SCHEMA.TABLES
30 WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='db1';
31
32 OPTIMIZE TABLE db1.t1;
33 --echo # Wait till statistics update after bulk insert operation
34 let $wait_condition= select n_rows > 0 from mysql.innodb_table_stats
35 where database_name='db1' and table_name='t1';
36 source include/wait_condition.inc;
37 SELECT TABLE_ROWS, AVG_ROW_LENGTH>0 FROM INFORMATION_SCHEMA.TABLES
38 WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='db1';
39 DROP DATABASE db1;
40
41 --echo #
42 --echo # End of 10.6 tests
43 --echo #
44
45 SET foreign_key_checks=0, unique_checks=0;
46 --echo #
47 --echo # MDEV-30796 Auto_increment values not updated after bulk
48 --echo # insert operation
49 --echo #
50 CREATE TABLE t1(f1 INT NOT NULL AUTO_INCREMENT,
51 f2 INT NOT NULL, PRIMARY KEY(f1))ENGINE=InnoDB;
52 INSERT INTO t1 VALUES(1, 2), (25, 3), (2, 4);
53 SHOW CREATE TABLE t1;
54 --source include/restart_mysqld.inc
55 SHOW CREATE TABLE t1;
56 INSERT INTO t1(f2) VALUES(5);
57 SELECT max(f1) FROM t1;
58 DROP TABLE t1;
59
60 --echo # End of 10.9 tests