summaryrefslogtreecommitdiff
path: root/mysql-test/t/mysqlslap.test
diff options
context:
space:
mode:
authorgshchepa/uchum@gleb.loc <>2007-09-17 21:39:07 +0500
committergshchepa/uchum@gleb.loc <>2007-09-17 21:39:07 +0500
commit2a5d951552c190a0e9b56122d642dff8f92a0c1f (patch)
treeef98302fe606b670100b6372efdd2551469facb3 /mysql-test/t/mysqlslap.test
parent0b7e4b4ddebf9581c73efee2c530be2a30983e8b (diff)
downloadmariadb-git-2a5d951552c190a0e9b56122d642dff8f92a0c1f.tar.gz
Fixed bug #29985.
Multiple-result processing is required during the execution of CALL statements for stored procedures, however the mysqlslap client lacked that processing.
Diffstat (limited to 'mysql-test/t/mysqlslap.test')
-rw-r--r--mysql-test/t/mysqlslap.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/mysqlslap.test b/mysql-test/t/mysqlslap.test
index dffa226d101..92d31ec9082 100644
--- a/mysql-test/t/mysqlslap.test
+++ b/mysql-test/t/mysqlslap.test
@@ -40,3 +40,14 @@
--exec $MYSQL_SLAP --only-print --delimiter=";" --query="select * from t1;select * from t2" --create="CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); INSERT INTO t1 VALUES (1, 'This is a test'); insert into t2 values ('test', 'test2')" --engine="heap,myisam" --post-query="SHOW TABLES" --pre-query="SHOW TABLES" --number-of-queries=6 --commit=1;
--exec $MYSQL_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --detach=2
+
+--echo #
+--echo # Bug #29985: mysqlslap -- improper handling of resultsets in SPROCs
+--echo #
+
+--disable_warnings
+DROP PROCEDURE IF EXISTS p1;
+--enable_warnings
+CREATE PROCEDURE p1() SELECT 1;
+
+--exec $MYSQL_SLAP --create-schema=test --delimiter=";" --query="CALL p1; SELECT 1;" --silent 2>&1