~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/case.result

  • Committer: Brian Aker
  • Date: 2009-04-01 01:25:04 UTC
  • mfrom: (968.2.27 mordred)
  • Revision ID: brian@tangent.org-20090401012504-mq9sxcmph5jc1fh6
Merge Monty

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=InnoDB
 
121
) ENGINE=DEFAULT
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) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL
166
 
) ENGINE=InnoDB
 
166
) ENGINE=DEFAULT
167
167
DROP TABLE t1;
168
168
SELECT 'case+union+test'
169
169
UNION