diff options
author | unknown <konstantin@mysql.com> | 2005-04-13 12:36:15 -0700 |
---|---|---|
committer | unknown <konstantin@mysql.com> | 2005-04-13 12:36:15 -0700 |
commit | 67d8d63d95cdca4de5123f3b3a201279f0082310 (patch) | |
tree | 8c0ecca8b20dcb5d5111a5336d1b34f5e534ab85 /mysql-test/r/ps.result | |
parent | 6f0f723175a87603dde798af3a7957acdd979058 (diff) | |
download | mariadb-git-67d8d63d95cdca4de5123f3b3a201279f0082310.tar.gz |
Allow SQLCOM_CALL in prepared mode.
mysql-test/r/ps.result:
Test results: adding tests for CALL statement in prepared mode.
mysql-test/t/ps.test:
Adding tests for CALL statement in prepared mode.
Diffstat (limited to 'mysql-test/r/ps.result')
-rw-r--r-- | mysql-test/r/ps.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index 94972ea8721..bbd95da2f82 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -542,3 +542,31 @@ execute my_stmt; COUNT(*) 37 deallocate prepare my_stmt; +drop procedure if exists p1| +drop table if exists t1| +create table t1 (id int)| +insert into t1 values(1)| +create procedure p1(a int, b int) +begin +declare c int; +select max(id)+1 into c from t1; +insert into t1 select a+b; +insert into t1 select a-b; +insert into t1 select a-c; +end| +set @a= 3, @b= 4| +prepare stmt from "call p1(?, ?)"| +execute stmt using @a, @b| +execute stmt using @a, @b| +select * from t1| +id +1 +7 +-1 +1 +7 +-1 +-5 +deallocate prepare stmt| +drop procedure p1| +drop table t1| |