diff options
Diffstat (limited to '')
| -rw-r--r-- | mysql-test/main/show_explain.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/show_explain.result b/mysql-test/main/show_explain.result index 22ac7de6..7d41a58e 100644 --- a/mysql-test/main/show_explain.result +++ b/mysql-test/main/show_explain.result @@ -1,6 +1,6 @@ drop table if exists t0, t1, t2, t3, t4; drop view if exists v1; -SET @old_debug= @@session.debug; +SET @old_debug= @@session.debug_dbug; set debug_sync='RESET'; create table t0 (a int); insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); @@ -23,7 +23,7 @@ explain for connection (select max(a) from t0); ERROR HY000: You may only use constant expressions in this statement connect con1, localhost, root,,; connection con1; -SET @old_debug= @@session.debug; +SET @old_debug= @@session.debug_dbug; connection default; show explain for $thr2; ERROR HY000: Target is not executing an operation with a query plan @@ -1267,7 +1267,7 @@ explain SELECT b AS field1, b AS field2 FROM t1, t2, t3 WHERE d = b ORDER BY field1, field2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 system NULL NULL NULL NULL 1 -1 SIMPLE t1 range b b 6 NULL 107 Using where; Using index +1 SIMPLE t1 index b b 6 NULL 107 Using where; Using index 1 SIMPLE t3 ref PRIMARY PRIMARY 5 test.t1.b 1 Using index set @show_explain_probe_select_id=1; SET debug_dbug='+d,show_explain_probe_do_select'; @@ -1276,7 +1276,7 @@ connection default; show explain for $thr2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 system NULL NULL NULL NULL 1 -1 SIMPLE t1 range b b 6 NULL 107 Using where; Using index +1 SIMPLE t1 index b b 6 NULL 107 Using where; Using index 1 SIMPLE t3 ref PRIMARY PRIMARY 5 test.t1.b 1 Using index Warnings: Note 1003 SELECT b AS field1, b AS field2 FROM t1, t2, t3 WHERE d = b ORDER BY field1, field2 |