summaryrefslogtreecommitdiff
path: root/mysql-test/main/opt_trace_selectivity.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/opt_trace_selectivity.result')
-rw-r--r--mysql-test/main/opt_trace_selectivity.result24
1 files changed, 18 insertions, 6 deletions
diff --git a/mysql-test/main/opt_trace_selectivity.result b/mysql-test/main/opt_trace_selectivity.result
index 31eddaf5c10..86290a631fd 100644
--- a/mysql-test/main/opt_trace_selectivity.result
+++ b/mysql-test/main/opt_trace_selectivity.result
@@ -49,7 +49,9 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans'))
"index": "a",
"used_range_estimates": true,
"rows": 104,
- "cost": 104.16562,
+ "cond_check_cost": 124.96562,
+ "startup_cost": 0,
+ "cost": 124.96562,
"chosen": true
},
{
@@ -57,7 +59,9 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans'))
"index": "b",
"used_range_estimates": true,
"rows": 340,
- "cost": 340.2577963,
+ "cond_check_cost": 408.2577963,
+ "startup_cost": 0,
+ "cost": 408.2577963,
"chosen": false,
"cause": "cost"
},
@@ -66,7 +70,9 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans'))
"index": "c",
"used_range_estimates": true,
"rows": 632,
- "cost": 632.3718449,
+ "cond_check_cost": 758.7718449,
+ "startup_cost": 0,
+ "cost": 758.7718449,
"chosen": false,
"cause": "cost"
},
@@ -137,7 +143,9 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans'))
"index": "a",
"used_range_estimates": true,
"rows": 6,
- "cost": 6.127343464,
+ "cond_check_cost": 7.327343464,
+ "startup_cost": 0,
+ "cost": 7.327343464,
"chosen": true
},
{
@@ -145,7 +153,9 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans'))
"index": "b",
"used_range_estimates": true,
"rows": 232,
- "cost": 232.2156139,
+ "cond_check_cost": 278.6156139,
+ "startup_cost": 0,
+ "cost": 278.6156139,
"chosen": false,
"cause": "cost"
},
@@ -154,7 +164,9 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans'))
"index": "c",
"used_range_estimates": true,
"rows": 293,
- "cost": 293.2394392,
+ "cond_check_cost": 351.8394392,
+ "startup_cost": 0,
+ "cost": 351.8394392,
"chosen": false,
"cause": "cost"
},