← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/user_var.result

  • Committer: Brian Aker
  • Date: 2010-12-20 19:20:57 UTC
  • mto: This revision was merged to the branch mainline in revision 2016.
  • Revision ID: brian@tangent.org-20101220192057-1ch4b9uo008d8rje
Merge in additional fixes for sign, plus alter table, plus TIME on
processlist.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/user_var.result
203
203
@a
204
204
18446744071710965857
205
205
CREATE TABLE `bigfailure` (
206
 
`afield` BIGINT NOT NULL
 
206
`afield` BIGINT UNSIGNED NOT NULL
207
207
);
208
208
INSERT INTO `bigfailure` VALUES (18446744071710965857);
209
209
SELECT * FROM bigfailure;
226
226
SET @a := (SELECT afield FROM bigfailure);
227
227
SELECT @a;
228
228
@a
229
 
-1998585759
 
229
18446744071710965857
230
230
SET @a := (select afield from (SELECT afield FROM bigfailure) as b);
231
231
SELECT @a;
232
232
@a
233
 
-1998585759
 
233
18446744071710965857
234
234
SET @a := (select * from bigfailure where afield = (SELECT afield FROM bigfailure));
235
235
SELECT @a;
236
236
@a
237
 
-1998585759
 
237
18446744071710965857
238
238
drop table bigfailure;
239
239
create table t1(f1 int, f2 int);
240
240
insert into t1 values (1,2),(2,3),(3,1);