diff options
Diffstat (limited to 'mysql-test/r/show_explain_ps.result')
| -rw-r--r-- | mysql-test/r/show_explain_ps.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/show_explain_ps.result b/mysql-test/r/show_explain_ps.result index f9b82c85f01..f5c487e9e44 100644 --- a/mysql-test/r/show_explain_ps.result +++ b/mysql-test/r/show_explain_ps.result @@ -10,14 +10,20 @@ NAME OBJECT_INSTANCE_BEGIN # Check out if our cond is hit. create table t0 (a int); insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +connect con1, localhost, root,,; +connection con1; +connection default; +connection con1; set @show_explain_probe_select_id=1; set debug_dbug='d,show_explain_probe_join_exec_start'; select count(*) from t0 where a < 100000; +connection default; show explain for $thr2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t0 ALL NULL NULL NULL NULL 10 Using where Warnings: Note 1003 select count(*) from t0 where a < 100000 +connection con1; count(*) 10 set debug_dbug=''; |