1
--- r/type_enum.result 2011-10-21 23:09:08.000000000 +0200
2
+++ r/type_enum.reject 2012-02-10 16:23:46.000000000 +0100
3
@@ -1627,14 +1627,14 @@
6
`a` enum('','a','b') NOT NULL
7
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
8
+) ENGINE=PBXT DEFAULT CHARSET=latin1
10
create table t1 (a enum (' ','a','b ') not null default 'b ');
13
t1 CREATE TABLE `t1` (
14
`a` enum('','a','b') NOT NULL DEFAULT 'b'
15
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
16
+) ENGINE=PBXT DEFAULT CHARSET=latin1
18
create table t1 (a enum ('0','1'));
19
insert into t1 set a='foobar';
22
t1 CREATE TABLE `t1` (
23
`a` enum('�','1','2') NOT NULL DEFAULT '�'
24
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
25
+) ENGINE=PBXT DEFAULT CHARSET=latin1
30
t1 CREATE TABLE `t1` (
31
`a` int(11) DEFAULT '1',
32
`b` enum('value','���_value','���') NOT NULL
33
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
34
+) ENGINE=PBXT DEFAULT CHARSET=latin1
36
Field Type Null Key Default Extra
40
t1 CREATE TABLE `t1` (
41
`a` enum('�','�','�') CHARACTER SET utf8 DEFAULT '�'
42
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
43
+) ENGINE=PBXT DEFAULT CHARSET=latin1
44
insert into t1 values ('�'), ('�'), ('�');
45
select a from t1 order by a;
49
t1 CREATE TABLE `t1` (
50
`a` enum('�','�','�') DEFAULT '�'
51
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
52
+) ENGINE=PBXT DEFAULT CHARSET=latin1
53
select a from t1 order by a;
56
@@ -1752,28 +1752,28 @@
57
t1 CREATE TABLE `t1` (
58
`f1` int(11) DEFAULT NULL,
59
`f2` enum('��') DEFAULT NULL
60
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
61
+) ENGINE=PBXT DEFAULT CHARSET=latin1
63
create table t1(russian enum('E','F','E�F','F�E') NOT NULL DEFAULT'E');
66
t1 CREATE TABLE `t1` (
67
`russian` enum('E','F','E�F','F�E') NOT NULL DEFAULT 'E'
68
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
69
+) ENGINE=PBXT DEFAULT CHARSET=latin1
71
create table t1(denormal enum('E','F','E,F','F,E') NOT NULL DEFAULT'E');
74
t1 CREATE TABLE `t1` (
75
`denormal` enum('E','F','E,F','F,E') NOT NULL DEFAULT 'E'
76
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
77
+) ENGINE=PBXT DEFAULT CHARSET=latin1
79
create table t1(russian_deviant enum('E','F','E�F','F,E') NOT NULL DEFAULT'E');
82
t1 CREATE TABLE `t1` (
83
`russian_deviant` enum('E','F','E�F','F,E') NOT NULL DEFAULT 'E'
84
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
85
+) ENGINE=PBXT DEFAULT CHARSET=latin1
87
create table t1(exhausting_charset enum('ABCDEFGHIJKLMNOPQRSTUVWXYZ','
b'\x0e\x0f\x10\x11\x12\x13\x14\x15\x16\x17\x18\x19\x1a\x1b\x1c\x1d\x1e\x1f !"\',\'#$%&\\\'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\\\\]^_`abcdefghijklmnopqrstuvwxyz{|}~\',\'xx\\\x7f\',\'yy\\\x80\',\'zz\x81\x82\x83\x84\x85\x86\x87\x88\x89\x8a\x8b\x8c\x8d\x8e\x8f\x90\x91\x92\x93\x94\x95\x96\x97\x98\x99\x9a\x9b\x9c\x9d\x9e\x9f\xa0\xa1\xa2\xa3\xa4\xa5\xa6\xa7\xa8\xa9\xaa\xab\xac\xad\xae\xaf\xb0\xb1\xb2\xb3\xb4\xb5\xb6\xb7\xb8\xb9\xba\xbb\xbc\xbd\xbe\xbf\xc0\xc1\xc2\xc3\xc4\xc5\xc6\xc7\xc8\xc9\xca\xcb\xcc\xcd\xce\xcf\xd0\xd1\xd2\xd3\xd4\xd5\xd6\xd7\xd8\xd9\xda\xdb\xdc\xdd\xde\xdf\xe0\xe1\xe2\xe3\xe4\xe5\xe6\xe7\xe8\xe9\xea\xeb\xec\xed\xee\xef\xf0\xf1\xf2\xf3\xf4\xf5\xf6\xf7\xf8\xf9\xfa\xfb\xfc\xfd\xfe\xff\'));'