1 DROP TABLE IF EXISTS t1;
4 ERROR 42000: Unknown table engine 'partition
\x16'
6 ERROR 42000: Unknown table engine 'partition
\x16'
8 Table Op Msg_type Msg_text
9 test.t1 analyze Error Unknown table engine 'partition
\x16'
10 test.t1 analyze error Corrupt
12 Table Op Msg_type Msg_text
13 test.t1 check Error Unknown table engine 'partition
\x16'
14 test.t1 check error Corrupt
16 Table Op Msg_type Msg_text
17 test.t1 optimize Error Unknown table engine 'partition
\x16'
18 test.t1 optimize error Corrupt
20 Table Op Msg_type Msg_text
21 test.t1 repair Error Unknown table engine 'partition
\x16'
22 test.t1 repair error Corrupt
23 ALTER TABLE t1 REPAIR PARTITION ALL;
24 Table Op Msg_type Msg_text
25 test.t1 repair Error Unknown table engine 'partition
\x16'
26 test.t1 repair error Corrupt
27 ALTER TABLE t1 CHECK PARTITION ALL;
28 Table Op Msg_type Msg_text
29 test.t1 check Error Unknown table engine 'partition
\x16'
30 test.t1 check error Corrupt
31 ALTER TABLE t1 OPTIMIZE PARTITION ALL;
32 Table Op Msg_type Msg_text
33 test.t1 optimize Error Unknown table engine 'partition
\x16'
34 test.t1 optimize error Corrupt
35 ALTER TABLE t1 ANALYZE PARTITION ALL;
36 Table Op Msg_type Msg_text
37 test.t1 analyze Error Unknown table engine 'partition
\x16'
38 test.t1 analyze error Corrupt
39 ALTER TABLE t1 REBUILD PARTITION ALL;
40 ERROR 42000: Unknown table engine 'partition
\x16'
41 ALTER TABLE t1 ENGINE Memory;
42 ERROR 42000: Unknown table engine 'partition
\x16'
43 ALTER TABLE t1 ADD (new INT);
44 ERROR 42000: Unknown table engine 'partition
\x16'
47 firstname VARCHAR(25) NOT NULL,
48 lastname VARCHAR(25) NOT NULL,
49 username VARCHAR(16) NOT NULL,
53 PARTITION BY KEY(joined)
55 ERROR HY000: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working
56 ALTER TABLE t1 PARTITION BY KEY(joined) PARTITIONS 2;
57 ERROR HY000: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working
59 ERROR 42S02: Unknown table 't1'
61 firstname VARCHAR(25) NOT NULL,
62 lastname VARCHAR(25) NOT NULL,
63 username VARCHAR(16) NOT NULL,
67 PARTITION BY RANGE( YEAR(joined) ) (
68 PARTITION p0 VALUES LESS THAN (1960),
69 PARTITION p1 VALUES LESS THAN (1970),
70 PARTITION p2 VALUES LESS THAN (1980),
71 PARTITION p3 VALUES LESS THAN (1990),
72 PARTITION p4 VALUES LESS THAN MAXVALUE
74 ERROR HY000: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working
76 ERROR 42S02: Unknown table 't1'
77 CREATE TABLE t1 (id INT, purchased DATE)
78 PARTITION BY RANGE( YEAR(purchased) )
79 SUBPARTITION BY HASH( TO_DAYS(purchased) )
81 PARTITION p0 VALUES LESS THAN (1990),
82 PARTITION p1 VALUES LESS THAN (2000),
83 PARTITION p2 VALUES LESS THAN MAXVALUE
85 ERROR HY000: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working
87 ERROR 42S02: Unknown table 't1'
88 create table t1 (a varchar(10) charset latin1 collate latin1_bin);
89 insert into t1 values (''),(' '),('a'),('a '),('a ');
90 explain partitions select * from t1 where a='a ' OR a='a';
91 id select_type table partitions type possible_keys key key_len ref rows Extra
92 1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 5 Using where