Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.12, 5.5, 10.0, 10.1
-
None
-
3.2.0-4-amd64 #1 SMP Debian 3.2.35-2 x86_64 GNU/Linux
Description
Scenario:
CREATE TABLE `t4` (
`hour` tinyint(3) unsigned AS (HOUR(period)) VIRTUAL,
`period` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PARTITION BY HASH (`hour`) PARTITIONS 24;
Â
insert into t4 select null, NOW() + INTERVAL RAND()*100 HOUR from seq_1_to_10000;
- Repeat the following query:
delete from t4 limit 1000;
Actual result: Error: Found a row in wrong partition.