diff options
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/show_explain.result | 2 | ||||
-rw-r--r-- | mysql-test/t/show_explain.test | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/show_explain.result b/mysql-test/r/show_explain.result index a4097b9d65e..7c22a2c6435 100644 --- a/mysql-test/r/show_explain.result +++ b/mysql-test/r/show_explain.result @@ -735,6 +735,7 @@ grant ALL on test.* to test2@localhost; # # First, make sure that user 'test2' cannot do SHOW EXPLAIN on us # +set @show_explain_probe_select_id=1; set debug_dbug='d,show_explain_probe_join_exec_start'; select * from t0 where a < 3; show explain for $thr2; @@ -759,6 +760,7 @@ set debug_dbug=''; # Now, grant test2 a PROCESSLIST permission, and see that he's able to observe us # grant process on *.* to test2@localhost; +set @show_explain_probe_select_id=1; set debug_dbug='d,show_explain_probe_join_exec_start'; select * from t0 where a < 3; show explain for $thr2; diff --git a/mysql-test/t/show_explain.test b/mysql-test/t/show_explain.test index 5db6b96d93b..5cfc0a5e202 100644 --- a/mysql-test/t/show_explain.test +++ b/mysql-test/t/show_explain.test @@ -739,6 +739,7 @@ connection con1; --echo # --echo # First, make sure that user 'test2' cannot do SHOW EXPLAIN on us --echo # +set @show_explain_probe_select_id=1; set debug_dbug='d,show_explain_probe_join_exec_start'; send select * from t0 where a < 3; @@ -772,6 +773,7 @@ grant process on *.* to test2@localhost; connect (con2, localhost, test2,,); connection con1; +set @show_explain_probe_select_id=1; set debug_dbug='d,show_explain_probe_join_exec_start'; send select * from t0 where a < 3; |