summaryrefslogtreecommitdiff
path: root/mysql-test/main/opt_trace_security.result
diff options
context:
space:
mode:
authorVarun Gupta <varun.gupta@mariadb.com>2019-02-18 17:11:20 +0530
committerVarun Gupta <varun.gupta@mariadb.com>2019-02-18 17:11:20 +0530
commit9cb55143ac78c8c0dc4781883bd24ee9284dbbce (patch)
treeaf18e55a055186fd988f536cf349484a6c3a2e26 /mysql-test/main/opt_trace_security.result
parent7d2138d4a4788b8979c13e995d357097b0372ae2 (diff)
downloadmariadb-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.result18
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": [],