diff options
| author | Alexander Barkov <bar@mariadb.com> | 2019-03-22 14:41:36 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2019-03-22 14:41:36 +0400 |
| commit | 1c60f40868f6067be81a50198e1c72df08814adf (patch) | |
| tree | d5570ecfa377236d527d3c6a1db2a6b508c5a005 /mysql-test/main/log_slow_debug.test | |
| parent | f4484dfdbf2d78b0f357916ebd8ade024dd73c09 (diff) | |
| parent | 50a8fc52988d13a5164a1a542b9d7a85e3ecc1c1 (diff) | |
| download | mariadb-git-1c60f40868f6067be81a50198e1c72df08814adf.tar.gz | |
Merge remote-tracking branch 'origin/10.2' into 10.3
Diffstat (limited to 'mysql-test/main/log_slow_debug.test')
| -rw-r--r-- | mysql-test/main/log_slow_debug.test | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/mysql-test/main/log_slow_debug.test b/mysql-test/main/log_slow_debug.test index 35b5b93423d..7945328fee3 100644 --- a/mysql-test/main/log_slow_debug.test +++ b/mysql-test/main/log_slow_debug.test @@ -19,6 +19,14 @@ BEGIN WHERE sql_text NOT LIKE '%debug_dbug%'; END $$ +CREATE PROCEDURE show_slow_log_exclude_ps() +BEGIN + SELECT CONCAT('[slow] ', sql_text) AS sql_text + FROM mysql.slow_log + WHERE sql_text NOT LIKE '%debug_dbug%' + AND sql_text NOT IN ('Prepare','Close stmt'); +END +$$ DELIMITER ;$$ @@ -42,7 +50,7 @@ PREPARE stmt FROM 'ALTER TABLE t4 MODIFY a INT DEFAULT 1'; EXECUTE stmt; DEALLOCATE PREPARE stmt; DROP TABLE t4; -CALL show_slow_log(); +CALL show_slow_log_exclude_ps(); --echo # @@ -111,7 +119,7 @@ PREPARE stmt FROM 'ALTER TABLE t4 MODIFY a INT DEFAULT 1'; EXECUTE stmt; DEALLOCATE PREPARE stmt; DROP TABLE t4; -CALL show_slow_log(); +CALL show_slow_log_exclude_ps(); --echo # @@ -124,3 +132,4 @@ SET @@global.slow_query_log= @org_slow_query_log; SET @@global.log_output= @org_log_output; SET @@global.log_slow_admin_statements= @org_log_slow_admin_statements; DROP PROCEDURE show_slow_log; +DROP PROCEDURE show_slow_log_exclude_ps; |