diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2014-06-24 19:41:43 +0400 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2014-06-24 19:41:43 +0400 |
| commit | c08de06246f776c557b7795d53e2a956e156f533 (patch) | |
| tree | 6c9ed33855eeb6c418fe390deef7f62db91d6d36 /mysql-test/r/show_explain.result | |
| parent | 581b889771447f7a9f33d467f0b5ef2aa96e072b (diff) | |
| download | mariadb-git-c08de06246f776c557b7795d53e2a956e156f533.tar.gz | |
MDEV-406: ANALYZE $stmt: get ANALYZE work for subqueries
- "ANALYZE $stmt" should discard select's output, but it should still
evaluate the output columns (otherwise, subqueries in select list
are not executed)
- SHOW EXPLAIN's code practice of calling JOIN::save_explain_data()
after JOIN::exec() is disastrous for ANALYZE, because it resets
all counters after the first execution. It is stopped
= "Late" test_if_skip_sort_order() calls explicitly update their part
of the query plan.
= Also, I had to rewrite I_S optimization to actually have optimization
and execution stages.
Diffstat (limited to 'mysql-test/r/show_explain.result')
| -rw-r--r-- | mysql-test/r/show_explain.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/show_explain.result b/mysql-test/r/show_explain.result index a4d12ce05ce..3695384bac4 100644 --- a/mysql-test/r/show_explain.result +++ b/mysql-test/r/show_explain.result @@ -641,7 +641,7 @@ set debug_dbug='+d,show_explain_probe_join_exec_start'; SHOW INDEX FROM t1; show explain for $thr2; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE STATISTICS ALL NULL NULL NULL NULL NULL Skip_open_table; Scanned all databases +1 SIMPLE STATISTICS ALL NULL TABLE_SCHEMA,TABLE_NAME NULL NULL NULL Open_full_table; Scanned 0 databases Warnings: Note 1003 SHOW INDEX FROM t1 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment |