diff options
| author | ramil/ram@ramil.myoffice.izhnet.ru <> | 2007-07-09 10:20:45 +0500 |
|---|---|---|
| committer | ramil/ram@ramil.myoffice.izhnet.ru <> | 2007-07-09 10:20:45 +0500 |
| commit | ede22768a90fc4df628281ce71d9ff14fbb0ca49 (patch) | |
| tree | 41a23d26a70ceb80f7f5914e7db67b0d14905b3a /mysql-test/t/show_check.test | |
| parent | f38158f401e1ba12dfc63d56fd1c75e3c689d44d (diff) | |
| parent | fca06fbc68215fec57834d39bff2f243f1b519cb (diff) | |
| download | mariadb-git-ede22768a90fc4df628281ce71d9ff14fbb0ca49.tar.gz | |
Merge mysql.com:/home/ram/work/b28808/b28808.5.0
into mysql.com:/home/ram/work/b28808/b28808.5.1
Diffstat (limited to 'mysql-test/t/show_check.test')
| -rw-r--r-- | mysql-test/t/show_check.test | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index 341c9039390..6e848695b80 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -761,7 +761,23 @@ DROP VIEW v1; DROP PROCEDURE p1; DROP FUNCTION f1; ---echo End of 5.0 tests. +# +# Bug #28808: log_queries_not_using_indexes variable dynamic change is ignored +# +flush status; +show variables like "log_queries_not_using_indexes"; +select 1 from information_schema.tables limit 1; +show status like 'slow_queries'; +set global log_queries_not_using_indexes=OFF; +show variables like "log_queries_not_using_indexes"; +select 1 from information_schema.tables limit 1; +show status like 'slow_queries'; +set global log_queries_not_using_indexes=ON; +show variables like "log_queries_not_using_indexes"; +select 1 from information_schema.tables limit 1; +show status like 'slow_queries'; + +--echo End of 5.0 tests --disable_result_log SHOW AUTHORS; |