106
106
SHOW CREATE TABLE t1;
107
107
Table Create Table
108
108
t1 CREATE TABLE `t1` (
109
`c1` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
110
`c2` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
111
`c3` varbinary(4) NOT NULL,
112
`c4` varbinary(4) NOT NULL,
113
`c5` varbinary(4) NOT NULL,
114
`c6` varbinary(4) NOT NULL,
115
`c7` decimal(2,1) NOT NULL,
116
`c8` decimal(2,1) NOT NULL,
117
`c9` decimal(2,1) DEFAULT NULL,
118
`c10` double NOT NULL,
119
`c11` double NOT NULL,
120
`c12` varbinary(5) NOT NULL
109
`c1` VARCHAR(1) COLLATE utf8_bin DEFAULT NULL,
110
`c2` VARCHAR(1) COLLATE utf8_bin DEFAULT NULL,
111
`c3` VARBINARY(4) NOT NULL,
112
`c4` VARBINARY(4) NOT NULL,
113
`c5` VARBINARY(4) NOT NULL,
114
`c6` VARBINARY(4) NOT NULL,
115
`c7` DECIMAL(2,1) NOT NULL,
116
`c8` DECIMAL(2,1) NOT NULL,
117
`c9` DECIMAL(2,1) DEFAULT NULL,
118
`c10` DOUBLE NOT NULL,
119
`c11` DOUBLE NOT NULL,
120
`c12` VARBINARY(5) NOT NULL
121
) ENGINE=DEFAULT COLLATE = utf8_general_ci
156
156
SHOW CREATE TABLE t1;
157
157
Table Create Table
158
158
t1 CREATE TABLE `t1` (
159
`COALESCE(1)` int NOT NULL,
160
`COALESCE(1.0)` decimal(2,1) NOT NULL,
161
`COALESCE('a')` varchar(1) NOT NULL,
162
`COALESCE(1,1.0)` decimal(2,1) NOT NULL,
163
`COALESCE(1,'1')` varbinary(4) NOT NULL,
164
`COALESCE(1.1,'1')` varbinary(4) NOT NULL,
165
`COALESCE('a' COLLATE utf8_bin,'b')` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL
159
`COALESCE(1)` INT NOT NULL,
160
`COALESCE(1.0)` DECIMAL(2,1) NOT NULL,
161
`COALESCE('a')` VARCHAR(1) COLLATE utf8_general_ci NOT NULL,
162
`COALESCE(1,1.0)` DECIMAL(2,1) NOT NULL,
163
`COALESCE(1,'1')` VARBINARY(4) NOT NULL,
164
`COALESCE(1.1,'1')` VARBINARY(4) NOT NULL,
165
`COALESCE('a' COLLATE utf8_bin,'b')` VARCHAR(1) COLLATE utf8_bin DEFAULT NULL
166
) ENGINE=DEFAULT COLLATE = utf8_general_ci
168
168
SELECT 'case+union+test'