2
create table t1 (a bit(65), primary key (a)) partition by key (a);
3
ERROR 42000: Display width out of range for column 'a' (max = 64)
4
create table t1 (a bit(0), primary key (a)) partition by key (a);
8
`a` bit(1) NOT NULL DEFAULT '\0',
10
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) */
12
create table t1 (a bit(0), primary key (a)) partition by key (a) (
13
partition pa1 DATA DIRECTORY =
14
'/tmp' INDEX DIRECTORY =
16
partition pa2 DATA DIRECTORY =
17
'/tmp' INDEX DIRECTORY =
21
t1 CREATE TABLE `t1` (
22
`a` bit(1) NOT NULL DEFAULT '\0',
24
) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='/tmp/' INDEX DIRECTORY='/tmp/' /*!50100 PARTITION BY KEY (a) (PARTITION pa1 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM) */
26
create table t1 (a bit(64), primary key (a)) partition by key (a);
29
t1 CREATE TABLE `t1` (
30
`a` bit(64) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0',
32
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) */
34
(b'1111111111111111111111111111111111111111111111111111111111111111'),
35
(b'1000000000000000000000000000000000000000000000000000000000000000'),
36
(b'0000000000000000000000000000000000000000000000000000000000000001'),
37
(b'1010101010101010101010101010101010101010101010101010101010101010'),
38
(b'0101010101010101010101010101010101010101010101010101010101010101');
39
select hex(a) from t1;
47
create table t1 (a bit(64), primary key (a)) partition by key (a)(
48
partition pa1 DATA DIRECTORY =
49
'/tmp' INDEX DIRECTORY =
50
'/tmp' max_rows=20 min_rows=2,
51
partition pa2 DATA DIRECTORY =
52
'/tmp' INDEX DIRECTORY =
53
'/tmp' max_rows=30 min_rows=3,
54
partition pa3 DATA DIRECTORY =
55
'/tmp' INDEX DIRECTORY =
56
'/tmp' max_rows=30 min_rows=4,
57
partition pa4 DATA DIRECTORY =
58
'/tmp' INDEX DIRECTORY =
59
'/tmp' max_rows=40 min_rows=2);
62
t1 CREATE TABLE `t1` (
63
`a` bit(64) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0',
65
) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='/tmp/' INDEX DIRECTORY='/tmp/' /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM) */
67
(b'1111111111111111111111111111111111111111111111111111111111111111'),
68
(b'1000000000000000000000000000000000000000000000000000000000000000'),
69
(b'0000000000000000000000000000000000000000000000000000000000000001'),
70
(b'1010101010101010101010101010101010101010101010101010101010101010'),
71
(b'0101010101010101010101010101010101010101010101010101010101010101');
72
select hex(a) from t1;
80
create table t1 (a bit, primary key (a)) partition by key (a);
83
t1 CREATE TABLE `t1` (
84
`a` bit(1) NOT NULL DEFAULT '\0',
86
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) */
87
insert into t1 values (b'0'), (b'1');
88
select hex(a) from t1;
92
alter table t1 drop primary key;
95
t1 CREATE TABLE `t1` (
96
`a` bit(1) NOT NULL DEFAULT '\0'
97
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) */
98
select hex(a) from t1;
102
alter table t1 add primary key (a);
103
show create table t1;
105
t1 CREATE TABLE `t1` (
106
`a` bit(1) NOT NULL DEFAULT '\0',
108
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) */
109
select hex(a) from t1;