diff options
| author | Vladislav Vaintroub <wlad@mariadb.com> | 2019-04-04 13:10:13 +0100 |
|---|---|---|
| committer | Vladislav Vaintroub <wlad@mariadb.com> | 2019-04-04 13:10:13 +0100 |
| commit | 6d4744cce88ac44352a9d5fb29c919c670699dea (patch) | |
| tree | 2b6544a6d6295905080cfcb851b28b785660b9e0 /mysql-test/t/sp.test | |
| parent | f2d549d8dbda1906b3e5ae0c2fa5589f2b9de662 (diff) | |
| download | mariadb-git-bb-5.5-wlad.tar.gz | |
MDEV-17610 Unexpected connection abort after certain operations from within stored procedurebb-5.5-wlad
Always set SERVER_MORE_RESULTS_EXIST when executing stored procedure statements
If statements produce a result, EOF packet needs this flag (SP ends
with an OK packet). IF statetement does not produce a result, affected rows
count are part of the final OK packet.
Diffstat (limited to 'mysql-test/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index fb9da936fdb..58bffab462d 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -9416,3 +9416,13 @@ DROP VIEW v1; DROP TABLE t1, t2; --echo # End of 5.5 test + +#MDEV-17610 +CREATE PROCEDURE sp() ALTER TABLE non_existing_table OPTIMIZE PARTITION p0; +CALL sp; +SELECT 1; +DROP PROCEDURE sp; +CREATE PROCEDURE sp() SHOW USER_STATISTICS; +CALL sp; +SELECT 1; +DROP PROCEDURE sp; |