← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/t/user_var.test

  • Committer: Brian Aker
  • Date: 2008-07-07 14:25:25 UTC
  • mto: (77.1.25 codestyle)
  • mto: This revision was merged to the branch mainline in revision 82.
  • Revision ID: brian@tangent.org-20080707142525-xzy2nl3ie2ebwfln
LL() cleanup

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/user_var.test
172
172
drop table t1;
173
173
 
174
174
#
175
 
# Bug #7498 User variable SET saves SIGNED BIGINT as BIGINT
 
175
# Bug #7498 User variable SET saves SIGNED BIGINT as UNSIGNED BIGINT
176
176
#
177
177
 
178
178
# First part, set user var to large number and select it
182
182
# Second part, set user var from large number in table
183
183
# then select it
184
184
CREATE TABLE `bigfailure` (
185
 
  `afield` BIGINT NOT NULL
 
185
  `afield` BIGINT UNSIGNED NOT NULL
186
186
);
187
187
INSERT INTO `bigfailure` VALUES (18446744071710965857);
188
188
SELECT * FROM bigfailure;