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