--source include/have_debug_sync.inc --echo # --echo # Bug#33319149: TABLE ID is not updated in dd::Column se_private_date --echo # for discarded table --echo # --echo # Test for non-partitioned table # Verify that the table_id is updated in the column metadata # after discarding a tablespace of a non-partitioned table CREATE TABLE t1 (c1 INT, c2 INT as (c1 + 1) VIRTUAL); SELECT TABLE_ID INTO @old_tableid FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%t1%'; let $old_tid = `SELECT TABLE_ID FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%t1%'`; # Verify that the column metadata reflects the old table_id SET SESSION debug= '+d,skip_dd_table_access_check'; SET @query = CONCAT("SELECT COUNT(*) FROM mysql.columns WHERE SE_PRIVATE_DATA like \"%table_id=", @old_tableid, "%\""); PREPARE stmt FROM @query; EXECUTE stmt; DEALLOCATE PREPARE stmt; # Discard the tablespace ALTER TABLE t1 DISCARD TABLESPACE; SELECT TABLE_ID INTO @new_tableid FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%t1%'; let $new_tid = `SELECT TABLE_ID FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%t1%'`; # Verify that the table_id has been updated if ($old_tid == $new_tid) { --echo 'ERROR: table_id not updated'; } # Verify that the column metadata reflects the new table_id SET @query = CONCAT("SELECT COUNT(*) FROM mysql.columns WHERE SE_PRIVATE_DATA like \"%table_id=", @new_tableid, "%\""); PREPARE stmt FROM @query; EXECUTE stmt; DEALLOCATE PREPARE stmt; DROP TABLE t1; --echo # Test for partitioned table # Verify that the table_id is updated in the column metadata # after discarding a tablespace of a partitioned table CREATE TABLE tpart (c1 INT, c2 INT as (c1 + 1) VIRTUAL) PARTITION BY RANGE (c1) ( PARTITION p1 VALUES LESS THAN (10), PARTITION p2 VALUES LESS THAN (100)); SELECT TABLE_ID INTO @old_tableid FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%tpart%' LIMIT 1; let $old_tid = `SELECT TABLE_ID FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%tpart%' LIMIT 1`; # Verify that the column metadata reflects the old table_id SET @query = CONCAT("SELECT COUNT(*) FROM mysql.columns WHERE SE_PRIVATE_DATA like \"%table_id=", @old_tableid, "%\""); PREPARE stmt FROM @query; EXECUTE stmt; DEALLOCATE PREPARE stmt; # Discard the tablespace ALTER TABLE tpart DISCARD TABLESPACE; SELECT TABLE_ID INTO @new_tableid FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%tpart%' LIMIT 1; let $new_tid = `SELECT TABLE_ID FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%tpart%' LIMIT 1`; # Verify that the table_id has been updated if ($old_tid == $new_tid) { --echo 'ERROR: table_id not updated'; } # Verify that the column metadata reflects the new table_id SET @query = CONCAT("SELECT COUNT(*) FROM mysql.columns WHERE SE_PRIVATE_DATA like \"%table_id=", @new_tableid, "%\""); PREPARE stmt FROM @query; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET SESSION debug= '-d,skip_dd_table_access_check'; DROP TABLE tpart;