diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2012-07-10 21:23:00 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2012-07-10 21:23:00 +0400 |
| commit | 725d76e1e844b587eeeab23fb0caa670735e47b6 (patch) | |
| tree | f7340259144195962f9a718e1d1c983566ece65d /mysql-test/t | |
| parent | a931467e17c4826ce4fa473de0479953d9bbcc59 (diff) | |
| download | mariadb-git-725d76e1e844b587eeeab23fb0caa670735e47b6.tar.gz | |
MWL#182: Explain running statements: address review feedback
- switch SHOW EXPLAIN to using an INFORMATION_SCHEMA table.
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/show_explain.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/show_explain.test b/mysql-test/t/show_explain.test index c8d52ad7bb5..2e47a2e9615 100644 --- a/mysql-test/t/show_explain.test +++ b/mysql-test/t/show_explain.test @@ -818,7 +818,10 @@ connection default; let $wait_condition= select State='Sending data' from information_schema.processlist where id=$thr2; let $thr_default=`select connection_id()`; --source include/wait_condition.inc +--echo # do: send_eval show explain for $thr2; +--disable_query_log send_eval show explain for $thr2; +--enable_query_log # kill the SHOW EXPLAIN command connection con3; @@ -844,3 +847,9 @@ disconnect con2; ## thread and served together. drop table t0; + +--echo # +--echo # Check that the I_S table is invisible +--echo # +select table_name from information_schema.tables where table_schema='information_schema' and table_name like '%explain%'; + |