1
DROP TABLE IF EXISTS t1;
4
ERROR 42000: Unknown table engine 'partition'
6
ERROR 42000: Unknown table engine 'partition'
8
Table Op Msg_type Msg_text
9
test.t1 analyze Error Unknown table engine 'partition'
10
test.t1 analyze error Corrupt
12
Table Op Msg_type Msg_text
13
test.t1 check Error Unknown table engine 'partition'
14
test.t1 check error Corrupt
16
Table Op Msg_type Msg_text
17
test.t1 optimize Error Unknown table engine 'partition'
18
test.t1 optimize error Corrupt
20
Table Op Msg_type Msg_text
21
test.t1 repair Error Unknown table engine 'partition'
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'
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'
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'
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'
38
test.t1 analyze error Corrupt
39
ALTER TABLE t1 REBUILD PARTITION ALL;
40
ERROR 42000: Unknown table engine 'partition'
41
ALTER TABLE t1 ENGINE Memory;
42
ERROR 42000: Unknown table engine 'partition'
43
ALTER TABLE t1 ADD (new INT);
44
ERROR 42000: Unknown table engine 'partition'
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