Debian Codegraph @

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

raw
1 #
2 # Bug#33319149: TABLE ID is not updated in dd::Column se_private_date
3 # for discarded table
4 #
5 # Test for non-partitioned table
6 CREATE TABLE t1 (c1 INT, c2 INT as (c1 + 1) VIRTUAL);
7 SELECT TABLE_ID INTO @old_tableid FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME
8 LIKE '%t1%';
9 SET SESSION debug= '+d,skip_dd_table_access_check';
10 SET @query = CONCAT("SELECT COUNT(*) FROM mysql.columns WHERE SE_PRIVATE_DATA like \"%table_id=", @old_tableid, "%\"");
11 PREPARE stmt FROM @query;
12 EXECUTE stmt;
13 COUNT(*)
14 5
15 DEALLOCATE PREPARE stmt;
16 ALTER TABLE t1 DISCARD TABLESPACE;
17 SELECT TABLE_ID INTO @new_tableid FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME
18 LIKE '%t1%';
19 SET @query = CONCAT("SELECT COUNT(*) FROM mysql.columns WHERE SE_PRIVATE_DATA like \"%table_id=", @new_tableid, "%\"");
20 PREPARE stmt FROM @query;
21 EXECUTE stmt;
22 COUNT(*)
23 5
24 DEALLOCATE PREPARE stmt;
25 DROP TABLE t1;
26 # Test for partitioned table
27 CREATE TABLE tpart (c1 INT, c2 INT as (c1 + 1) VIRTUAL)
28 PARTITION BY RANGE (c1) (
29 PARTITION p1 VALUES LESS THAN (10),
30 PARTITION p2 VALUES LESS THAN (100));
31 SELECT TABLE_ID INTO @old_tableid FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME
32 LIKE '%tpart%' LIMIT 1;
33 SET @query = CONCAT("SELECT COUNT(*) FROM mysql.columns WHERE SE_PRIVATE_DATA like \"%table_id=", @old_tableid, "%\"");
34 PREPARE stmt FROM @query;
35 EXECUTE stmt;
36 COUNT(*)
37 5
38 DEALLOCATE PREPARE stmt;
39 ALTER TABLE tpart DISCARD TABLESPACE;
40 SELECT TABLE_ID INTO @new_tableid FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME
41 LIKE '%tpart%' LIMIT 1;
42 SET @query = CONCAT("SELECT COUNT(*) FROM mysql.columns WHERE SE_PRIVATE_DATA like \"%table_id=", @new_tableid, "%\"");
43 PREPARE stmt FROM @query;
44 EXECUTE stmt;
45 COUNT(*)
46 5
47 DEALLOCATE PREPARE stmt;
48 SET SESSION debug= '-d,skip_dd_table_access_check';
49 DROP TABLE tpart;