Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.7(EOL), 10.8(EOL)
-
None
Description
The recently added optimizer_trace option fails to produce any output for two EXPLAIN statements in 10.6, 10.7, 10.8. In 10.4 and 10.5, it works fine. The following change will ensure that the optimizer trace output is generated.
diff --git a/mysql-test/main/opt_trace.test b/mysql-test/main/opt_trace.test
|
index 2077422fa1b..a516c2891a2 100644
|
--- a/mysql-test/main/opt_trace.test
|
+++ b/mysql-test/main/opt_trace.test
|
@@ -48,12 +48,14 @@ create view v1 as select a from t1 group by b;
|
create view v2 as select a from t2;
|
|
--echo # Mergeable view
|
+--disable_ps_protocol
|
--optimizer_trace
|
explain select * from v2 ;
|
|
--echo # Non-Mergeable view
|
--optimizer_trace
|
explain select * from v1 ;
|
+--enable_ps_protocol
|
drop table t1,t2;
|
drop view v1,v2;
|
|