Debian Codegraph @

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

raw
1 #
2 # BUG#20125349 - PERSISTANT STATS IS NOT UPDATED WHEN TTS IS IMPORTED.
3 #
4
5 --source include/not_embedded.inc
6 --source include/have_innodb.inc
7
8 let MYSQLD_DATADIR =`SELECT @@datadir`;
9
10 CREATE TABLE t1 (
11 col_1 CHAR (255),
12 col_2 VARCHAR (255)
13 ) ENGINE = InnoDB;
14
15 CREATE INDEX idx1 ON t1(col_1);
16 CREATE INDEX idx2 ON t1(col_2);
17
18 SHOW INDEXES FROM t1;
19
20 INSERT INTO t1 VALUES ("col1_00001", "col2_00001"), ("col1_00002", "col2_00002");
21
22 # Here, the cardinality would sometimes be 2 (already updated), sometimes 1.
23 # SHOW INDEXES FROM t1;
24
25 SET STATEMENT use_stat_tables=never FOR
26 ANALYZE TABLE t1;
27 SHOW INDEXES FROM t1;
28
29 FLUSH TABLES t1 FOR EXPORT;
30 perl;
31 do "$ENV{MTR_SUITE_DIR}/../innodb/include/innodb-util.pl";
32 ib_backup_tablespaces("test", "t1");
33 EOF
34
35 UNLOCK TABLES;
36
37 DROP TABLE t1;
38
39 CREATE TABLE t1 (
40 col_1 CHAR (255),
41 col_2 VARCHAR (255)
42 ) ENGINE = InnoDB STATS_PERSISTENT=1;
43
44 CREATE INDEX idx1 ON t1(col_1);
45 CREATE INDEX idx2 ON t1(col_2);
46
47 SHOW INDEXES FROM t1;
48
49 INSERT INTO t1 VALUES ("col1_00001", "col2_00001");
50
51 SHOW INDEXES FROM t1;
52
53 SET STATEMENT use_stat_tables=never FOR
54 ANALYZE TABLE t1;
55 SHOW INDEXES FROM t1;
56
57 ALTER TABLE t1 DISCARD TABLESPACE;
58
59 perl;
60 do "$ENV{MTR_SUITE_DIR}/../innodb/include/innodb-util.pl";
61 ib_discard_tablespaces("test", "t1");
62 ib_restore_tablespaces("test", "t1");
63 EOF
64
65 ALTER TABLE t1 IMPORT TABLESPACE;
66
67 SHOW INDEXES FROM t1;
68
69 SET STATEMENT use_stat_tables=never FOR
70 ANALYZE TABLE t1;
71 SHOW INDEXES FROM t1;
72
73 DROP TABLE t1;
74
75 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t1*.ibd
76 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t1*.cfg