diff options
| author | unknown <jimw@mysql.com> | 2005-02-17 11:48:44 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-02-17 11:48:44 -0800 |
| commit | ae9166cd65ab10b21c92befa8cfe4a8e87bed0cb (patch) | |
| tree | 37fdcd56865447de09e6c301bd93bb5e7edaba27 /mysql-test/t/multi_statement.test | |
| parent | cb1b498030514366650615d60dfa7dcf55b55b81 (diff) | |
| download | mariadb-git-ae9166cd65ab10b21c92befa8cfe4a8e87bed0cb.tar.gz | |
Log each slow query in a multi-statement query to the slow query log.
(Bug #8475)
sql/sql_parse.cc:
Reset the start time before each statement before each statement in
a multi-statement query, and check whether each statement should
be logged to the slow query log independently.
mysql-test/r/multi_statement.result:
Add new results
mysql-test/t/multi_statement.test:
Add new regression test
Diffstat (limited to 'mysql-test/t/multi_statement.test')
| -rw-r--r-- | mysql-test/t/multi_statement.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/multi_statement.test b/mysql-test/t/multi_statement.test index 862f2294641..2abec332878 100644 --- a/mysql-test/t/multi_statement.test +++ b/mysql-test/t/multi_statement.test @@ -14,3 +14,18 @@ select "abcd'";'abcd'select "'abcd";'abcd' select 5'abcd' delimiter ;'abcd' select 'finish'; + +# Bug #8475: Make sure every statement that is a slow query in +# a multi-statement query gets logged as a slow query. +flush status; +delimiter ||||; +create table t1 (i int); +insert into t1 values (1); +select * from t1 where i = 1; +insert into t1 values (2),(3),(4); +select * from t1 where i = 2; +select * from t1 where i = 3|||| +show status like 'Slow_queries'|||| +drop table t1|||| + +delimiter ;|||| |