Debian Codegraph @

mysql-test/suite/innodb/r/insert_into_empty_notembedded.result

raw
1 #
2 # Start of 10.6 tests
3 #
4 #
5 # MDEV-27214 Import with disabled keys corrupts meta-data like rows, indexes, ...
6 #
7 CREATE DATABASE db1;
8 CREATE TABLE db1.t1 (id int, a int,PRIMARY KEY (id)) ENGINE=InnoDB
9 STATS_PERSISTENT=1 STATS_AUTO_RECALC=1;
10 INSERT INTO db1.t1 VALUES (1,2),(2,3),(3,4);
11 DROP DATABASE IF EXISTS db1;
12 CREATE DATABASE db1;
13 # Wait till statistics update after bulk insert operation
14 SELECT TABLE_ROWS, AVG_ROW_LENGTH>0 FROM INFORMATION_SCHEMA.TABLES
15 WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='db1';
16 TABLE_ROWS AVG_ROW_LENGTH>0
17 3 1
18 OPTIMIZE TABLE db1.t1;
19 Table Op Msg_type Msg_text
20 db1.t1 optimize note Table does not support optimize, doing recreate + analyze instead
21 db1.t1 optimize status OK
22 # Wait till statistics update after bulk insert operation
23 SELECT TABLE_ROWS, AVG_ROW_LENGTH>0 FROM INFORMATION_SCHEMA.TABLES
24 WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='db1';
25 TABLE_ROWS AVG_ROW_LENGTH>0
26 3 1
27 DROP DATABASE db1;
28 #
29 # End of 10.6 tests
30 #
31 SET foreign_key_checks=0, unique_checks=0;
32 #
33 # MDEV-30796 Auto_increment values not updated after bulk
34 # insert operation
35 #
36 CREATE TABLE t1(f1 INT NOT NULL AUTO_INCREMENT,
37 f2 INT NOT NULL, PRIMARY KEY(f1))ENGINE=InnoDB;
38 INSERT INTO t1 VALUES(1, 2), (25, 3), (2, 4);
39 SHOW CREATE TABLE t1;
40 Table Create Table
41 t1 CREATE TABLE `t1` (
42 `f1` int(11) NOT NULL AUTO_INCREMENT,
43 `f2` int(11) NOT NULL,
44 PRIMARY KEY (`f1`)
45 ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
46 # restart
47 SHOW CREATE TABLE t1;
48 Table Create Table
49 t1 CREATE TABLE `t1` (
50 `f1` int(11) NOT NULL AUTO_INCREMENT,
51 `f2` int(11) NOT NULL,
52 PRIMARY KEY (`f1`)
53 ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
54 INSERT INTO t1(f2) VALUES(5);
55 SELECT max(f1) FROM t1;
56 max(f1)
57 26
58 DROP TABLE t1;
59 # End of 10.9 tests