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`;

-- Returns 1 row

SELECT TABLE_NAME, PARTITION_NAME, TABLE_ROWS FROM information_schema.PARTITIONS where TABLE_NAME = 'test';

-- Confirms 1 row in partition 'p02'

ALTER TABLE `test` TRUNCATE PARTITION `p02`;

-- Query OK

SELECT TABLE_NAME, PARTITION_NAME, TABLE_ROWS FROM information_schema.PARTITIONS where TABLE_NAME = 'test';

-- Both zero

SELECT * FROM `test`;

-- Still returns 1 row(!!)

SELECT SQL_CACHE * FROM `test`;

-- Correctly returns zero rows

SELECT SQL_NO_CACHE * FROM `test`;

-- Correctly returns zero rows