← 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:24:24 UTC
  • mfrom: (2008.2.5 integer-refactor)
  • Revision ID: brian@tangent.org-20101220192424-iyccxsagvuw43kaz
A rather large and tasty cleanup of issues around ints, and one additional
fix for alter table.

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);