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 | 1a3cec909df114a034582e8a92b8d14e80b71694 (patch) | |
| tree | 37fdcd56865447de09e6c301bd93bb5e7edaba27 /mysql-test/r/multi_statement.result | |
| parent | e7dc37661e83d920fbd37dc44cbd2da17ef19b86 (diff) | |
| download | mariadb-git-1a3cec909df114a034582e8a92b8d14e80b71694.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/r/multi_statement.result')
| -rw-r--r-- | mysql-test/r/multi_statement.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/multi_statement.result b/mysql-test/r/multi_statement.result index 4451b0a355e..3a8d86bf349 100644 --- a/mysql-test/r/multi_statement.result +++ b/mysql-test/r/multi_statement.result @@ -31,3 +31,20 @@ select 5'abcd' select 'finish'; finish finish +flush status; +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|||| +i +1 +i +2 +i +3 +show status like 'Slow_queries'|||| +Variable_name Value +Slow_queries 2 +drop table t1|||| |