1
drop table if exists t1;
2
create table t1 (a set (' ','a','b') not null);
6
`a` set('','a','b') NOT NULL
7
) ENGINE=MyISAM DEFAULT CHARSET=latin1
9
create table t1 (a set (' ','a','b ') not null default 'b ');
12
t1 CREATE TABLE `t1` (
13
`a` set('','a','b') NOT NULL DEFAULT 'b'
14
) ENGINE=MyISAM DEFAULT CHARSET=latin1
16
CREATE TABLE t1 ( user varchar(64) NOT NULL default '', path varchar(255) NOT NULL default '', privilege set('select','RESERVED30','RESERVED29','RESERVED28','RESERVED27','RESERVED26', 'RESERVED25','RESERVED24','data.delete','RESERVED22','RESERVED21', 'RESERVED20','data.insert.none','data.insert.approve', 'data.insert.delete','data.insert.move','data.insert.propose', 'data.insert.reject','RESERVED13','RESERVED12','RESERVED11','RESERVED10', 'RESERVED09','data.update','RESERVED07','RESERVED06','RESERVED05', 'RESERVED04','metadata.delete','metadata.put','RESERVED01','RESERVED00') NOT NULL default '', KEY user (user) ) ENGINE=MyISAM CHARSET=utf8;
19
create table t1 (s set ('a','A') character set latin1 collate latin1_bin);
22
t1 CREATE TABLE `t1` (
23
`s` set('a','A') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL
24
) ENGINE=MyISAM DEFAULT CHARSET=latin1
25
insert into t1 values ('a'),('a,A'),('A,a'),('A');
26
select s from t1 order by s;
32
select s from t1 order by concat(s);
39
CREATE TABLE t1 (c set('ae','oe','ue','ss') collate latin1_german2_ci);
40
INSERT INTO t1 VALUES ('�'),('�'),('�'),('�');
41
INSERT INTO t1 VALUES ('ae'),('oe'),('ue'),('ss');
42
INSERT INTO t1 VALUES ('�,�,�,�');
43
INSERT INTO t1 VALUES ('ae,oe,ue,ss');
44
SELECT c FROM t1 ORDER BY c;
56
SELECT c FROM t1 ORDER BY concat(c);
70
set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17',
71
'18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33',
72
'34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49',
73
'50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','128'));
74
ERROR HY000: Too many strings for column f1 and SET
76
set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17',
77
'18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33',
78
'34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49',
79
'50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','1'));
81
Note 1291 Column 'f1' has duplicated value '1' in SET
84
t1 CREATE TABLE `t1` (
85
`f1` set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','1') DEFAULT NULL
86
) ENGINE=MyISAM DEFAULT CHARSET=latin1
88
CREATE TABLE t1(c set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64'));
89
INSERT INTO t1 VALUES(7);
90
INSERT INTO t1 VALUES(9223372036854775808);