1DROP TABLE IF EXISTS t1; 2FLUSH TABLES; 3SELECT * FROM t1; 4ERROR HY000: The MySQL server is running with the --skip-partition option so it cannot execute this statement 5TRUNCATE TABLE t1; 6ERROR 42S02: Table 'test.t1' doesn't exist 7ANALYZE TABLE t1; 8Table Op Msg_type Msg_text 9test.t1 analyze Error The MySQL server is running with the --skip-partition option so it cannot execute this statement 10test.t1 analyze error Corrupt 11CHECK TABLE t1; 12Table Op Msg_type Msg_text 13test.t1 check Error The MySQL server is running with the --skip-partition option so it cannot execute this statement 14test.t1 check error Corrupt 15OPTIMIZE TABLE t1; 16Table Op Msg_type Msg_text 17test.t1 optimize Error The MySQL server is running with the --skip-partition option so it cannot execute this statement 18test.t1 optimize error Corrupt 19REPAIR TABLE t1; 20Table Op Msg_type Msg_text 21test.t1 repair Error The MySQL server is running with the --skip-partition option so it cannot execute this statement 22test.t1 repair error Corrupt 23ALTER TABLE t1 REPAIR PARTITION ALL; 24Table Op Msg_type Msg_text 25test.t1 repair Error The MySQL server is running with the --skip-partition option so it cannot execute this statement 26test.t1 repair error Corrupt 27ALTER TABLE t1 CHECK PARTITION ALL; 28Table Op Msg_type Msg_text 29test.t1 check Error The MySQL server is running with the --skip-partition option so it cannot execute this statement 30test.t1 check error Corrupt 31ALTER TABLE t1 OPTIMIZE PARTITION ALL; 32Table Op Msg_type Msg_text 33test.t1 optimize Error The MySQL server is running with the --skip-partition option so it cannot execute this statement 34test.t1 optimize error Corrupt 35ALTER TABLE t1 ANALYZE PARTITION ALL; 36Table Op Msg_type Msg_text 37test.t1 analyze Error The MySQL server is running with the --skip-partition option so it cannot execute this statement 38test.t1 analyze error Corrupt 39ALTER TABLE t1 REBUILD PARTITION ALL; 40ERROR HY000: The MySQL server is running with the --skip-partition option so it cannot execute this statement 41ALTER TABLE t1 ENGINE Memory; 42ERROR HY000: The MySQL server is running with the --skip-partition option so it cannot execute this statement 43ALTER TABLE t1 ADD (new INT); 44ERROR HY000: The MySQL server is running with the --skip-partition option so it cannot execute this statement 45DROP TABLE t1; 46CREATE TABLE t1 ( 47firstname VARCHAR(25) NOT NULL, 48lastname VARCHAR(25) NOT NULL, 49username VARCHAR(16) NOT NULL, 50email VARCHAR(35), 51joined DATE NOT NULL 52) 53PARTITION BY KEY(joined) 54PARTITIONS 6; 55ERROR HY000: The MySQL server is running with the --skip-partition option so it cannot execute this statement 56ALTER TABLE t1 PARTITION BY KEY(joined) PARTITIONS 2; 57ERROR HY000: The MySQL server is running with the --skip-partition option so it cannot execute this statement 58drop table t1; 59ERROR 42S02: Unknown table 'test.t1' 60CREATE TABLE t1 ( 61firstname VARCHAR(25) NOT NULL, 62lastname VARCHAR(25) NOT NULL, 63username VARCHAR(16) NOT NULL, 64email VARCHAR(35), 65joined DATE NOT NULL 66) 67PARTITION BY RANGE( YEAR(joined) ) ( 68PARTITION p0 VALUES LESS THAN (1960), 69PARTITION p1 VALUES LESS THAN (1970), 70PARTITION p2 VALUES LESS THAN (1980), 71PARTITION p3 VALUES LESS THAN (1990), 72PARTITION p4 VALUES LESS THAN MAXVALUE 73); 74ERROR HY000: The MySQL server is running with the --skip-partition option so it cannot execute this statement 75drop table t1; 76ERROR 42S02: Unknown table 'test.t1' 77CREATE TABLE t1 (id INT, purchased DATE) 78PARTITION BY RANGE( YEAR(purchased) ) 79SUBPARTITION BY HASH( TO_DAYS(purchased) ) 80SUBPARTITIONS 2 ( 81PARTITION p0 VALUES LESS THAN (1990), 82PARTITION p1 VALUES LESS THAN (2000), 83PARTITION p2 VALUES LESS THAN MAXVALUE 84); 85ERROR HY000: The MySQL server is running with the --skip-partition option so it cannot execute this statement 86drop table t1; 87ERROR 42S02: Unknown table 'test.t1' 88create table t1 (a varchar(10) charset latin1 collate latin1_bin); 89insert into t1 values (''),(' '),('a'),('a '),('a '); 90explain partitions select * from t1 where a='a ' OR a='a'; 91id select_type table partitions type possible_keys key key_len ref rows Extra 921 SIMPLE t1 NULL ALL NULL NULL NULL NULL 5 Using where 93drop table t1; 94# 95# bug#11760213-52599: ALTER TABLE REMOVE PARTITIONING ON NON-PARTITIONED 96# TABLE CORRUPTS MYISAM 97DROP TABLE if exists `t1`; 98CREATE TABLE `t1`(`a` INT)ENGINE=myisam; 99ALTER TABLE `t1` ADD COLUMN `b` INT; 100CREATE UNIQUE INDEX `i1` ON `t1`(`b`); 101CREATE UNIQUE INDEX `i2` ON `t1`(`a`); 102ALTER TABLE `t1` ADD PRIMARY KEY (`a`); 103ALTER TABLE `t1` REMOVE PARTITIONING; 104ERROR HY000: The MySQL server is running with the --skip-partition option so it cannot execute this statement 105CHECK TABLE `t1` EXTENDED; 106Table Op Msg_type Msg_text 107test.t1 check status OK 108DROP TABLE t1; 109