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