1626
1626
show create table t1;
1627
1627
Table Create Table
1628
1628
t1 CREATE TABLE `t1` (
1629
`a` enum(' ','a','b') NOT NULL
1629
`a` ENUM(' ','a','b') NOT NULL
1630
) ENGINE=PBXT COLLATE = utf8_general_ci
1632
1632
create table t1 (a enum (' ','a','b ') not null default 'b ');
1633
1633
show create table t1;
1634
1634
Table Create Table
1635
1635
t1 CREATE TABLE `t1` (
1636
`a` enum(' ','a','b') NOT NULL DEFAULT 'b'
1636
`a` ENUM(' ','a','b') NOT NULL DEFAULT 'b'
1637
) ENGINE=PBXT COLLATE = utf8_general_ci
1639
1639
create table t1 (a enum ('0','1'));
1640
1640
insert into t1 set a='foobar';
1645
1645
select * from t1;
1648
create table t1 (a enum(0xE4, '1', '2') not null default 0xE4);
1649
ERROR HY000: Corrupt or invalid table definition:
1650
create table t1 (a enum(0xC3A4, '1', '2') not null default 0xC3A4);
1651
show columns from t1;
1652
Field Type Null Default Default_is_NULL On_Update
1654
show create table t1;
1656
t1 CREATE TABLE `t1` (
1657
`a` ENUM('ä','1','2') NOT NULL DEFAULT 'ä'
1658
) ENGINE=PBXT COLLATE = utf8_general_ci
1662
b ENUM('value','���_value','���') NOT NULL
1664
ERROR HY000: Corrupt or invalid table definition:
1665
CREATE TABLE t1 (c enum('ae','oe','ue','ss') collate utf8_unicode_ci);
1666
INSERT INTO t1 VALUES ('�');
1667
ERROR HY000: Received an invalid enum value '�'.
1668
INSERT INTO t1 values ('�');
1669
ERROR HY000: Received an invalid enum value '�'.
1670
INSERT INTO t1 values ('�');
1671
ERROR HY000: Received an invalid enum value '�'.
1672
INSERT INTO t1 values ('�');
1673
ERROR HY000: Received an invalid enum value '�'.
1678
a ENUM('�','�','�') default '�'
1680
ERROR HY000: Corrupt or invalid table definition:
1682
a ENUM('ä','ö','ü') default 'ü'
1684
insert into t1 values ('ä'),('ö'),('ü');
1685
show create table t1;
1687
t1 CREATE TABLE `t1` (
1688
`a` ENUM('ä','ö','ü') DEFAULT 'ü'
1689
) ENGINE=PBXT COLLATE = utf8_general_ci
1690
select a from t1 order by a;
1648
1696
create table t1 (a enum ('Y','N') COLLATE utf8_bin);
1649
1697
insert into t1 values ('Y');
1650
1698
alter table t1 add c enum ('Y','N') COLLATE utf8_bin;
1660
1708
show create table t1;
1661
1709
Table Create Table
1662
1710
t1 CREATE TABLE `t1` (
1663
`f1` int DEFAULT NULL,
1664
`f2` enum('Y','N') DEFAULT NULL
1711
`f1` INT DEFAULT NULL,
1712
`f2` ENUM('Y','N') DEFAULT NULL
1713
) ENGINE=PBXT COLLATE = utf8_general_ci
1715
create table t1(russian enum('E','F','E�F','F�E') NOT NULL DEFAULT'E');
1716
ERROR HY000: Corrupt or invalid table definition:
1717
create table t1(denormal enum('E','F','E,F','F,E') NOT NULL DEFAULT'E');
1718
show create table t1;
1720
t1 CREATE TABLE `t1` (
1721
`denormal` ENUM('E','F','E,F','F,E') NOT NULL DEFAULT 'E'
1722
) ENGINE=PBXT COLLATE = utf8_general_ci
1724
create table t1(russian_deviant enum('E','F','E�F','F,E') NOT NULL DEFAULT'E');
1725
ERROR HY000: Corrupt or invalid table definition:
1667
1726
CREATE TABLE t1 (
1668
1727
id INT AUTO_INCREMENT PRIMARY KEY,
1669
1728
c1 ENUM('a', '', 'b')
1723
1782
EXPLAIN SELECT a FROM t1 WHERE a=0;
1724
1783
id select_type table type possible_keys key key_len ref rows Extra
1725
1 SIMPLE t1 ALL NULL NULL NULL NULL 6 Using where
1784
1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using where
1726
1785
SELECT a FROM t1 WHERE a=0;
1728
1787
ALTER TABLE t1 ADD PRIMARY KEY (a);