summaryrefslogtreecommitdiff
path: root/mysql-test/r/truncate-stale-6500.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/truncate-stale-6500.result')
-rw-r--r--mysql-test/r/truncate-stale-6500.result33
1 files changed, 0 insertions, 33 deletions
diff --git a/mysql-test/r/truncate-stale-6500.result b/mysql-test/r/truncate-stale-6500.result
deleted file mode 100644
index b6222716953..00000000000
--- a/mysql-test/r/truncate-stale-6500.result
+++ /dev/null
@@ -1,33 +0,0 @@
-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`;
-uniqueId partitionId
-407237055 2
-#Confirms 1 row in partition 'p02'
-SELECT TABLE_NAME, PARTITION_NAME, TABLE_ROWS FROM information_schema.PARTITIONS where TABLE_NAME = 'test';
-TABLE_NAME PARTITION_NAME TABLE_ROWS
-test p01 0
-test p02 1
-ALTER TABLE `test` TRUNCATE PARTITION `p02`;
-#Confirms no more rows in partition 'p02'
-SELECT TABLE_NAME, PARTITION_NAME, TABLE_ROWS FROM information_schema.PARTITIONS where TABLE_NAME = 'test';
-TABLE_NAME PARTITION_NAME TABLE_ROWS
-test p01 0
-test p02 0
-#Before the patch, this returned the previously existing values.
-SELECT * FROM `test`;
-uniqueId partitionId
-SELECT SQL_CACHE * FROM `test`;
-uniqueId partitionId
-SELECT SQL_NO_CACHE * FROM `test`;
-uniqueId partitionId
-DROP TABLE test;
-SET GLOBAL query_cache_size=DEFAULT;