| Bug #16541 | Can't drop partition with MyISAM on Windows | ||
|---|---|---|---|
| Submitted: | 16 Jan 2006 16:42 | Modified: | 19 Jan 2006 13:37 |
| Reporter: | Mark Matthews | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.1.4 | OS: | Windows (Windows) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[19 Jan 2006 13:37]
Sergei Golubchik
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead. Thank you for your interest in MySQL. Additional info: see BUG#16530
Description: Can't drop a partition of type MyISAM on windows: mysql> drop table tr; Query OK, 0 rows affected (0.30 sec) mysql> CREATE TABLE tr (id INT, name VARCHAR(50), purchased DATE) engine=myisam -> PARTITION BY RANGE( YEAR(purchased) ) ( -> PARTITION p0 VALUES LESS THAN (1990), -> PARTITION p1 VALUES LESS THAN (1995), -> PARTITION p2 VALUES LESS THAN (2000), -> PARTITION p3 VALUES LESS THAN (2005)); Query OK, 0 rows affected (0.05 sec) mysql> ALTER TABLE tr DROP PARTITION p2; ERROR 6 (HY000): Error on delete of '.\test\tr_p2.MYI' (Errcode: 13) How to repeat: mysql> drop table tr; Query OK, 0 rows affected (0.30 sec) mysql> CREATE TABLE tr (id INT, name VARCHAR(50), purchased DATE) engine=myisam -> PARTITION BY RANGE( YEAR(purchased) ) ( -> PARTITION p0 VALUES LESS THAN (1990), -> PARTITION p1 VALUES LESS THAN (1995), -> PARTITION p2 VALUES LESS THAN (2000), -> PARTITION p3 VALUES LESS THAN (2005)); Query OK, 0 rows affected (0.05 sec) mysql> ALTER TABLE tr DROP PARTITION p2; ERROR 6 (HY000): Error on delete of '.\test\tr_p2.MYI' (Errcode: 13)