| 1 |
CREATE TABLE t1 (i INT) ENGINE=MyISAM |
| 2 |
PARTITION BY RANGE (i) ( |
| 3 |
PARTITION p00 VALUES LESS THAN (1), |
| 4 |
PARTITION p01 VALUES LESS THAN (2) |
| 5 |
); |
| 6 |
INSERT IGNORE INTO t1 VALUES (3); |
| 7 |
Warnings: |
| 8 |
Warning 1526 Table has no partition for value 3 |
| 9 |
DROP TABLE t1; |