| 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 |