diff options
Diffstat (limited to 'mysql-test/main/opt_trace_security.result')
-rw-r--r-- | mysql-test/main/opt_trace_security.result | 68 |
1 files changed, 47 insertions, 21 deletions
diff --git a/mysql-test/main/opt_trace_security.result b/mysql-test/main/opt_trace_security.result index 48ca5c5e..cf5dcf5d 100644 --- a/mysql-test/main/opt_trace_security.result +++ b/mysql-test/main/opt_trace_security.result @@ -80,7 +80,8 @@ select * from db1.t1 { "table": "t1", "table_scan": { "rows": 3, - "cost": 2.005126953 + "read_cost": 0.010408815, + "read_and_compare_cost": 0.010504815 } } ] @@ -88,23 +89,30 @@ select * from db1.t1 { { "considered_execution_plans": [ { - "plan_prefix": [], + "plan_prefix": "", "get_costs_for_tables": [ { "best_access_path": { "table": "t1", + "plan_details": { + "record_count": 1 + }, "considered_access_paths": [ { "access_type": "scan", - "resulting_rows": 3, - "cost": 2.005126953, + "rows": 3, + "rows_after_filter": 3, + "rows_out": 3, + "cost": 0.010504815, + "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", - "records": 3, - "cost": 2.005126953, + "rows_read": 3, + "rows_out": 3, + "cost": 0.010504815, "uses_join_buffering": false } } @@ -112,15 +120,17 @@ select * from db1.t1 { ] }, { - "plan_prefix": [], + "plan_prefix": "", "table": "t1", "rows_for_plan": 3, - "cost_for_plan": 2.605126953 + "cost_for_plan": 0.010504815 } ] }, { - "best_join_order": ["t1"] + "best_join_order": ["t1"], + "rows": 3, + "cost": 0.010504815 }, { "attaching_conditions_to_tables": { @@ -128,10 +138,13 @@ select * from db1.t1 { "attached_conditions_summary": [ { "table": "t1", - "attached": null + "attached_condition": null } ] } + }, + { + "make_join_readinfo": [] } ] } @@ -184,7 +197,7 @@ select * from db1.v1 { } }, { - "expanded_query": "/* select#1 */ select db1.t1.a AS a from v1" + "expanded_query": "/* select#1 */ select v1.a AS a from v1" } ] } @@ -209,7 +222,8 @@ select * from db1.v1 { "table": "t1", "table_scan": { "rows": 3, - "cost": 2.005126953 + "read_cost": 0.010408815, + "read_and_compare_cost": 0.010504815 } } ] @@ -217,23 +231,30 @@ select * from db1.v1 { { "considered_execution_plans": [ { - "plan_prefix": [], + "plan_prefix": "", "get_costs_for_tables": [ { "best_access_path": { "table": "t1", + "plan_details": { + "record_count": 1 + }, "considered_access_paths": [ { "access_type": "scan", - "resulting_rows": 3, - "cost": 2.005126953, + "rows": 3, + "rows_after_filter": 3, + "rows_out": 3, + "cost": 0.010504815, + "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", - "records": 3, - "cost": 2.005126953, + "rows_read": 3, + "rows_out": 3, + "cost": 0.010504815, "uses_join_buffering": false } } @@ -241,15 +262,17 @@ select * from db1.v1 { ] }, { - "plan_prefix": [], + "plan_prefix": "", "table": "t1", "rows_for_plan": 3, - "cost_for_plan": 2.605126953 + "cost_for_plan": 0.010504815 } ] }, { - "best_join_order": ["t1"] + "best_join_order": ["t1"], + "rows": 3, + "cost": 0.010504815 }, { "attaching_conditions_to_tables": { @@ -257,10 +280,13 @@ select * from db1.v1 { "attached_conditions_summary": [ { "table": "t1", - "attached": null + "attached_condition": null } ] } + }, + { + "make_join_readinfo": [] } ] } |