← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/user_var.result

  • Committer: Monty Taylor
  • Date: 2010-12-26 03:00:37 UTC
  • mto: This revision was merged to the branch mainline in revision 2038.
  • Revision ID: mordred@inaugust.com-20101226030037-2qcfxg5ryamekd56
Cleaned through ha0ha.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/user_var.result
172
172
) ENGINE=DEFAULT COLLATE = utf8_general_ci
173
173
drop table t1;
174
174
set @first_var= cast(NULL as integer);
175
 
create table t1 select @first_var;
176
 
show create table t1;
177
 
Table   Create Table
178
 
t1      CREATE TABLE `t1` (
179
 
  `@first_var` BIGINT DEFAULT NULL
180
 
) ENGINE=DEFAULT COLLATE = utf8_general_ci
181
 
drop table t1;
 
175
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'integer)' at line 1
182
176
set @first_var= NULL;
183
177
create table t1 select @first_var;
184
178
show create table t1;
185
179
Table   Create Table
186
180
t1      CREATE TABLE `t1` (
187
 
  `@first_var` BIGINT DEFAULT NULL
 
181
  `@first_var` BLOB
188
182
) ENGINE=DEFAULT COLLATE = utf8_general_ci
189
183
drop table t1;
190
184
set @first_var= concat(NULL);