summaryrefslogtreecommitdiff
path: root/mysql-test/r/ps.result
diff options
context:
space:
mode:
authorunknown <konstantin@mysql.com>2005-04-13 12:36:15 -0700
committerunknown <konstantin@mysql.com>2005-04-13 12:36:15 -0700
commit67d8d63d95cdca4de5123f3b3a201279f0082310 (patch)
tree8c0ecca8b20dcb5d5111a5336d1b34f5e534ab85 /mysql-test/r/ps.result
parent6f0f723175a87603dde798af3a7957acdd979058 (diff)
downloadmariadb-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.result28
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|