~drizzle-developers/ubuntu/natty/drizzle/natty

« back to all changes in this revision

Viewing changes to tests/r/case.result

  • Committer: Monty Taylor
  • Date: 2010-09-09 18:35:25 UTC
  • mto: (1308.1.63 trunk)
  • mto: This revision was merged to the branch mainline in revision 1312.
  • Revision ID: mordred@inaugust.com-20100909183525-6l72i1glofd3qe5m
Tags: upstream-2010.08.1742
ImportĀ upstreamĀ versionĀ 2010.08.1742

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