~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/case.result

Merging Stewart's show create table patch.

Show diffs side-by-side

added added

removed removed

Lines of Context:
118
118
  `c10` double NOT NULL,
119
119
  `c11` double NOT NULL,
120
120
  `c12` varbinary(5) NOT NULL
121
 
) ENGINE=DEFAULT
 
121
) ENGINE=DEFAULT COLLATE = utf8_general_ci
122
122
DROP TABLE t1;
123
123
SELECT CASE 
124
124
WHEN 1 
163
163
  `COALESCE(1,'1')` varbinary(4) NOT NULL,
164
164
  `COALESCE(1.1,'1')` varbinary(4) NOT NULL,
165
165
  `COALESCE('a' COLLATE utf8_bin,'b')` varchar(1) COLLATE utf8_bin DEFAULT NULL
166
 
) ENGINE=DEFAULT
 
166
) ENGINE=DEFAULT COLLATE = utf8_general_ci
167
167
DROP TABLE t1;
168
168
SELECT 'case+union+test'
169
169
UNION