summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authordavi@endora.local <>2008-02-08 10:21:58 -0200
committerdavi@endora.local <>2008-02-08 10:21:58 -0200
commit31b22496f4ccd0326b7962e16ff5e316fef8ded7 (patch)
tree2393a53b7a4cb5bd426390b53b2e7eab540a6d03 /mysql-test/r
parent24830674e816c47dfe1bf39842a57ca65a1922da (diff)
parent24b9abf36d85c117662693043833e5f46f534f51 (diff)
downloadmariadb-git-31b22496f4ccd0326b7962e16ff5e316fef8ded7.tar.gz
Merge mysql.com:/Users/davi/mysql/mysql-5.0-runtime
into mysql.com:/Users/davi/mysql/mysql-5.1-runtime
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/ps.result16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result
index a6b07bfc127..75d3f79f4b0 100644
--- a/mysql-test/r/ps.result
+++ b/mysql-test/r/ps.result
@@ -1717,6 +1717,22 @@ t1 CREATE TABLE `t1` (
`?` decimal(2,1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
drop table t1;
+drop table if exists t1;
+create table t1 (a bigint unsigned, b bigint(20) unsigned);
+prepare stmt from "insert into t1 values (?,?)";
+set @a= 9999999999999999;
+set @b= 14632475938453979136;
+insert into t1 values (@a, @b);
+select * from t1 where a = @a and b = @b;
+a b
+9999999999999999 14632475938453979136
+execute stmt using @a, @b;
+select * from t1 where a = @a and b = @b;
+a b
+9999999999999999 14632475938453979136
+9999999999999999 14632475938453979136
+deallocate prepare stmt;
+drop table t1;
End of 5.0 tests.
create procedure proc_1() reset query cache;
call proc_1();