summaryrefslogtreecommitdiff
path: root/mysql-test/r/ps.result
diff options
context:
space:
mode:
authorunknown <davi@endora.local>2008-02-08 10:21:58 -0200
committerunknown <davi@endora.local>2008-02-08 10:21:58 -0200
commit57c180c1037de9a96488228aa99382aa7a1927c1 (patch)
tree2393a53b7a4cb5bd426390b53b2e7eab540a6d03 /mysql-test/r/ps.result
parentd9831ae5329d6916667ee9beb885c3e4c35c4018 (diff)
parent7d98c21cdf4235ebe0d4abc52ae71fa4502e1524 (diff)
downloadmariadb-git-57c180c1037de9a96488228aa99382aa7a1927c1.tar.gz
Merge mysql.com:/Users/davi/mysql/mysql-5.0-runtime
into mysql.com:/Users/davi/mysql/mysql-5.1-runtime mysql-test/r/ps.result: Auto merged mysql-test/t/ps.test: Auto merged sql/item.cc: Auto merged mysql-test/extra/binlog_tests/binlog.test: Manual merge. mysql-test/suite/binlog/r/binlog_stm_binlog.result: Manual merge.
Diffstat (limited to 'mysql-test/r/ps.result')
-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();