diff options
| author | Vladislav Vaintroub <wlad@mariadb.com> | 2019-09-03 11:23:12 +0200 |
|---|---|---|
| committer | Vladislav Vaintroub <wlad@mariadb.com> | 2019-09-03 11:23:12 +0200 |
| commit | edb6e2b951e168d809d7c0c9a11befdc391760fb (patch) | |
| tree | 3cca033bc1f56298dffdca0a6f034452b3e9d1a2 | |
| parent | 4ba20e0a14b9134a7e71aa4b592522967456317c (diff) | |
| download | mariadb-git-edb6e2b951e168d809d7c0c9a11befdc391760fb.tar.gz | |
MDEV-17610 - fix result, for the case when test runs with userstat=on
| -rw-r--r-- | mysql-test/r/sp.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/sp.test | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 1704e7cd214..b5f8b017546 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -7644,7 +7644,7 @@ SELECT 1; 1 1 DROP PROCEDURE sp; -CREATE PROCEDURE sp() SHOW USER_STATISTICS; +CREATE PROCEDURE sp() SET STATEMENT SQL_SELECT_LIMIT=0 FOR SHOW USER_STATISTICS; CALL sp; User Total_connections Concurrent_connections Connected_time Busy_time Cpu_time Bytes_received Bytes_sent Binlog_bytes_written Rows_read Rows_sent Rows_deleted Rows_inserted Rows_updated Select_commands Update_commands Other_commands Commit_transactions Rollback_transactions Denied_connections Lost_connections Access_denied Empty_queries Total_ssl_connections Max_statement_time_exceeded SELECT 1; diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index a2a40f87ef0..fa4387a9650 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -9078,7 +9078,7 @@ CREATE PROCEDURE sp() ALTER TABLE non_existing_table OPTIMIZE PARTITION p0; CALL sp; SELECT 1; DROP PROCEDURE sp; -CREATE PROCEDURE sp() SHOW USER_STATISTICS; +CREATE PROCEDURE sp() SET STATEMENT SQL_SELECT_LIMIT=0 FOR SHOW USER_STATISTICS; CALL sp; SELECT 1; DROP PROCEDURE sp; |