~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/case.result

  • Committer: Vladimir Kolesnikov
  • Date: 2009-03-25 09:18:25 UTC
  • mto: (968.2.17 mordred)
  • mto: This revision was merged to the branch mainline in revision 971.
  • Revision ID: vladimir@primebase.org-20090325091825-gnw5opo5xtprd6k0
test generalizations

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