diff options
author | davi@endora.local <> | 2008-02-08 10:21:58 -0200 |
---|---|---|
committer | davi@endora.local <> | 2008-02-08 10:21:58 -0200 |
commit | 31b22496f4ccd0326b7962e16ff5e316fef8ded7 (patch) | |
tree | 2393a53b7a4cb5bd426390b53b2e7eab540a6d03 /mysql-test/r | |
parent | 24830674e816c47dfe1bf39842a57ca65a1922da (diff) | |
parent | 24b9abf36d85c117662693043833e5f46f534f51 (diff) | |
download | mariadb-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.result | 16 |
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(); |