summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/truncate-stale-6500.test
blob: 95dc293bff9998e51b2b3064aad296dc262be5d9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
--source include/have_innodb.inc
--source include/have_partition.inc

set @save_query_cache_size=@@query_cache_size;
SET GLOBAL query_cache_size=1024*1024*8;
CREATE TABLE `test` (
  `uniqueId` INT NOT NULL,
  `partitionId` INT NOT NULL,
  PRIMARY KEY (`uniqueId`,`partitionId`)
) ENGINE=InnoDB PARTITION BY LIST (partitionId) (
 PARTITION p01 VALUES IN (1),
 PARTITION p02 VALUES IN (2)
);


INSERT INTO `test`(`uniqueId`,`partitionId`) VALUES(407237055, 2);

SELECT * FROM `test`;

--echo #Confirms 1 row in partition 'p02'
SELECT TABLE_NAME, PARTITION_NAME, TABLE_ROWS FROM information_schema.PARTITIONS where TABLE_NAME = 'test';
ALTER TABLE `test` TRUNCATE PARTITION `p02`;

--echo #Confirms no more rows in partition 'p02'
SELECT TABLE_NAME, PARTITION_NAME, TABLE_ROWS FROM information_schema.PARTITIONS where TABLE_NAME = 'test';

--echo #Before the patch, this returned the previously existing values.
SELECT * FROM `test`;
SELECT SQL_CACHE * FROM `test`;
SELECT SQL_NO_CACHE * FROM `test`;

DROP TABLE test;
SET GLOBAL query_cache_size=@save_query_cache_size;