1--source include/have_innodb.inc 2--source include/have_partition.inc 3 4set @save_query_cache_size=@@query_cache_size; 5SET GLOBAL query_cache_size=1024*1024*8; 6CREATE TABLE `test` ( 7 `uniqueId` INT NOT NULL, 8 `partitionId` INT NOT NULL, 9 PRIMARY KEY (`uniqueId`,`partitionId`) 10) ENGINE=InnoDB PARTITION BY LIST (partitionId) ( 11 PARTITION p01 VALUES IN (1), 12 PARTITION p02 VALUES IN (2) 13); 14 15 16INSERT INTO `test`(`uniqueId`,`partitionId`) VALUES(407237055, 2); 17 18SELECT * FROM `test`; 19 20--echo #Confirms 1 row in partition 'p02' 21SELECT TABLE_NAME, PARTITION_NAME, TABLE_ROWS FROM information_schema.PARTITIONS where TABLE_NAME = 'test'; 22ALTER TABLE `test` TRUNCATE PARTITION `p02`; 23 24--echo #Confirms no more rows in partition 'p02' 25SELECT TABLE_NAME, PARTITION_NAME, TABLE_ROWS FROM information_schema.PARTITIONS where TABLE_NAME = 'test'; 26 27--echo #Before the patch, this returned the previously existing values. 28SELECT * FROM `test`; 29SELECT SQL_CACHE * FROM `test`; 30SELECT SQL_NO_CACHE * FROM `test`; 31 32DROP TABLE test; 33SET GLOBAL query_cache_size=@save_query_cache_size; 34