Debian Codegraph @

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

raw
1 # Test setup.
2 CREATE TABLE t1 (
3 c1 INT PRIMARY KEY,
4 c2 VARCHAR(50),
5 c3 VARCHAR(50),
6 c4 VARCHAR(50)
7 );
8 INSERT INTO t1 (c1, c2, c3, c4)
9 VALUES
10 (1, 'AAA_2', 'AAA_3', 'AAA_4'),
11 (2, 'BBB_2', 'BBB_3', 'BBB_4'),
12 (3, 'CCC_2', 'CCC_3', 'CCC_4'),
13 (4, 'DDD_2', 'DDD_3', 'DDD_4'),
14 (5, 'EEE_2', 'EEE_3', 'EEE_4');
15 # Start test.
16 ALTER TABLE t1 CONVERT TO CHARACTER SET 'utf8mb4',ALGORITHM=COPY;
17 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name IN ('t1') ;
18 n_rows database_name table_name
19 5 test t1
20 ALTER TABLE t1 ADD COLUMN c5 VARCHAR(15), ALGORITHM = COPY;
21 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name IN ('t1') ;
22 n_rows database_name table_name
23 5 test t1
24 ALTER TABLE t1 DROP COLUMN c5, ALGORITHM = COPY;
25 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name IN ('t1') ;
26 n_rows database_name table_name
27 5 test t1
28 ALTER TABLE t1 ADD COLUMN c5 VARCHAR(15), ALGORITHM = COPY;
29 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name IN ('t1') ;
30 n_rows database_name table_name
31 5 test t1
32 ALTER TABLE t1 DROP COLUMN c5, ALGORITHM = COPY;
33 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name IN ('t1') ;
34 n_rows database_name table_name
35 5 test t1
36 ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY (c4), ALGORITHM=COPY;
37 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name IN ('t1') ;
38 n_rows database_name table_name
39 5 test t1
40 ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY (c1), ALGORITHM=INPLACE;
41 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name IN ('t1') ;
42 n_rows database_name table_name
43 5 test t1
44 ALTER TABLE t1 ADD COLUMN c5 VARCHAR(15), ALGORITHM = INPLACE;
45 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name IN ('t1') ;
46 n_rows database_name table_name
47 5 test t1
48 ALTER TABLE t1 DROP COLUMN c5, ALGORITHM = INPLACE;
49 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name IN ('t1') ;
50 n_rows database_name table_name
51 5 test t1
52 CREATE TABLE t2 (
53 c1 INT PRIMARY KEY,
54 c2 VARCHAR(50),
55 c3 VARCHAR(50),
56 c4 VARCHAR(50)
57 ) PARTITION BY RANGE (c1) (
58 PARTITION p1 VALUES LESS THAN (6),
59 PARTITION p2 VALUES LESS THAN (11),
60 PARTITION p3 VALUES LESS THAN (16),
61 PARTITION p4 VALUES LESS THAN (21)
62 );
63 INSERT INTO t2 (c1, c2, c3, c4)
64 VALUES
65 (1, 'AAA_2', 'AAA_3', 'AAA_4'),
66 (2, 'BBB_2', 'BBB_3', 'BBB_4'),
67 (3, 'CCC_2', 'CCC_3', 'CCC_4'),
68 (4, 'DDD_2', 'DDD_3', 'DDD_4'),
69 (5, 'EEE_2', 'EEE_3', 'EEE_4'),
70 (6, 'FFF_2', 'DDD_3', 'DDD_4'),
71 (7, 'GGG_2', 'DDD_3', 'DDD_4'),
72 (8, 'HHH_2', 'DDD_3', 'DDD_4'),
73 (9, 'III_2', 'DDD_3', 'DDD_4'),
74 (10, 'JJJ_2', 'DDD_3', 'DDD_4'),
75 (13, 'KKK_2', 'DDD_3', 'DDD_4'),
76 (20, 'LLL_2', 'DDD_3', 'DDD_4');
77 ALTER TABLE t2 CONVERT TO CHARACTER SET 'utf8mb4',ALGORITHM=COPY;
78 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name LIKE '%t2%';
79 n_rows database_name table_name
80 5 test t2#p#p1
81 5 test t2#p#p2
82 1 test t2#p#p3
83 1 test t2#p#p4
84 ALTER TABLE t2 ADD COLUMN c5 VARCHAR(15), ALGORITHM = COPY;
85 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name LIKE '%t2%';
86 n_rows database_name table_name
87 5 test t2#p#p1
88 5 test t2#p#p2
89 1 test t2#p#p3
90 1 test t2#p#p4
91 ALTER TABLE t2 DROP COLUMN c5, ALGORITHM = COPY;
92 SELECT n_rows, database_name, table_name FROM mysql.innodb_table_stats WHERE table_name LIKE '%t2%';
93 n_rows database_name table_name
94 5 test t2#p#p1
95 5 test t2#p#p2
96 1 test t2#p#p3
97 1 test t2#p#p4
98 # Test Cleanup.
99 DROP TABLE t1;
100 DROP TABLE t2;