diff options
| author | Dmitry Shulga <dmitry.shulga@mariadb.com> | 2021-06-04 12:59:24 +0700 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2021-06-17 19:30:24 +0200 |
| commit | fc71746a6a75e2b24a50a6c3afb026a667d409c6 (patch) | |
| tree | 12d5084b4e2223722946b704a9526c9ab8f32447 /mysql-test/main | |
| parent | a72098421c73a961fb0b8193d7175820d5318b65 (diff) | |
| download | mariadb-git-fc71746a6a75e2b24a50a6c3afb026a667d409c6.tar.gz | |
MDEV-16708: Fixed ths issue with handling of ERR packet received by mysqltest
on response to COM_STMT_EXECUTE
The test cases like the following one
delimiter |;
CREATE PROCEDURE SP001()
BEGIN
DECLARE C1 CURSOR FOR SELECT 1;
OPEN C1;
SELECT 1;
CLOSE C1;
CLOSE C1;
END|
delimiter ;|
--error 1326
call SP001();
are failed since processing of ERR packet was missed by mysqltest
in case it is run with --ps-protocol
Additionally, the test sp-error was changed to don't run multi-statements
since they are not supported by PS protocol
Diffstat (limited to 'mysql-test/main')
| -rw-r--r-- | mysql-test/main/sp-error.result | 4 | ||||
| -rw-r--r-- | mysql-test/main/sp-error.test | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/sp-error.result b/mysql-test/main/sp-error.result index f64735f8006..3832d63c073 100644 --- a/mysql-test/main/sp-error.result +++ b/mysql-test/main/sp-error.result @@ -2771,7 +2771,7 @@ DROP TABLE t2; DROP PROCEDURE IF EXISTS p1; DROP PROCEDURE IF EXISTS p2; -SET sql_mode = ''; +SET sql_mode = ''| CREATE PROCEDURE p1() BEGIN DECLARE var1 INTEGER DEFAULT 'string'; @@ -2782,7 +2782,7 @@ CALL p1()| Warnings: Warning 1366 Incorrect integer value: 'string' for column ``.``.`var1` at row 1 -SET sql_mode = DEFAULT; +SET sql_mode = DEFAULT| CREATE PROCEDURE p2() BEGIN DECLARE EXIT HANDLER FOR SQLWARNING SELECT 'H2'; diff --git a/mysql-test/main/sp-error.test b/mysql-test/main/sp-error.test index d2af9834823..3ce3623be18 100644 --- a/mysql-test/main/sp-error.test +++ b/mysql-test/main/sp-error.test @@ -3711,7 +3711,7 @@ DROP PROCEDURE IF EXISTS p2; delimiter |; -SET sql_mode = ''; +SET sql_mode = ''| CREATE PROCEDURE p1() BEGIN DECLARE var1 INTEGER DEFAULT 'string'; @@ -3721,7 +3721,7 @@ END| --echo CALL p1()| --echo -SET sql_mode = DEFAULT; +SET sql_mode = DEFAULT| CREATE PROCEDURE p2() BEGIN |