diff options
author | Varun Gupta <varun.gupta@mariadb.com> | 2019-02-18 17:11:20 +0530 |
---|---|---|
committer | Varun Gupta <varun.gupta@mariadb.com> | 2019-02-18 17:11:20 +0530 |
commit | 9cb55143ac78c8c0dc4781883bd24ee9284dbbce (patch) | |
tree | af18e55a055186fd988f536cf349484a6c3a2e26 /mysql-test/main/opt_trace_security.result | |
parent | 7d2138d4a4788b8979c13e995d357097b0372ae2 (diff) | |
download | mariadb-git-9cb55143ac78c8c0dc4781883bd24ee9284dbbce.tar.gz |
Minor cleanup in the optimizer trace code.
More test coverage added for the optimizer trace.
Diffstat (limited to 'mysql-test/main/opt_trace_security.result')
-rw-r--r-- | mysql-test/main/opt_trace_security.result | 18 |
1 files changed, 4 insertions, 14 deletions
diff --git a/mysql-test/main/opt_trace_security.result b/mysql-test/main/opt_trace_security.result index 2d66a0a9576..9f5bacd6aa7 100644 --- a/mysql-test/main/opt_trace_security.result +++ b/mysql-test/main/opt_trace_security.result @@ -55,7 +55,7 @@ select * from db1.t1 { "select_id": 1, "steps": [ { - "expanded_query": "select `db1`.`t1`.`a` AS `a` from `t1`" + "expanded_query": "select db1.t1.a AS a from t1" } ] } @@ -86,11 +86,6 @@ select * from db1.t1 { ] }, { - "execution_plan_for_potential_materialization": { - "steps": [] - } - }, - { "considered_execution_plans": [ { "plan_prefix": [], @@ -157,7 +152,7 @@ select * from db1.v1 { "view": { "table": "v1", "select_id": 2, - "merged": true + "algorithm": "merged" } }, { @@ -165,13 +160,13 @@ select * from db1.v1 { "select_id": 2, "steps": [ { - "expanded_query": "/* select#2 */ select `db1`.`t1`.`a` AS `a` from `t1`" + "expanded_query": "/* select#2 */ select db1.t1.a AS a from t1" } ] } }, { - "expanded_query": "/* select#1 */ select `db1`.`t1`.`a` AS `a` from `v1`" + "expanded_query": "/* select#1 */ select db1.t1.a AS a from v1" } ] } @@ -202,11 +197,6 @@ select * from db1.v1 { ] }, { - "execution_plan_for_potential_materialization": { - "steps": [] - } - }, - { "considered_execution_plans": [ { "plan_prefix": [], |