type_set.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:2k
- #
- # Test of SET with space
- #
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- create table t1 (a set (' ','a','b') not null);
- show create table t1;
- drop table t1;
- create table t1 (a set (' ','a','b ') not null default 'b ');
- show create table t1;
- drop table t1;
- 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;
- DROP TABLE t1;
- #
- # Check that SET is case sensitive with a binary collation
- #
- set names latin1;
- create table t1 (s set ('a','A') character set latin1 collate latin1_bin);
- show create table t1;
- insert into t1 values ('a'),('a,A'),('A,a'),('A');
- select s from t1 order by s;
- select s from t1 order by concat(s);
- drop table t1;
- #
- # Check that SET honors a more complex collation correctly
- #
- CREATE TABLE t1 (c set('ae','oe','ue','ss') collate latin1_german2_ci);
- INSERT INTO t1 VALUES ('