diff options
-rw-r--r-- | mysql-test/main/analyze_format_json.result | 4 | ||||
-rw-r--r-- | mysql-test/main/analyze_stmt_orderby.result | 2 | ||||
-rw-r--r-- | mysql-test/main/derived_cond_pushdown.result | 10 | ||||
-rw-r--r-- | mysql-test/main/join_cache.result | 2 | ||||
-rw-r--r-- | mysql-test/main/opt_trace.result | 1058 | ||||
-rw-r--r-- | mysql-test/main/opt_trace.test | 9 | ||||
-rw-r--r-- | mysql-test/main/opt_trace_index_merge.result | 122 | ||||
-rw-r--r-- | mysql-test/main/opt_trace_index_merge_innodb.result | 22 | ||||
-rw-r--r-- | mysql-test/main/opt_trace_security.result | 16 | ||||
-rw-r--r-- | mysql-test/main/opt_trace_ucs2.result | 2 | ||||
-rw-r--r-- | mysql-test/main/range.result | 8 | ||||
-rw-r--r-- | mysql-test/main/range_mrr_icp.result | 4 | ||||
-rw-r--r-- | mysql-test/main/rowid_filter.result | 156 | ||||
-rw-r--r-- | mysql-test/main/rowid_filter_innodb.result | 150 | ||||
-rw-r--r-- | sql/my_json_writer.cc | 2 |
15 files changed, 837 insertions, 730 deletions
diff --git a/mysql-test/main/analyze_format_json.result b/mysql-test/main/analyze_format_json.result index f45433a1572..fc643d1a8af 100644 --- a/mysql-test/main/analyze_format_json.result +++ b/mysql-test/main/analyze_format_json.result @@ -192,7 +192,7 @@ ANALYZE "buffer_size": "1Kb", "join_type": "BNL", "attached_condition": "tbl1.c > tbl2.c", - "r_filtered": 15.833 + "r_filtered": 15.83333333 } } } @@ -421,7 +421,7 @@ ANALYZE "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 100, - "r_filtered": 98.135 + "r_filtered": 98.13542689 } } } diff --git a/mysql-test/main/analyze_stmt_orderby.result b/mysql-test/main/analyze_stmt_orderby.result index 47bc856ba53..11736c47a49 100644 --- a/mysql-test/main/analyze_stmt_orderby.result +++ b/mysql-test/main/analyze_stmt_orderby.result @@ -516,7 +516,7 @@ ANALYZE "buffer_size": "119", "join_type": "BNL", "attached_condition": "t5.a = t6.a", - "r_filtered": 21.429 + "r_filtered": 21.42857143 } } } diff --git a/mysql-test/main/derived_cond_pushdown.result b/mysql-test/main/derived_cond_pushdown.result index 68b54d0729a..6c51c28372b 100644 --- a/mysql-test/main/derived_cond_pushdown.result +++ b/mysql-test/main/derived_cond_pushdown.result @@ -15165,7 +15165,7 @@ EXPLAIN "access_type": "ALL", "possible_keys": ["idx_b"], "rows": 12, - "filtered": 83.333, + "filtered": 83.33333588, "attached_condition": "t1.b <= 5 and t1.a is not null" }, "table": { @@ -15438,7 +15438,7 @@ EXPLAIN "access_type": "ALL", "possible_keys": ["idx_b"], "rows": 12, - "filtered": 83.333, + "filtered": 83.33333588, "attached_condition": "t3.b <= 15 and t3.a is not null and t3.c is not null" }, "table": { @@ -15590,7 +15590,7 @@ EXPLAIN "access_type": "ALL", "possible_keys": ["idx_b"], "rows": 12, - "filtered": 83.333, + "filtered": 83.33333588, "attached_condition": "t3.b <= 15 and t3.a is not null and t3.c is not null" }, "table": { @@ -15821,7 +15821,7 @@ EXPLAIN "table_name": "t2", "access_type": "ALL", "rows": 90, - "filtered": 63.281, + "filtered": 63.28125, "attached_condition": "t2.b < 40 and t2.a is not null" }, "table": { @@ -16317,7 +16317,7 @@ EXPLAIN "table_name": "t2", "access_type": "ALL", "rows": 90, - "filtered": 63.281, + "filtered": 63.28125, "attached_condition": "t2.b < 40 and t2.a is not null" }, "table": { diff --git a/mysql-test/main/join_cache.result b/mysql-test/main/join_cache.result index dac621f2564..60cdbaf56c5 100644 --- a/mysql-test/main/join_cache.result +++ b/mysql-test/main/join_cache.result @@ -6129,7 +6129,7 @@ EXPLAIN "key_length": "10", "used_key_parts": ["kp1", "kp2"], "rows": 836, - "filtered": 76.434, + "filtered": 76.43428802, "index_condition": "b.kp2 <= 10", "attached_condition": "b.kp2 <= 10 and b.col1 + 1 < 33333" }, diff --git a/mysql-test/main/opt_trace.result b/mysql-test/main/opt_trace.result index 5bbb257b3b4..65caf3cd2ec 100644 --- a/mysql-test/main/opt_trace.result +++ b/mysql-test/main/opt_trace.result @@ -117,7 +117,7 @@ select * from v1 { "table": "t1", "table_scan": { "rows": 2, - "cost": 2.0044 + "cost": 2.004394531 } } ] @@ -132,19 +132,19 @@ select * from v1 { { "access_type": "scan", "resulting_rows": 1, - "cost": 2.2044, + "cost": 2.204394531, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 1, - "cost": 2.2044, + "cost": 2.204394531, "uses_join_buffering": false } }, "rows_for_plan": 1, - "cost_for_plan": 2.4044, + "cost_for_plan": 2.404394531, "estimated_join_cardinality": 1 } ] @@ -262,7 +262,7 @@ select * from (select * from t1 where t1.a=1)q { "table": "t1", "table_scan": { "rows": 2, - "cost": 2.0044 + "cost": 2.004394531 } } ] @@ -277,19 +277,19 @@ select * from (select * from t1 where t1.a=1)q { { "access_type": "scan", "resulting_rows": 1, - "cost": 2.2044, + "cost": 2.204394531, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 1, - "cost": 2.2044, + "cost": 2.204394531, "uses_join_buffering": false } }, "rows_for_plan": 1, - "cost_for_plan": 2.4044, + "cost_for_plan": 2.404394531, "estimated_join_cardinality": 1 } ] @@ -412,7 +412,7 @@ select * from v2 { "table": "t1", "table_scan": { "rows": 2, - "cost": 2.0044 + "cost": 2.004394531 } } ] @@ -427,7 +427,7 @@ select * from v2 { { "access_type": "scan", "resulting_rows": 1, - "cost": 2.2044, + "cost": 2.204394531, "chosen": true, "use_tmp_table": true } @@ -435,12 +435,12 @@ select * from v2 { "chosen_access_method": { "type": "scan", "records": 1, - "cost": 2.2044, + "cost": 2.204394531, "uses_join_buffering": false } }, "rows_for_plan": 1, - "cost_for_plan": 2.4044, + "cost_for_plan": 2.404394531, "estimated_join_cardinality": 1 } ] @@ -618,7 +618,7 @@ explain select * from v2 { "table": "t2", "table_scan": { "rows": 10, - "cost": 2.022 + "cost": 2.021972656 } } ] @@ -633,19 +633,19 @@ explain select * from v2 { { "access_type": "scan", "resulting_rows": 10, - "cost": 2.022, + "cost": 2.021972656, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 10, - "cost": 2.022, + "cost": 2.021972656, "uses_join_buffering": false } }, "rows_for_plan": 10, - "cost_for_plan": 4.022, + "cost_for_plan": 4.021972656, "estimated_join_cardinality": 10 } ] @@ -736,7 +736,7 @@ explain select * from v1 { "table": "t1", "table_scan": { "rows": 10, - "cost": 2.022 + "cost": 2.021972656 } } ] @@ -751,7 +751,7 @@ explain select * from v1 { { "access_type": "scan", "resulting_rows": 10, - "cost": 2.022, + "cost": 2.021972656, "chosen": true, "use_tmp_table": true } @@ -759,12 +759,12 @@ explain select * from v1 { "chosen_access_method": { "type": "scan", "records": 10, - "cost": 2.022, + "cost": 2.021972656, "uses_join_buffering": false } }, "rows_for_plan": 10, - "cost_for_plan": 4.022, + "cost_for_plan": 4.021972656, "estimated_join_cardinality": 10 } ] @@ -967,14 +967,14 @@ explain select * from t1,t2 where t1.a=t2.b+2 and t2.a= t1.b { "table": "t1", "table_scan": { "rows": 100, - "cost": 2.3174 + "cost": 2.317382812 } }, { "table": "t2", "table_scan": { "rows": 100, - "cost": 2.3174 + "cost": 2.317382812 } } ] @@ -989,19 +989,19 @@ explain select * from t1,t2 where t1.a=t2.b+2 and t2.a= t1.b { { "access_type": "scan", "resulting_rows": 100, - "cost": 2.3174, + "cost": 2.317382812, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 100, - "cost": 2.3174, + "cost": 2.317382812, "uses_join_buffering": false } }, "rows_for_plan": 100, - "cost_for_plan": 22.317, + "cost_for_plan": 22.31738281, "rest_of_plan": [ { "plan_prefix": ["t1"], @@ -1014,25 +1014,25 @@ explain select * from t1,t2 where t1.a=t2.b+2 and t2.a= t1.b { "used_range_estimates": false, "cause": "not available", "rows": 1, - "cost": 200.06, + "cost": 200.0585794, "chosen": true }, { "access_type": "scan", "resulting_rows": 100, - "cost": 2.3174, + "cost": 2.317382812, "chosen": false } ], "chosen_access_method": { "type": "ref", "records": 1, - "cost": 200.06, + "cost": 200.0585794, "uses_join_buffering": false } }, "rows_for_plan": 100, - "cost_for_plan": 242.38, + "cost_for_plan": 242.3759623, "estimated_join_cardinality": 100 } ] @@ -1045,19 +1045,19 @@ explain select * from t1,t2 where t1.a=t2.b+2 and t2.a= t1.b { { "access_type": "scan", "resulting_rows": 100, - "cost": 2.3174, + "cost": 2.317382812, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 100, - "cost": 2.3174, + "cost": 2.317382812, "uses_join_buffering": false } }, "rows_for_plan": 100, - "cost_for_plan": 22.317, + "cost_for_plan": 22.31738281, "rest_of_plan": [ { "plan_prefix": ["t2"], @@ -1070,25 +1070,25 @@ explain select * from t1,t2 where t1.a=t2.b+2 and t2.a= t1.b { "used_range_estimates": false, "cause": "not available", "rows": 1, - "cost": 200.06, + "cost": 200.0585794, "chosen": true }, { "access_type": "scan", "resulting_rows": 100, - "cost": 2.3174, + "cost": 2.317382812, "chosen": false } ], "chosen_access_method": { "type": "ref", "records": 1, - "cost": 200.06, + "cost": 200.0585794, "uses_join_buffering": false } }, "rows_for_plan": 100, - "cost_for_plan": 242.38, + "cost_for_plan": 242.3759623, "pruned_by_cost": true } ] @@ -1172,7 +1172,7 @@ EXPLAIN SELECT DISTINCT a FROM t1 { "range_analysis": { "table_scan": { "rows": 65536, - "cost": 13255 + "cost": 13255.2 }, "potential_range_indexes": [ { @@ -1188,7 +1188,7 @@ EXPLAIN SELECT DISTINCT a FROM t1 { ], "best_covering_index_scan": { "index": "a", - "cost": 13377, + "cost": 13377.39141, "chosen": false, "cause": "cost" }, @@ -1361,7 +1361,7 @@ EXPLAIN SELECT MIN(d) FROM t1 where b=2 and c=3 group by a { "range_analysis": { "table_scan": { "rows": 7, - "cost": 5.4291 + "cost": 5.429052734 }, "potential_range_indexes": [ { @@ -1372,7 +1372,7 @@ EXPLAIN SELECT MIN(d) FROM t1 where b=2 and c=3 group by a { ], "best_covering_index_scan": { "index": "a", - "cost": 2.4092, + "cost": 2.409226263, "chosen": true }, "setup_range_conditions": [], @@ -1554,7 +1554,7 @@ EXPLAIN SELECT id,MIN(a),MAX(a) FROM t1 WHERE a>=20010104e0 GROUP BY id { "range_analysis": { "table_scan": { "rows": 16, - "cost": 7.2313 + "cost": 7.23125 }, "potential_range_indexes": [ { @@ -1565,7 +1565,7 @@ EXPLAIN SELECT id,MIN(a),MAX(a) FROM t1 WHERE a>=20010104e0 GROUP BY id { ], "best_covering_index_scan": { "index": "id", - "cost": 4.2117, + "cost": 4.21171589, "chosen": true }, "setup_range_conditions": [], @@ -1736,7 +1736,7 @@ EXPLAIN SELECT * FROM t1 WHERE a = 20010104e0 GROUP BY id { "range_analysis": { "table_scan": { "rows": 16, - "cost": 7.2313 + "cost": 7.23125 }, "potential_range_indexes": [ { @@ -1747,7 +1747,7 @@ EXPLAIN SELECT * FROM t1 WHERE a = 20010104e0 GROUP BY id { ], "best_covering_index_scan": { "index": "id", - "cost": 4.2117, + "cost": 4.21171589, "chosen": true }, "setup_range_conditions": [], @@ -1964,7 +1964,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "range_analysis": { "table_scan": { "rows": 1000, - "cost": 232.56 + "cost": 232.5644531 }, "potential_range_indexes": [ { @@ -1993,7 +1993,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "using_mrr": false, "index_only": false, "rows": 180, - "cost": 216.29, + "cost": 216.2943776, "chosen": true }, { @@ -2003,7 +2003,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "using_mrr": false, "index_only": false, "rows": 21, - "cost": 25.362, + "cost": 25.36242739, "chosen": true } ], @@ -2024,7 +2024,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "ranges": ["(1,2) <= (a,b) <= (1,2)"] }, "rows_for_plan": 21, - "cost_for_plan": 25.362, + "cost_for_plan": 25.36242739, "chosen": true } } @@ -2034,12 +2034,12 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "rowid_filters": [ { "key": "a_b", - "build_cost": 0.8868, + "build_cost": 0.886777098, "rows": 21 }, { "key": "a_c", - "build_cost": 10.522, + "build_cost": 10.52169992, "rows": 180 } ] @@ -2054,11 +2054,11 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "selectivity_for_columns": [ { "column_name": "a", - "selectivity_from_histogram": 0.1797 + "selectivity_from_histogram": 0.1796875 }, { "column_name": "b", - "selectivity_from_histogram": 0.0156 + "selectivity_from_histogram": 0.015625 } ], "cond_selectivity": 0.021 @@ -2077,7 +2077,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "index": "a_c", "used_range_estimates": true, "rows": 180, - "cost": 180.27, + "cost": 180.2743776, "chosen": true }, { @@ -2085,7 +2085,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "index": "a_b", "used_range_estimates": true, "rows": 21, - "cost": 21.142, + "cost": 21.14242739, "chosen": true }, { @@ -2097,12 +2097,12 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "chosen_access_method": { "type": "ref", "records": 21, - "cost": 21.142, + "cost": 21.14242739, "uses_join_buffering": false } }, "rows_for_plan": 21, - "cost_for_plan": 25.342, + "cost_for_plan": 25.34242739, "estimated_join_cardinality": 21 } ] @@ -2126,7 +2126,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "reconsidering_access_paths_for_index_ordering": { "clause": "ORDER BY", "fanout": 1, - "read_time": 21.143, + "read_time": 21.14342739, "table": "t1", "rows_estimation": 21, "possible_keys": [ @@ -2142,8 +2142,8 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "index": "a_c", "can_resolve_order": true, "updated_limit": 47, - "range_scan_time": 4.331, - "index_scan_time": 4.331, + "range_scan_time": 4.331020747, + "index_scan_time": 4.331020747, "records": 180, "chosen": true }, @@ -2160,7 +2160,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "range_analysis": { "table_scan": { "rows": 1000, - "cost": 2e308 + "cost": 1.79769e308 }, "potential_range_indexes": [ { @@ -2189,7 +2189,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "using_mrr": false, "index_only": false, "rows": 180, - "cost": 216.29, + "cost": 216.2943776, "chosen": true } ], @@ -2210,7 +2210,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "ranges": ["(1) <= (a) <= (1)"] }, "rows_for_plan": 180, - "cost_for_plan": 216.29, + "cost_for_plan": 216.2943776, "chosen": true } } @@ -2309,7 +2309,7 @@ select t1.a from t1 left join t2 on t1.a=t2.a { "table": "t1", "table_scan": { "rows": 4, - "cost": 2.0068 + "cost": 2.006835938 } }, { @@ -2330,19 +2330,19 @@ select t1.a from t1 left join t2 on t1.a=t2.a { { "access_type": "scan", "resulting_rows": 4, - "cost": 2.0068, + "cost": 2.006835938, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 4, - "cost": 2.0068, + "cost": 2.006835938, "uses_join_buffering": false } }, "rows_for_plan": 4, - "cost_for_plan": 2.8068, + "cost_for_plan": 2.806835937, "estimated_join_cardinality": 4 } ] @@ -2434,14 +2434,14 @@ explain select * from t1 left join t2 on t2.a=t1.a { "table": "t1", "table_scan": { "rows": 4, - "cost": 2.0068 + "cost": 2.006835938 } }, { "table": "t2", "table_scan": { "rows": 2, - "cost": 2.0044 + "cost": 2.004394531 } } ] @@ -2456,19 +2456,19 @@ explain select * from t1 left join t2 on t2.a=t1.a { { "access_type": "scan", "resulting_rows": 4, - "cost": 2.0068, + "cost": 2.006835938, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 4, - "cost": 2.0068, + "cost": 2.006835938, "uses_join_buffering": false } }, "rows_for_plan": 4, - "cost_for_plan": 2.8068, + "cost_for_plan": 2.806835937, "rest_of_plan": [ { "plan_prefix": ["t1"], @@ -2485,7 +2485,7 @@ explain select * from t1 left join t2 on t2.a=t1.a { { "access_type": "scan", "resulting_rows": 2, - "cost": 8.0176, + "cost": 8.017578125, "chosen": false } ], @@ -2497,7 +2497,7 @@ explain select * from t1 left join t2 on t2.a=t1.a { } }, "rows_for_plan": 4, - "cost_for_plan": 7.6068, + "cost_for_plan": 7.606835937, "estimated_join_cardinality": 4 } ] @@ -2618,7 +2618,7 @@ explain select t1.a from t1 left join (t2 join t3 on t2.b=t3.b) on t2.a=t1.a and "table": "t1", "table_scan": { "rows": 4, - "cost": 2.0068 + "cost": 2.006835938 } }, { @@ -2645,19 +2645,19 @@ explain select t1.a from t1 left join (t2 join t3 on t2.b=t3.b) on t2.a=t1.a and { "access_type": "scan", "resulting_rows": 4, - "cost": 2.0068, + "cost": 2.006835938, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 4, - "cost": 2.0068, + "cost": 2.006835938, "uses_join_buffering": false } }, "rows_for_plan": 4, - "cost_for_plan": 2.8068, + "cost_for_plan": 2.806835937, "estimated_join_cardinality": 4 } ] @@ -2817,14 +2817,14 @@ explain extended select * from t1 where a in (select pk from t10) { "table": "t1", "table_scan": { "rows": 3, - "cost": 2.0066 + "cost": 2.006591797 } }, { "table": "t10", "table_scan": { "rows": 10, - "cost": 2.022 + "cost": 2.021972656 } } ] @@ -2847,19 +2847,19 @@ explain extended select * from t1 where a in (select pk from t10) { { "access_type": "scan", "resulting_rows": 10, - "cost": 2.022, + "cost": 2.021972656, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 10, - "cost": 2.022, + "cost": 2.021972656, "uses_join_buffering": false } }, "rows_for_plan": 10, - "cost_for_plan": 4.022, + "cost_for_plan": 4.021972656, "estimated_join_cardinality": 10 } ] @@ -2877,19 +2877,19 @@ explain extended select * from t1 where a in (select pk from t10) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0066, + "cost": 2.006591797, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0066, + "cost": 2.006591797, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6066, + "cost_for_plan": 2.606591797, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -2900,34 +2900,34 @@ explain extended select * from t1 where a in (select pk from t10) { { "access_type": "scan", "resulting_rows": 10, - "cost": 2.022, + "cost": 2.021972656, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 10, - "cost": 2.022, + "cost": 2.021972656, "uses_join_buffering": true } }, "rows_for_plan": 30, - "cost_for_plan": 10.629, + "cost_for_plan": 10.62856445, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "records": 3, - "read_time": 10.629 + "read_time": 10.62856445 }, { "strategy": "SJ-Materialization", "records": 3, - "read_time": 5.2786 + "read_time": 5.278564453 }, { "strategy": "DuplicateWeedout", "records": 3, - "read_time": 27.129 + "read_time": 27.12856445 }, { "chosen_strategy": "SJ-Materialization" @@ -2945,19 +2945,19 @@ explain extended select * from t1 where a in (select pk from t10) { { "access_type": "scan", "resulting_rows": 10, - "cost": 2.022, + "cost": 2.021972656, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 10, - "cost": 2.022, + "cost": 2.021972656, "uses_join_buffering": false } }, "rows_for_plan": 10, - "cost_for_plan": 4.022, + "cost_for_plan": 4.021972656, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -3133,7 +3133,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "range_analysis": { "table_scan": { "rows": 10, - "cost": 6.0317 + "cost": 6.031738281 }, "potential_range_indexes": [ { @@ -3154,7 +3154,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { ], "best_covering_index_scan": { "index": "pk_a_b", - "cost": 3.0107, + "cost": 3.010739566, "chosen": true }, "setup_range_conditions": [], @@ -3167,7 +3167,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3456, + "cost": 1.345585794, "chosen": true }, { @@ -3177,7 +3177,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3458, + "cost": 1.345829876, "chosen": false, "cause": "cost" }, @@ -3188,7 +3188,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "using_mrr": false, "index_only": true, "rows": 1, - "cost": 0.3461, + "cost": 0.346073957, "chosen": true } ], @@ -3196,10 +3196,10 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "intersecting_indexes": [ { "index": "pk", - "index_scan_cost": 1.0006, - "cumulated_index_scan_cost": 1.0006, - "disk_sweep_cost": 0.9008, - "cumulative_total_cost": 1.9014, + "index_scan_cost": 1.000585794, + "cumulated_index_scan_cost": 1.000585794, + "disk_sweep_cost": 0.90078125, + "cumulative_total_cost": 1.901367044, "usable": true, "matching_rows_now": 1, "intersect_covering_with_this_index": false, @@ -3237,7 +3237,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "ranges": ["(2,5,1) <= (pk,a,b) <= (2,5,1)"] }, "rows_for_plan": 1, - "cost_for_plan": 0.3461, + "cost_for_plan": 0.346073957, "chosen": true } } @@ -3247,17 +3247,17 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "rowid_filters": [ { "key": "pk", - "build_cost": 0.1306, + "build_cost": 0.130585794, "rows": 1 }, { "key": "pk_a", - "build_cost": 0.1308, + "build_cost": 0.130829876, "rows": 1 }, { "key": "pk_a_b", - "build_cost": 0.1311, + "build_cost": 0.131073957, "rows": 1 } ] @@ -3295,7 +3295,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "index": "pk", "used_range_estimates": true, "rows": 1, - "cost": 1.1256, + "cost": 1.125585794, "chosen": true }, { @@ -3303,7 +3303,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "index": "pk_a", "used_range_estimates": true, "rows": 1, - "cost": 1.1258, + "cost": 1.125829876, "chosen": false, "cause": "cost" }, @@ -3312,7 +3312,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "index": "pk_a_b", "used_range_estimates": true, "rows": 1, - "cost": 0.1261, + "cost": 0.126073957, "chosen": true }, { @@ -3324,12 +3324,12 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "chosen_access_method": { "type": "ref", "records": 1, - "cost": 0.1261, + "cost": 0.126073957, "uses_join_buffering": false } }, "rows_for_plan": 1, - "cost_for_plan": 0.3261, + "cost_for_plan": 0.326073957, "estimated_join_cardinality": 1 } ] @@ -3426,7 +3426,7 @@ select f1(a) from t1 { "table": "t1", "table_scan": { "rows": 4, - "cost": 2.0068 + "cost": 2.006835938 } } ] @@ -3441,19 +3441,19 @@ select f1(a) from t1 { { "access_type": "scan", "resulting_rows": 4, - "cost": 2.0068, + "cost": 2.006835938, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 4, - "cost": 2.0068, + "cost": 2.006835938, "uses_join_buffering": false } }, "rows_for_plan": 4, - "cost_for_plan": 2.8068, + "cost_for_plan": 2.806835937, "estimated_join_cardinality": 4 } ] @@ -3524,7 +3524,7 @@ select f2(a) from t1 { "table": "t1", "table_scan": { "rows": 4, - "cost": 2.0068 + "cost": 2.006835938 } } ] @@ -3539,19 +3539,19 @@ select f2(a) from t1 { { "access_type": "scan", "resulting_rows": 4, - "cost": 2.0068, + "cost": 2.006835938, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 4, - "cost": 2.0068, + "cost": 2.006835938, "uses_join_buffering": false } }, "rows_for_plan": 4, - "cost_for_plan": 2.8068, + "cost_for_plan": 2.806835937, "estimated_join_cardinality": 4 } ] @@ -3599,7 +3599,7 @@ a 2 select length(trace) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; length(trace) -2163 +2183 set optimizer_trace_max_mem_size=100; select * from t1; a @@ -3613,7 +3613,7 @@ select * from t1 { "join_preparation": { "select_id": 1, "steps": [ - 2063 0 + 2083 0 set optimizer_trace_max_mem_size=0; select * from t1; a @@ -3621,7 +3621,7 @@ a 2 select * from INFORMATION_SCHEMA.OPTIMIZER_TRACE; QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES -select * from t1 2163 0 +select * from t1 2183 0 drop table t1; set optimizer_trace='enabled=off'; set @@optimizer_trace_max_mem_size= @save_optimizer_trace_max_mem_size; @@ -3646,7 +3646,7 @@ explain delete from t0 where t0.a<3 { "range_analysis": { "table_scan": { "rows": 10, - "cost": 6.022 + "cost": 6.021972656 }, "potential_range_indexes": [ { @@ -3665,7 +3665,7 @@ explain delete from t0 where t0.a<3 { "using_mrr": false, "index_only": false, "rows": 3, - "cost": 3.7468, + "cost": 3.746757383, "chosen": true } ], @@ -3683,7 +3683,7 @@ explain delete from t0 where t0.a<3 { "ranges": ["(NULL) < (a) < (3)"] }, "rows_for_plan": 3, - "cost_for_plan": 3.7468, + "cost_for_plan": 3.746757383, "chosen": true } } @@ -3784,7 +3784,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "range_analysis": { "table_scan": { "rows": 10, - "cost": 6.022 + "cost": 6.021972656 }, "potential_range_indexes": [ { @@ -3795,7 +3795,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { ], "best_covering_index_scan": { "index": "a", - "cost": 3.0059, + "cost": 3.005857945, "chosen": true }, "setup_range_conditions": [], @@ -3808,7 +3808,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "using_mrr": false, "index_only": true, "rows": 3, - "cost": 0.7468, + "cost": 0.746757383, "chosen": true } ], @@ -3829,7 +3829,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "ranges": ["(NULL) < (a) < (3)"] }, "rows_for_plan": 3, - "cost_for_plan": 0.7468, + "cost_for_plan": 0.746757383, "chosen": true } } @@ -3849,7 +3849,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "range_analysis": { "table_scan": { "rows": 10, - "cost": 6.022 + "cost": 6.021972656 }, "potential_range_indexes": [ { @@ -3860,7 +3860,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { ], "best_covering_index_scan": { "index": "a", - "cost": 3.0059, + "cost": 3.005857945, "chosen": true }, "setup_range_conditions": [], @@ -3873,7 +3873,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "using_mrr": false, "index_only": true, "rows": 3, - "cost": 0.7468, + "cost": 0.746757383, "chosen": true } ], @@ -3894,7 +3894,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "ranges": ["(NULL) < (a) < (3)"] }, "rows_for_plan": 3, - "cost_for_plan": 0.7468, + "cost_for_plan": 0.746757383, "chosen": true } } @@ -3921,19 +3921,19 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { { "access_type": "range", "resulting_rows": 3, - "cost": 0.7468, + "cost": 0.746757383, "chosen": true } ], "chosen_access_method": { "type": "range", "records": 3, - "cost": 0.7468, + "cost": 0.746757383, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 1.3468, + "cost_for_plan": 1.346757383, "rest_of_plan": [ { "plan_prefix": ["t0"], @@ -3946,7 +3946,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "used_range_estimates": false, "cause": "not better than ref estimates", "rows": 1, - "cost": 3.0018, + "cost": 3.001757383, "chosen": true }, { @@ -3958,12 +3958,12 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "chosen_access_method": { "type": "ref", "records": 1, - "cost": 3.0018, + "cost": 3.001757383, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 4.9485, + "cost_for_plan": 4.948514767, "estimated_join_cardinality": 3 } ] @@ -3976,19 +3976,19 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { { "access_type": "range", "resulting_rows": 3, - "cost": 0.7468, + "cost": 0.746757383, "chosen": true } ], "chosen_access_method": { "type": "range", "records": 3, - "cost": 0.7468, + "cost": 0.746757383, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 1.3468, + "cost_for_plan": 1.346757383, "rest_of_plan": [ { "plan_prefix": ["t1"], @@ -4001,7 +4001,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "used_range_estimates": false, "cause": "not better than ref estimates", "rows": 2, - "cost": 3.0035, + "cost": 3.003514767, "chosen": true }, { @@ -4013,12 +4013,12 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "chosen_access_method": { "type": "ref", "records": 2, - "cost": 3.0035, + "cost": 3.003514767, "uses_join_buffering": false } }, "rows_for_plan": 6, - "cost_for_plan": 5.5503, + "cost_for_plan": 5.55027215, "pruned_by_cost": true } ] @@ -4130,7 +4130,7 @@ explain select * from (select rand() from t1)q { "table": "t1", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } } ] @@ -4145,19 +4145,19 @@ explain select * from (select rand() from t1)q { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "estimated_join_cardinality": 3 } ] @@ -4382,21 +4382,21 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "table": "t1", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } }, { "table": "t_inner_1", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } }, { "table": "t_inner_2", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } } ] @@ -4419,19 +4419,19 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "rest_of_plan": [ { "plan_prefix": ["t_inner_1"], @@ -4441,19 +4441,19 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 9, - "cost_for_plan": 6.4103, + "cost_for_plan": 6.410253906, "estimated_join_cardinality": 9 } ] @@ -4466,19 +4466,19 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "pruned_by_heuristic": true } ] @@ -4496,19 +4496,19 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -4519,19 +4519,19 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 9, - "cost_for_plan": 6.4103, + "cost_for_plan": 6.410253906, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -4542,34 +4542,34 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 13.815, + "cost_for_plan": 13.81538086, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "records": 3, - "read_time": 33.867 + "read_time": 33.86665039 }, { "strategy": "SJ-Materialization", "records": 3, - "read_time": 7.2154 + "read_time": 7.215380859 }, { "strategy": "DuplicateWeedout", "records": 3, - "read_time": 18.315 + "read_time": 18.31538086 }, { "chosen_strategy": "SJ-Materialization" @@ -4587,19 +4587,19 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 9, - "cost_for_plan": 6.4103, + "cost_for_plan": 6.410253906, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -4613,19 +4613,19 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -4637,19 +4637,19 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -4880,42 +4880,42 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "table": "t_outer_1", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } }, { "table": "t_outer_2", "table_scan": { "rows": 9, - "cost": 2.0154 + "cost": 2.015380859 } }, { "table": "t_inner_2", "table_scan": { "rows": 9, - "cost": 2.0154 + "cost": 2.015380859 } }, { "table": "t_inner_1", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } }, { "table": "t_inner_3", "table_scan": { "rows": 9, - "cost": 2.0154 + "cost": 2.015380859 } }, { "table": "t_inner_4", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } } ] @@ -4945,19 +4945,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -4968,19 +4968,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 9, - "cost_for_plan": 6.4103, + "cost_for_plan": 6.410253906, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -4991,29 +4991,29 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 24.626, + "cost_for_plan": 24.62563477, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "records": 3, - "read_time": 44.759 + "read_time": 44.75893555 }, { "strategy": "DuplicateWeedout", "records": 3, - "read_time": 37.226 + "read_time": 37.22563477 }, { "chosen_strategy": "DuplicateWeedout" @@ -5028,19 +5028,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 44.641, + "cost_for_plan": 44.64101563, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5056,19 +5056,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 62.846, + "cost_for_plan": 62.84614258, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5085,29 +5085,29 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 729, - "cost_for_plan": 210.66, + "cost_for_plan": 210.6615234, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "records": 27, - "read_time": 424.03 + "read_time": 424.025293 }, { "strategy": "DuplicateWeedout", "records": 27, - "read_time": 324.06 + "read_time": 324.0615234 }, { "chosen_strategy": "DuplicateWeedout" @@ -5130,19 +5130,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 243, - "cost_for_plan": 95.256, + "cost_for_plan": 95.25639648, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -5156,19 +5156,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 9, - "cost_for_plan": 41.031, + "cost_for_plan": 41.03076172, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5184,19 +5184,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 59.246, + "cost_for_plan": 59.24614258, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5213,24 +5213,24 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 729, - "cost_for_plan": 207.06, + "cost_for_plan": 207.0615234, "semijoin_strategy_choice": [ { "strategy": "DuplicateWeedout", "records": 27, - "read_time": 320.46 + "read_time": 320.4615234 }, { "chosen_strategy": "DuplicateWeedout" @@ -5253,19 +5253,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 59.246, + "cost_for_plan": 59.24614258, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -5279,19 +5279,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 44.641, + "cost_for_plan": 44.64101563, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -5305,19 +5305,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 24.626, + "cost_for_plan": 24.62563477, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5328,24 +5328,24 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 729, - "cost_for_plan": 172.44, + "cost_for_plan": 172.4410156, "semijoin_strategy_choice": [ { "strategy": "DuplicateWeedout", "records": 27, - "read_time": 285.84 + "read_time": 285.8410156 }, { "chosen_strategy": "DuplicateWeedout" @@ -5365,19 +5365,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 304.05, + "cost_for_plan": 304.0461426, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5394,24 +5394,24 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 729, - "cost_for_plan": 451.86, + "cost_for_plan": 451.8615234, "semijoin_strategy_choice": [ { "strategy": "DuplicateWeedout", "records": 27, - "read_time": 565.26 + "read_time": 565.2615234 }, { "chosen_strategy": "DuplicateWeedout" @@ -5434,19 +5434,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 243, - "cost_for_plan": 336.46, + "cost_for_plan": 336.4563965, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -5460,19 +5460,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 243, - "cost_for_plan": 75.231, + "cost_for_plan": 75.23076172, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5488,19 +5488,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 2187, - "cost_for_plan": 514.65, + "cost_for_plan": 514.6461426, "semijoin_strategy_choice": [], "pruned_by_cost": true }, @@ -5517,19 +5517,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 2187, - "cost_for_plan": 514.65, + "cost_for_plan": 514.6461426, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -5543,19 +5543,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 729, - "cost_for_plan": 172.44, + "cost_for_plan": 172.4410156, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5571,24 +5571,24 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 2187, - "cost_for_plan": 611.85, + "cost_for_plan": 611.8461426, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "records": 81, - "read_time": 2232.8 + "read_time": 2232.809033 }, { "chosen_strategy": "FirstMatch" @@ -5609,19 +5609,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 6561, - "cost_for_plan": 1486.7, + "cost_for_plan": 1486.656396, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -5637,19 +5637,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 13.815, + "cost_for_plan": 13.81538086, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5660,19 +5660,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 243, - "cost_for_plan": 64.431, + "cost_for_plan": 64.43076172, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5688,19 +5688,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 2187, - "cost_for_plan": 503.85, + "cost_for_plan": 503.8461426, "semijoin_strategy_choice": [], "pruned_by_cost": true }, @@ -5717,19 +5717,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 2187, - "cost_for_plan": 503.85, + "cost_for_plan": 503.8461426, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -5743,19 +5743,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 243, - "cost_for_plan": 64.431, + "cost_for_plan": 64.43076172, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -5767,19 +5767,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 243, - "cost_for_plan": 64.431, + "cost_for_plan": 64.43076172, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -5793,19 +5793,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 24.626, + "cost_for_plan": 24.62563477, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5816,19 +5816,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 729, - "cost_for_plan": 172.44, + "cost_for_plan": 172.4410156, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5844,19 +5844,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 2187, - "cost_for_plan": 611.85, + "cost_for_plan": 611.8461426, "semijoin_strategy_choice": [], "pruned_by_cost": true }, @@ -5873,19 +5873,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 6561, - "cost_for_plan": 1486.7, + "cost_for_plan": 1486.656396, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -5899,19 +5899,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 243, - "cost_for_plan": 75.231, + "cost_for_plan": 75.23076172, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -5927,19 +5927,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 2187, - "cost_for_plan": 514.65, + "cost_for_plan": 514.6461426, "semijoin_strategy_choice": [], "pruned_by_cost": true }, @@ -5956,19 +5956,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 2187, - "cost_for_plan": 514.65, + "cost_for_plan": 514.6461426, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -5982,19 +5982,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 729, - "cost_for_plan": 172.44, + "cost_for_plan": 172.4410156, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -6010,19 +6010,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 10.021, + "cost_for_plan": 10.02050781, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -6034,19 +6034,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 10.021, + "cost_for_plan": 10.02050781, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -6058,19 +6058,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 9, - "cost_for_plan": 6.4103, + "cost_for_plan": 6.410253906, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -6082,19 +6082,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 10.021, + "cost_for_plan": 10.02050781, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -6108,19 +6108,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -6132,19 +6132,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": false } }, "rows_for_plan": 9, - "cost_for_plan": 3.8154, + "cost_for_plan": 3.815380859, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -6156,19 +6156,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": false } }, "rows_for_plan": 9, - "cost_for_plan": 3.8154, + "cost_for_plan": 3.815380859, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -6180,19 +6180,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -6204,19 +6204,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": false } }, "rows_for_plan": 9, - "cost_for_plan": 3.8154, + "cost_for_plan": 3.815380859, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -6455,42 +6455,42 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "table": "t_outer_1", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } }, { "table": "t_outer_2", "table_scan": { "rows": 9, - "cost": 2.0154 + "cost": 2.015380859 } }, { "table": "t_inner_2", "table_scan": { "rows": 9, - "cost": 2.0154 + "cost": 2.015380859 } }, { "table": "t_inner_1", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } }, { "table": "t_inner_3", "table_scan": { "rows": 9, - "cost": 2.0154 + "cost": 2.015380859 } }, { "table": "t_inner_4", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } } ] @@ -6518,19 +6518,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "rest_of_plan": [ { "plan_prefix": ["t_inner_1"], @@ -6540,19 +6540,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 10.021, + "cost_for_plan": 10.02050781, "estimated_join_cardinality": 27 } ] @@ -6565,19 +6565,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": false } }, "rows_for_plan": 9, - "cost_for_plan": 3.8154, + "cost_for_plan": 3.815380859, "pruned_by_heuristic": true } ] @@ -6592,19 +6592,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "rest_of_plan": [ { "plan_prefix": ["t_inner_4"], @@ -6614,19 +6614,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 10.021, + "cost_for_plan": 10.02050781, "estimated_join_cardinality": 27 } ] @@ -6639,19 +6639,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": false } }, "rows_for_plan": 9, - "cost_for_plan": 3.8154, + "cost_for_plan": 3.815380859, "pruned_by_heuristic": true } ] @@ -6669,19 +6669,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -6692,19 +6692,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 9, - "cost_for_plan": 6.4103, + "cost_for_plan": 6.410253906, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -6715,34 +6715,34 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 24.626, + "cost_for_plan": 24.62563477, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "records": 3, - "read_time": 44.759 + "read_time": 44.75893555 }, { "strategy": "SJ-Materialization", "records": 3, - "read_time": 8.1256 + "read_time": 8.125634766 }, { "strategy": "DuplicateWeedout", "records": 3, - "read_time": 37.226 + "read_time": 37.22563477 }, { "chosen_strategy": "SJ-Materialization" @@ -6757,19 +6757,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 15.541, + "cost_for_plan": 15.54101562, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -6785,19 +6785,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 33.746, + "cost_for_plan": 33.74614258, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -6814,34 +6814,34 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 729, - "cost_for_plan": 181.56, + "cost_for_plan": 181.5615234, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "records": 27, - "read_time": 394.93 + "read_time": 394.925293 }, { "strategy": "SJ-Materialization", "records": 27, - "read_time": 22.262 + "read_time": 22.26152344 }, { "strategy": "DuplicateWeedout", "records": 27, - "read_time": 294.96 + "read_time": 294.9615234 }, { "chosen_strategy": "SJ-Materialization" @@ -6864,19 +6864,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 243, - "cost_for_plan": 66.156, + "cost_for_plan": 66.15639648, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -6890,19 +6890,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 9, - "cost_for_plan": 11.931, + "cost_for_plan": 11.93076172, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -6918,19 +6918,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 30.146, + "cost_for_plan": 30.14614258, "semijoin_strategy_choice": [], "pruned_by_cost": true }, @@ -6947,19 +6947,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 30.146, + "cost_for_plan": 30.14614258, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -6973,19 +6973,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 15.541, + "cost_for_plan": 15.54101562, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -6999,19 +6999,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 24.626, + "cost_for_plan": 24.62563477, "semijoin_strategy_choice": [], "pruned_by_cost": true }, @@ -7023,19 +7023,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 13.815, + "cost_for_plan": 13.81538086, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -7047,19 +7047,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 81, - "cost_for_plan": 24.626, + "cost_for_plan": 24.62563477, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -7073,19 +7073,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 10.021, + "cost_for_plan": 10.02050781, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -7097,19 +7097,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 10.021, + "cost_for_plan": 10.02050781, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -7121,19 +7121,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": true } }, "rows_for_plan": 9, - "cost_for_plan": 6.4103, + "cost_for_plan": 6.410253906, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -7145,19 +7145,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": true } }, "rows_for_plan": 27, - "cost_for_plan": 10.021, + "cost_for_plan": 10.02050781, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -7171,19 +7171,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -7195,19 +7195,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": false } }, "rows_for_plan": 9, - "cost_for_plan": 3.8154, + "cost_for_plan": 3.815380859, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -7219,19 +7219,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": false } }, "rows_for_plan": 9, - "cost_for_plan": 3.8154, + "cost_for_plan": 3.815380859, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -7243,19 +7243,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "semijoin_strategy_choice": [], "pruned_by_heuristic": true }, @@ -7267,19 +7267,19 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "access_type": "scan", "resulting_rows": 9, - "cost": 2.0154, + "cost": 2.015380859, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 9, - "cost": 2.0154, + "cost": 2.015380859, "uses_join_buffering": false } }, "rows_for_plan": 9, - "cost_for_plan": 3.8154, + "cost_for_plan": 3.815380859, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -7419,7 +7419,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 1, - "cost": 0.3458, + "cost": 0.345829876, "chosen": true } ], @@ -7453,7 +7453,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 107, - "cost": 21.634, + "cost": 21.63379668, "chosen": true } ], @@ -7490,7 +7490,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1000, - "cost": 1203.9, + "cost": 1203.877243, "chosen": true } ], @@ -7535,7 +7535,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 4, - "cost": 4.9487, + "cost": 4.948710032, "chosen": true } ], @@ -7574,7 +7574,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3462, + "cost": 1.346171589, "chosen": true } ], @@ -7608,7 +7608,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3462, + "cost": 1.346171589, "chosen": true } ], @@ -7650,7 +7650,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3459, + "cost": 1.345927508, "chosen": true } ], @@ -7685,7 +7685,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3459, + "cost": 1.345878692, "chosen": true } ], @@ -7720,7 +7720,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3459, + "cost": 1.345927508, "chosen": true } ], @@ -7758,7 +7758,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3459, + "cost": 1.345878692, "chosen": true } ], @@ -7799,7 +7799,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3943, + "cost": 1.394255553, "chosen": true } ], @@ -7838,7 +7838,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 2, - "cost": 2.5469, + "cost": 2.546855016, "chosen": true } ], @@ -7894,7 +7894,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1000, - "cost": 1203.9, + "cost": 1203.877243, "chosen": true } ], @@ -7959,7 +7959,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) { "access_type": "scan", "resulting_rows": 5.9375, - "cost": 2.8296, + "cost": 2.829589844, "chosen": true } ], @@ -7967,12 +7967,12 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) { "type": "scan", "records": 5.9375, - "cost": 2.8296, + "cost": 2.829589844, "uses_join_buffering": false } }, "rows_for_plan": 5.9375, - "cost_for_plan": 4.0171, + "cost_for_plan": 4.017089844, "rest_of_plan": [ @@ -7989,22 +7989,22 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) { "access_type": "scan", - "resulting_rows": 804.69, - "cost": 256.85, + "resulting_rows": 804.6875, + "cost": 256.8548584, "chosen": true } ], "chosen_access_method": { "type": "scan", - "records": 804.69, - "cost": 256.85, + "records": 804.6875, + "cost": 256.8548584, "uses_join_buffering": false } }, - "rows_for_plan": 4777.8, - "cost_for_plan": 1216.4, - "estimated_join_cardinality": 4777.8 + "rows_for_plan": 4777.832031, + "cost_for_plan": 1216.438354, + "estimated_join_cardinality": 4777.832031 } ] }, @@ -8021,21 +8021,21 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) { "access_type": "scan", - "resulting_rows": 804.69, - "cost": 43.26, + "resulting_rows": 804.6875, + "cost": 43.25976562, "chosen": true } ], "chosen_access_method": { "type": "scan", - "records": 804.69, - "cost": 43.26, + "records": 804.6875, + "cost": 43.25976562, "uses_join_buffering": false } }, - "rows_for_plan": 804.69, - "cost_for_plan": 204.2, + "rows_for_plan": 804.6875, + "cost_for_plan": 204.1972656, "pruned_by_heuristic": true } ] @@ -8065,7 +8065,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) { "access_type": "scan", "resulting_rows": 10, - "cost": 2.0171, + "cost": 2.017089844, "chosen": true } ], @@ -8073,12 +8073,12 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) { "type": "scan", "records": 10, - "cost": 2.0171, + "cost": 2.017089844, "uses_join_buffering": false } }, "rows_for_plan": 10, - "cost_for_plan": 4.0171, + "cost_for_plan": 4.017089844, "rest_of_plan": [ @@ -8099,14 +8099,14 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "used_range_estimates": false, "cause": "not available", "rows": 1, - "cost": 20.006, + "cost": 20.00585794, "chosen": true }, { "access_type": "scan", - "resulting_rows": 804.69, - "cost": 43.26, + "resulting_rows": 804.6875, + "cost": 43.25976562, "chosen": false } ], @@ -8114,14 +8114,14 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) { "type": "ref", "records": 1, - "cost": 20.006, + "cost": 20.00585794, "uses_join_buffering": false } }, "rows_for_plan": 10, - "cost_for_plan": 26.023, - "selectivity": 0.8047, - "estimated_join_cardinality": 8.0469 + "cost_for_plan": 26.02294779, + "selectivity": 0.8046875, + "estimated_join_cardinality": 8.046875 } ] }, @@ -8138,21 +8138,21 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) { "access_type": "scan", - "resulting_rows": 804.69, - "cost": 43.26, + "resulting_rows": 804.6875, + "cost": 43.25976562, "chosen": true } ], "chosen_access_method": { "type": "scan", - "records": 804.69, - "cost": 43.26, + "records": 804.6875, + "cost": 43.25976562, "uses_join_buffering": false } }, - "rows_for_plan": 804.69, - "cost_for_plan": 204.2, + "rows_for_plan": 804.6875, + "cost_for_plan": 204.1972656, "pruned_by_cost": true } ] @@ -8186,7 +8186,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3579, + "cost": 1.357887479, "chosen": true } ], @@ -8228,4 +8228,102 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.semijoin_table_pullout')) } ] drop table t1,t2,t3; +# +# Test many rows to see output of big cost numbers +# +select count(*) from seq_1_to_10000000; +count(*) +10000000 +select * from INFORMATION_SCHEMA.OPTIMIZER_TRACE; +QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES +select count(*) from seq_1_to_10000000 { + "steps": [ + { + "join_preparation": { + "select_id": 1, + "steps": [ + { + "expanded_query": "select count(0) AS `count(*)` from seq_1_to_10000000" + } + ] + } + }, + { + "join_optimization": { + "select_id": 1, + "steps": [ + { + "table_dependencies": [ + { + "table": "seq_1_to_10000000", + "row_may_be_null": false, + "map_bit": 0, + "depends_on_map_bits": [] + } + ] + }, + { + "rows_estimation": [ + { + "table": "seq_1_to_10000000", + "table_scan": { + "rows": 10000000, + "cost": 10000000 + } + } + ] + }, + { + "considered_execution_plans": [ + { + "plan_prefix": [], + "table": "seq_1_to_10000000", + "best_access_path": { + "considered_access_paths": [ + { + "access_type": "scan", + "resulting_rows": 10000000, + "cost": 10000000, + "chosen": true + } + ], + "chosen_access_method": { + "type": "scan", + "records": 10000000, + "cost": 10000000, + "uses_join_buffering": false + } + }, + "rows_for_plan": 10000000, + "cost_for_plan": 12000000, + "estimated_join_cardinality": 10000000 + } + ] + }, + { + "best_join_order": ["seq_1_to_10000000"] + }, + { + "attaching_conditions_to_tables": { + "original_condition": null, + "attached_conditions_computation": [], + "attached_conditions_summary": [ + { + "table": "seq_1_to_10000000", + "attached": null + } + ] + } + } + ] + } + }, + { + "join_execution": { + "select_id": 1, + "steps": [] + } + } + ] +} 0 0 set optimizer_trace='enabled=off'; diff --git a/mysql-test/main/opt_trace.test b/mysql-test/main/opt_trace.test index 51950f00781..ac8a1366ee5 100644 --- a/mysql-test/main/opt_trace.test +++ b/mysql-test/main/opt_trace.test @@ -1,4 +1,5 @@ --source include/not_embedded.inc +--source include/have_sequence.inc SELECT table_name, column_name FROM information_schema.columns where table_name="OPTIMIZER_TRACE"; show variables like 'optimizer_trace'; set optimizer_trace="enabled=on"; @@ -567,4 +568,12 @@ select * from t3 where (a,a) in (select t1.a, t2.a from t1, t2 where t1.b=t2.b); select JSON_DETAILED(JSON_EXTRACT(trace, '$**.semijoin_table_pullout')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; drop table t1,t2,t3; + +--echo # +--echo # Test many rows to see output of big cost numbers +--echo # + +select count(*) from seq_1_to_10000000; +select * from INFORMATION_SCHEMA.OPTIMIZER_TRACE; + set optimizer_trace='enabled=off'; diff --git a/mysql-test/main/opt_trace_index_merge.result b/mysql-test/main/opt_trace_index_merge.result index 052ec2fd108..3b79a7a44e8 100644 --- a/mysql-test/main/opt_trace_index_merge.result +++ b/mysql-test/main/opt_trace_index_merge.result @@ -73,7 +73,7 @@ explain select * from t1 where a=1 or b=1 { "range_analysis": { "table_scan": { "rows": 1000, - "cost": 231.59 + "cost": 231.5878906 }, "potential_range_indexes": [ { @@ -111,12 +111,12 @@ explain select * from t1 where a=1 or b=1 { "using_mrr": false, "index_only": true, "rows": 1, - "cost": 0.3456, + "cost": 0.345585794, "chosen": true } ], "index_to_merge": "a", - "cumulated_cost": 0.3456 + "cumulated_cost": 0.345585794 }, { "range_scan_alternatives": [ @@ -127,15 +127,15 @@ explain select * from t1 where a=1 or b=1 { "using_mrr": false, "index_only": true, "rows": 1, - "cost": 0.3456, + "cost": 0.345585794, "chosen": true } ], "index_to_merge": "b", - "cumulated_cost": 0.6912 + "cumulated_cost": 0.691171589 } ], - "cost_of_reading_ranges": 0.6912, + "cost_of_reading_ranges": 0.691171589, "use_roworder_union": true, "cause": "always cheaper than non roworder retrieval", "analyzing_roworder_scans": [ @@ -158,7 +158,7 @@ explain select * from t1 where a=1 or b=1 { } } ], - "index_roworder_union_cost": 2.4849, + "index_roworder_union_cost": 2.484903732, "members": 2, "chosen": true } @@ -187,7 +187,7 @@ explain select * from t1 where a=1 or b=1 { ] }, "rows_for_plan": 2, - "cost_for_plan": 2.4849, + "cost_for_plan": 2.484903732, "chosen": true } } @@ -209,19 +209,19 @@ explain select * from t1 where a=1 or b=1 { { "access_type": "index_merge", "resulting_rows": 2, - "cost": 2.4849, + "cost": 2.484903732, "chosen": true } ], "chosen_access_method": { "type": "index_merge", "records": 2, - "cost": 2.4849, + "cost": 2.484903732, "uses_join_buffering": false } }, "rows_for_plan": 2, - "cost_for_plan": 2.8849, + "cost_for_plan": 2.884903732, "estimated_join_cardinality": 2 } ] @@ -322,7 +322,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 2243, - "cost": 2700.1, + "cost": 2700.058937, "chosen": true }, @@ -336,7 +336,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 2243, - "cost": 2700.1, + "cost": 2700.058937, "chosen": false, "cause": "cost" }, @@ -351,7 +351,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 2243, - "cost": 2700.1, + "cost": 2700.058937, "chosen": false, "cause": "cost" } @@ -363,10 +363,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key1", - "index_scan_cost": 10.314, - "cumulated_index_scan_cost": 10.314, - "disk_sweep_cost": 1923.1, - "cumulative_total_cost": 1933.5, + "index_scan_cost": 10.31393703, + "cumulated_index_scan_cost": 10.31393703, + "disk_sweep_cost": 1923.144061, + "cumulative_total_cost": 1933.457998, "usable": true, "matching_rows_now": 2243, "intersect_covering_with_this_index": false, @@ -375,24 +375,24 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key2", - "index_scan_cost": 10.314, - "cumulated_index_scan_cost": 20.628, - "disk_sweep_cost": 84.518, - "cumulative_total_cost": 105.15, + "index_scan_cost": 10.31393703, + "cumulated_index_scan_cost": 20.62787405, + "disk_sweep_cost": 84.51771758, + "cumulative_total_cost": 105.1455916, "usable": true, - "matching_rows_now": 77.636, + "matching_rows_now": 77.6360508, "intersect_covering_with_this_index": false, "chosen": true }, { "index": "key3", - "index_scan_cost": 10.314, - "cumulated_index_scan_cost": 30.942, + "index_scan_cost": 10.31393703, + "cumulated_index_scan_cost": 30.94181108, "disk_sweep_cost": 0, - "cumulative_total_cost": 30.942, + "cumulative_total_cost": 30.94181108, "usable": true, - "matching_rows_now": 2.6872, + "matching_rows_now": 2.687185191, "intersect_covering_with_this_index": true, "chosen": true } @@ -403,7 +403,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "cause": "no clustered pk index" }, "rows": 2, - "cost": 30.942, + "cost": 30.94181108, "covering": true, "chosen": true }, @@ -421,7 +421,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) { "type": "index_roworder_intersect", "rows": 2, - "cost": 30.942, + "cost": 30.94181108, "covering": true, "clustered_pk_scan": false, "intersect_of": @@ -459,7 +459,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) ] }, "rows_for_plan": 2, - "cost_for_plan": 30.942, + "cost_for_plan": 30.94181108, "chosen": true } ] @@ -500,7 +500,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 2243, - "cost": 457.06, + "cost": 457.058937, "chosen": true }, @@ -514,13 +514,13 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 2243, - "cost": 457.06, + "cost": 457.058937, "chosen": false, "cause": "cost" } ], "index_to_merge": "key1", - "cumulated_cost": 457.06 + "cumulated_cost": 457.058937 }, { @@ -537,7 +537,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 2243, - "cost": 457.06, + "cost": 457.058937, "chosen": true }, @@ -551,16 +551,16 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 2243, - "cost": 457.06, + "cost": 457.058937, "chosen": false, "cause": "cost" } ], "index_to_merge": "key3", - "cumulated_cost": 914.12 + "cumulated_cost": 914.1178741 } ], - "cost_of_reading_ranges": 914.12, + "cost_of_reading_ranges": 914.1178741, "use_roworder_union": true, "cause": "always cheaper than non roworder retrieval", "analyzing_roworder_scans": @@ -581,10 +581,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key1", - "index_scan_cost": 10.314, - "cumulated_index_scan_cost": 10.314, - "disk_sweep_cost": 1923.1, - "cumulative_total_cost": 1933.5, + "index_scan_cost": 10.31393703, + "cumulated_index_scan_cost": 10.31393703, + "disk_sweep_cost": 1923.144061, + "cumulative_total_cost": 1933.457998, "usable": true, "matching_rows_now": 2243, "intersect_covering_with_this_index": false, @@ -593,12 +593,12 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key2", - "index_scan_cost": 10.314, - "cumulated_index_scan_cost": 20.628, - "disk_sweep_cost": 84.518, - "cumulative_total_cost": 105.15, + "index_scan_cost": 10.31393703, + "cumulated_index_scan_cost": 20.62787405, + "disk_sweep_cost": 84.51771758, + "cumulative_total_cost": 105.1455916, "usable": true, - "matching_rows_now": 77.636, + "matching_rows_now": 77.6360508, "intersect_covering_with_this_index": false, "chosen": true } @@ -609,7 +609,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "cause": "no clustered pk index" }, "rows": 77, - "cost": 105.15, + "cost": 105.1455916, "covering": false, "chosen": true } @@ -630,10 +630,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key3", - "index_scan_cost": 10.314, - "cumulated_index_scan_cost": 10.314, - "disk_sweep_cost": 1923.1, - "cumulative_total_cost": 1933.5, + "index_scan_cost": 10.31393703, + "cumulated_index_scan_cost": 10.31393703, + "disk_sweep_cost": 1923.144061, + "cumulative_total_cost": 1933.457998, "usable": true, "matching_rows_now": 2243, "intersect_covering_with_this_index": false, @@ -642,12 +642,12 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key4", - "index_scan_cost": 10.314, - "cumulated_index_scan_cost": 20.628, - "disk_sweep_cost": 84.518, - "cumulative_total_cost": 105.15, + "index_scan_cost": 10.31393703, + "cumulated_index_scan_cost": 20.62787405, + "disk_sweep_cost": 84.51771758, + "cumulative_total_cost": 105.1455916, "usable": true, - "matching_rows_now": 77.636, + "matching_rows_now": 77.6360508, "intersect_covering_with_this_index": false, "chosen": true } @@ -658,13 +658,13 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "cause": "no clustered pk index" }, "rows": 77, - "cost": 105.15, + "cost": 105.1455916, "covering": false, "chosen": true } } ], - "index_roworder_union_cost": 194.98, + "index_roworder_union_cost": 194.9771115, "members": 2, "chosen": true } @@ -685,7 +685,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) { "type": "index_roworder_intersect", "rows": 77, - "cost": 105.15, + "cost": 105.1455916, "covering": false, "clustered_pk_scan": false, "intersect_of": @@ -716,7 +716,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) { "type": "index_roworder_intersect", "rows": 77, - "cost": 105.15, + "cost": 105.1455916, "covering": false, "clustered_pk_scan": false, "intersect_of": @@ -746,7 +746,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) ] }, "rows_for_plan": 154, - "cost_for_plan": 194.98, + "cost_for_plan": 194.9771115, "chosen": true } ] diff --git a/mysql-test/main/opt_trace_index_merge_innodb.result b/mysql-test/main/opt_trace_index_merge_innodb.result index c2c066f8c27..25e7b187104 100644 --- a/mysql-test/main/opt_trace_index_merge_innodb.result +++ b/mysql-test/main/opt_trace_index_merge_innodb.result @@ -117,7 +117,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "using_mrr": false, "index_only": false, "rows": 1000, - "cost": 201.65, + "cost": 201.6536043, "chosen": true }, { @@ -127,7 +127,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.3451, + "cost": 1.345146475, "chosen": true } ], @@ -135,10 +135,10 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "intersecting_indexes": [ { "index": "key1", - "index_scan_cost": 1.0001, - "cumulated_index_scan_cost": 1.0001, - "disk_sweep_cost": 1.0014, - "cumulative_total_cost": 2.0015, + "index_scan_cost": 1.000146475, + "cumulated_index_scan_cost": 1.000146475, + "disk_sweep_cost": 1.001383604, + "cumulative_total_cost": 2.00153008, "usable": true, "matching_rows_now": 1, "intersect_covering_with_this_index": false, @@ -166,7 +166,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "ranges": ["(1) <= (key1) <= (1)"] }, "rows_for_plan": 1, - "cost_for_plan": 1.3451, + "cost_for_plan": 1.345146475, "chosen": true } } @@ -176,7 +176,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "rowid_filters": [ { "key": "key1", - "build_cost": 0.1301, + "build_cost": 0.130146475, "rows": 1 } ] @@ -209,7 +209,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "index": "key1", "used_range_estimates": true, "rows": 1, - "cost": 1.1251, + "cost": 1.125146475, "chosen": true }, { @@ -221,12 +221,12 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "chosen_access_method": { "type": "ref", "records": 1, - "cost": 1.1251, + "cost": 1.125146475, "uses_join_buffering": false } }, "rows_for_plan": 1, - "cost_for_plan": 1.3251, + "cost_for_plan": 1.325146475, "estimated_join_cardinality": 1 } ] diff --git a/mysql-test/main/opt_trace_security.result b/mysql-test/main/opt_trace_security.result index 6f377cd02b5..2c09f6c7d5a 100644 --- a/mysql-test/main/opt_trace_security.result +++ b/mysql-test/main/opt_trace_security.result @@ -80,7 +80,7 @@ select * from db1.t1 { "table": "t1", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } } ] @@ -95,19 +95,19 @@ select * from db1.t1 { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "estimated_join_cardinality": 3 } ] @@ -203,7 +203,7 @@ select * from db1.v1 { "table": "t1", "table_scan": { "rows": 3, - "cost": 2.0051 + "cost": 2.005126953 } } ] @@ -218,19 +218,19 @@ select * from db1.v1 { { "access_type": "scan", "resulting_rows": 3, - "cost": 2.0051, + "cost": 2.005126953, "chosen": true } ], "chosen_access_method": { "type": "scan", "records": 3, - "cost": 2.0051, + "cost": 2.005126953, "uses_join_buffering": false } }, "rows_for_plan": 3, - "cost_for_plan": 2.6051, + "cost_for_plan": 2.605126953, "estimated_join_cardinality": 3 } ] diff --git a/mysql-test/main/opt_trace_ucs2.result b/mysql-test/main/opt_trace_ucs2.result index 0d920341bcd..5de1fc5c3e9 100644 --- a/mysql-test/main/opt_trace_ucs2.result +++ b/mysql-test/main/opt_trace_ucs2.result @@ -38,7 +38,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 2, - "cost": 2.5477, + "cost": 2.547733708, "chosen": true } ], diff --git a/mysql-test/main/range.result b/mysql-test/main/range.result index e56fd46b55f..6abf9331771 100644 --- a/mysql-test/main/range.result +++ b/mysql-test/main/range.result @@ -2611,10 +2611,10 @@ EXPLAIN "used_key_parts": ["e"] }, "rows": 15, - "selectivity_pct": 14.423 + "selectivity_pct": 14.42307692 }, "rows": 8, - "filtered": 14.423, + "filtered": 14.42307663, "index_condition": "t2.d is not null", "attached_condition": "(t2.d,t2.e) in (<cache>((3,3)),<cache>((7,7)),<cache>((8,8))) and octet_length(t2.f) = 1" }, @@ -2716,10 +2716,10 @@ EXPLAIN "used_key_parts": ["e"] }, "rows": 7, - "selectivity_pct": 6.7308 + "selectivity_pct": 6.730769231 }, "rows": 7, - "filtered": 6.7308, + "filtered": 6.730769157, "index_condition": "t2.d is not null", "attached_condition": "(t2.d,t2.e) in (<cache>((4,4)),<cache>((7,7)),<cache>((8,8))) and octet_length(t2.f) = 1" }, diff --git a/mysql-test/main/range_mrr_icp.result b/mysql-test/main/range_mrr_icp.result index ee92d612889..d98f07d3272 100644 --- a/mysql-test/main/range_mrr_icp.result +++ b/mysql-test/main/range_mrr_icp.result @@ -2605,7 +2605,7 @@ EXPLAIN "key_length": "5", "used_key_parts": ["d"], "rows": 8, - "filtered": 14.423, + "filtered": 14.42307663, "index_condition": "t2.d is not null", "attached_condition": "(t2.d,t2.e) in (<cache>((3,3)),<cache>((7,7)),<cache>((8,8))) and octet_length(t2.f) = 1", "mrr_type": "Rowid-ordered scan" @@ -2703,7 +2703,7 @@ EXPLAIN "key_length": "5", "used_key_parts": ["d"], "rows": 7, - "filtered": 6.7308, + "filtered": 6.730769157, "index_condition": "t2.d is not null", "attached_condition": "(t2.d,t2.e) in (<cache>((4,4)),<cache>((7,7)),<cache>((8,8))) and octet_length(t2.f) = 1", "mrr_type": "Rowid-ordered scan" diff --git a/mysql-test/main/rowid_filter.result b/mysql-test/main/rowid_filter.result index 5ad252bb42d..6a5c41fd641 100644 --- a/mysql-test/main/rowid_filter.result +++ b/mysql-test/main/rowid_filter.result @@ -79,10 +79,10 @@ EXPLAIN "used_key_parts": ["l_quantity"] }, "rows": 702, - "selectivity_pct": 11.69 + "selectivity_pct": 11.69025812 }, "rows": 509, - "filtered": 11.69, + "filtered": 11.69025803, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" } @@ -115,9 +115,9 @@ ANALYZE "used_key_parts": ["l_quantity"] }, "rows": 702, - "selectivity_pct": 11.69, + "selectivity_pct": 11.69025812, "r_rows": 605, - "r_selectivity_pct": 3.6855, + "r_selectivity_pct": 3.685503686, "r_buffer_size": "REPLACED", "r_filling_time_ms": "REPLACED" }, @@ -126,7 +126,7 @@ ANALYZE "r_rows": 60, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 11.69, + "filtered": 11.69025803, "r_filtered": 100, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" @@ -217,7 +217,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_shipDATE"], "rows": 509, - "filtered": 11.69, + "filtered": 11.69025803, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" } @@ -249,8 +249,8 @@ ANALYZE "r_rows": 510, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 11.69, - "r_filtered": 11.765, + "filtered": 11.69025803, + "r_filtered": 11.76470588, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" } @@ -368,7 +368,7 @@ EXPLAIN "selectivity_pct": 4.6 }, "rows": 1, - "filtered": 4.6, + "filtered": 4.599999905, "attached_condition": "orders.o_totalprice between 200000 and 230000" } } @@ -427,16 +427,16 @@ ANALYZE "rows": 69, "selectivity_pct": 4.6, "r_rows": 71, - "r_selectivity_pct": 10.417, + "r_selectivity_pct": 10.41666667, "r_buffer_size": "REPLACED", "r_filling_time_ms": "REPLACED" }, "r_loops": 98, "rows": 1, - "r_rows": 0.1122, + "r_rows": 0.112244898, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 4.6, + "filtered": 4.599999905, "r_filtered": 100, "attached_condition": "orders.o_totalprice between 200000 and 230000" } @@ -498,7 +498,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, - "filtered": 4.6, + "filtered": 4.599999905, "attached_condition": "orders.o_totalprice between 200000 and 230000" } } @@ -554,8 +554,8 @@ ANALYZE "r_rows": 1, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 4.6, - "r_filtered": 11.224, + "filtered": 4.599999905, + "r_filtered": 11.2244898, "attached_condition": "orders.o_totalprice between 200000 and 230000" } } @@ -612,10 +612,10 @@ EXPLAIN "used_key_parts": ["l_quantity"] }, "rows": 702, - "selectivity_pct": 11.69 + "selectivity_pct": 11.69025812 }, "rows": 509, - "filtered": 11.69, + "filtered": 11.69025803, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" }, @@ -633,10 +633,10 @@ EXPLAIN "used_key_parts": ["o_totalprice"] }, "rows": 139, - "selectivity_pct": 9.2667 + "selectivity_pct": 9.266666667 }, "rows": 1, - "filtered": 9.2667, + "filtered": 9.266666412, "attached_condition": "orders.o_totalprice between 180000 and 230000" } } @@ -679,9 +679,9 @@ ANALYZE "used_key_parts": ["l_quantity"] }, "rows": 702, - "selectivity_pct": 11.69, + "selectivity_pct": 11.69025812, "r_rows": 605, - "r_selectivity_pct": 3.6855, + "r_selectivity_pct": 3.685503686, "r_buffer_size": "REPLACED", "r_filling_time_ms": "REPLACED" }, @@ -690,7 +690,7 @@ ANALYZE "r_rows": 60, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 11.69, + "filtered": 11.69025803, "r_filtered": 100, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" @@ -709,18 +709,18 @@ ANALYZE "used_key_parts": ["o_totalprice"] }, "rows": 139, - "selectivity_pct": 9.2667, + "selectivity_pct": 9.266666667, "r_rows": 144, - "r_selectivity_pct": 25.424, + "r_selectivity_pct": 25.42372881, "r_buffer_size": "REPLACED", "r_filling_time_ms": "REPLACED" }, "r_loops": 60, "rows": 1, - "r_rows": 0.2667, + "r_rows": 0.266666667, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 9.2667, + "filtered": 9.266666412, "r_filtered": 100, "attached_condition": "orders.o_totalprice between 180000 and 230000" } @@ -779,7 +779,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_shipDATE"], "rows": 509, - "filtered": 11.69, + "filtered": 11.69025803, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" }, @@ -792,7 +792,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, - "filtered": 9.2667, + "filtered": 9.266666412, "attached_condition": "orders.o_totalprice between 180000 and 230000" } } @@ -834,8 +834,8 @@ ANALYZE "r_rows": 510, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 11.69, - "r_filtered": 11.765, + "filtered": 11.69025803, + "r_filtered": 11.76470588, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" }, @@ -852,8 +852,8 @@ ANALYZE "r_rows": 1, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 9.2667, - "r_filtered": 26.667, + "filtered": 9.266666412, + "r_filtered": 26.66666667, "attached_condition": "orders.o_totalprice between 180000 and 230000" } } @@ -925,10 +925,10 @@ EXPLAIN "used_key_parts": ["l_shipDATE"] }, "rows": 509, - "selectivity_pct": 8.4763 + "selectivity_pct": 8.476269775 }, "rows": 4, - "filtered": 8.4763, + "filtered": 8.476269722, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } } @@ -985,18 +985,18 @@ ANALYZE "used_key_parts": ["l_shipDATE"] }, "rows": 509, - "selectivity_pct": 8.4763, + "selectivity_pct": 8.476269775, "r_rows": 510, - "r_selectivity_pct": 7.7731, + "r_selectivity_pct": 7.773109244, "r_buffer_size": "REPLACED", "r_filling_time_ms": "REPLACED" }, "r_loops": 71, "rows": 4, - "r_rows": 0.5211, + "r_rows": 0.521126761, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 8.4763, + "filtered": 8.476269722, "r_filtered": 100, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } @@ -1084,7 +1084,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 8.4763, + "filtered": 8.476269722, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } } @@ -1137,11 +1137,11 @@ ANALYZE "ref": ["dbt3_s001.orders.o_orderkey"], "r_loops": 71, "rows": 4, - "r_rows": 6.7042, + "r_rows": 6.704225352, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 8.4763, - "r_filtered": 7.7731, + "filtered": 8.476269722, + "r_filtered": 7.773109244, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } } @@ -1228,7 +1228,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_receiptDATE"], "rows": 18, - "filtered": 0.5662, + "filtered": 0.566194832, "index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-10-10'" }, @@ -1241,7 +1241,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, - "filtered": 7.4667, + "filtered": 7.466666698, "attached_condition": "orders.o_totalprice between 200000 and 250000" } } @@ -1285,8 +1285,8 @@ ANALYZE "r_rows": 18, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 0.5662, - "r_filtered": 38.889, + "filtered": 0.566194832, + "r_filtered": 38.88888889, "index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-10-10'" }, @@ -1303,8 +1303,8 @@ ANALYZE "r_rows": 1, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 7.4667, - "r_filtered": 14.286, + "filtered": 7.466666698, + "r_filtered": 14.28571429, "attached_condition": "orders.o_totalprice between 200000 and 250000" } } @@ -1350,7 +1350,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_receiptDATE"], "rows": 18, - "filtered": 0.5662, + "filtered": 0.566194832, "index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-10-10'" }, @@ -1363,7 +1363,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, - "filtered": 7.4667, + "filtered": 7.466666698, "attached_condition": "orders.o_totalprice between 200000 and 250000" } } @@ -1407,8 +1407,8 @@ ANALYZE "r_rows": 18, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 0.5662, - "r_filtered": 38.889, + "filtered": 0.566194832, + "r_filtered": 38.88888889, "index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-10-10'" }, @@ -1425,8 +1425,8 @@ ANALYZE "r_rows": 1, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 7.4667, - "r_filtered": 14.286, + "filtered": 7.466666698, + "r_filtered": 14.28571429, "attached_condition": "orders.o_totalprice between 200000 and 250000" } } @@ -1473,7 +1473,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 39, - "filtered": 3.2, + "filtered": 3.200000048, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" }, @@ -1491,7 +1491,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 3.0475, + "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1529,8 +1529,8 @@ ANALYZE "r_rows": 41, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.2, - "r_filtered": 2.439, + "filtered": 3.200000048, + "r_filtered": 2.43902439, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" }, @@ -1552,8 +1552,8 @@ ANALYZE "r_rows": 6, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.0475, - "r_filtered": 66.667, + "filtered": 3.047460556, + "r_filtered": 66.66666667, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1596,7 +1596,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 39, - "filtered": 3.2, + "filtered": 3.200000048, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" }, @@ -1614,7 +1614,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 3.0475, + "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1652,8 +1652,8 @@ ANALYZE "r_rows": 41, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.2, - "r_filtered": 2.439, + "filtered": 3.200000048, + "r_filtered": 2.43902439, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" }, @@ -1675,8 +1675,8 @@ ANALYZE "r_rows": 6, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.0475, - "r_filtered": 66.667, + "filtered": 3.047460556, + "r_filtered": 66.66666667, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1727,7 +1727,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 39, - "filtered": 1.9499, + "filtered": 1.949866652, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'" }, @@ -1745,7 +1745,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 3.0475, + "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1788,8 +1788,8 @@ ANALYZE "r_rows": 41, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 1.9499, - "r_filtered": 2.439, + "filtered": 1.949866652, + "r_filtered": 2.43902439, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'" }, @@ -1811,8 +1811,8 @@ ANALYZE "r_rows": 6, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.0475, - "r_filtered": 66.667, + "filtered": 3.047460556, + "r_filtered": 66.66666667, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1860,7 +1860,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 39, - "filtered": 1.9499, + "filtered": 1.949866652, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'" }, @@ -1878,7 +1878,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 3.0475, + "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1921,8 +1921,8 @@ ANALYZE "r_rows": 41, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 1.9499, - "r_filtered": 2.439, + "filtered": 1.949866652, + "r_filtered": 2.43902439, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'" }, @@ -1944,8 +1944,8 @@ ANALYZE "r_rows": 6, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.0475, - "r_filtered": 66.667, + "filtered": 3.047460556, + "r_filtered": 66.66666667, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } diff --git a/mysql-test/main/rowid_filter_innodb.result b/mysql-test/main/rowid_filter_innodb.result index ac4fe9f1534..67417c82b61 100644 --- a/mysql-test/main/rowid_filter_innodb.result +++ b/mysql-test/main/rowid_filter_innodb.result @@ -80,10 +80,10 @@ EXPLAIN "used_key_parts": ["l_quantity"] }, "rows": 605, - "selectivity_pct": 10.075 + "selectivity_pct": 10.07493755 }, "rows": 510, - "filtered": 10.075, + "filtered": 10.07493782, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" } @@ -116,9 +116,9 @@ ANALYZE "used_key_parts": ["l_quantity"] }, "rows": 605, - "selectivity_pct": 10.075, + "selectivity_pct": 10.07493755, "r_rows": 605, - "r_selectivity_pct": 11.765, + "r_selectivity_pct": 11.76470588, "r_buffer_size": "REPLACED", "r_filling_time_ms": "REPLACED" }, @@ -127,7 +127,7 @@ ANALYZE "r_rows": 60, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 10.075, + "filtered": 10.07493782, "r_filtered": 100, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" @@ -218,7 +218,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_shipDATE"], "rows": 510, - "filtered": 10.075, + "filtered": 10.07493782, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" } @@ -250,8 +250,8 @@ ANALYZE "r_rows": 510, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 10.075, - "r_filtered": 11.765, + "filtered": 10.07493782, + "r_filtered": 11.76470588, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" } @@ -362,7 +362,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, - "filtered": 4.7333, + "filtered": 4.733333111, "attached_condition": "orders.o_totalprice between 200000 and 230000" } } @@ -419,8 +419,8 @@ ANALYZE "r_rows": 1, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 4.7333, - "r_filtered": 11.224, + "filtered": 4.733333111, + "r_filtered": 11.2244898, "attached_condition": "orders.o_totalprice between 200000 and 230000" } } @@ -482,7 +482,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, - "filtered": 4.7333, + "filtered": 4.733333111, "attached_condition": "orders.o_totalprice between 200000 and 230000" } } @@ -539,8 +539,8 @@ ANALYZE "r_rows": 1, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 4.7333, - "r_filtered": 11.224, + "filtered": 4.733333111, + "r_filtered": 11.2244898, "attached_condition": "orders.o_totalprice between 200000 and 230000" } } @@ -597,10 +597,10 @@ EXPLAIN "used_key_parts": ["l_quantity"] }, "rows": 605, - "selectivity_pct": 10.075 + "selectivity_pct": 10.07493755 }, "rows": 510, - "filtered": 10.075, + "filtered": 10.07493782, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" }, @@ -613,7 +613,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, - "filtered": 9.6, + "filtered": 9.600000381, "attached_condition": "orders.o_totalprice between 180000 and 230000" } } @@ -656,9 +656,9 @@ ANALYZE "used_key_parts": ["l_quantity"] }, "rows": 605, - "selectivity_pct": 10.075, + "selectivity_pct": 10.07493755, "r_rows": 605, - "r_selectivity_pct": 11.765, + "r_selectivity_pct": 11.76470588, "r_buffer_size": "REPLACED", "r_filling_time_ms": "REPLACED" }, @@ -667,7 +667,7 @@ ANALYZE "r_rows": 60, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 10.075, + "filtered": 10.07493782, "r_filtered": 100, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" @@ -685,8 +685,8 @@ ANALYZE "r_rows": 1, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 9.6, - "r_filtered": 26.667, + "filtered": 9.600000381, + "r_filtered": 26.66666667, "attached_condition": "orders.o_totalprice between 180000 and 230000" } } @@ -757,7 +757,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 0.8557, + "filtered": 0.855656624, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30' and lineitem.l_quantity > 45" } } @@ -817,8 +817,8 @@ ANALYZE "r_rows": 6.625, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 0.8557, - "r_filtered": 1.6771, + "filtered": 0.855656624, + "r_filtered": 1.677148847, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30' and lineitem.l_quantity > 45" } } @@ -886,7 +886,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 8.4929, + "filtered": 8.492922783, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } } @@ -940,11 +940,11 @@ ANALYZE "ref": ["dbt3_s001.orders.o_orderkey"], "r_loops": 71, "rows": 4, - "r_rows": 6.7042, + "r_rows": 6.704225352, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 8.4929, - "r_filtered": 7.7731, + "filtered": 8.492922783, + "r_filtered": 7.773109244, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } } @@ -1032,7 +1032,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 8.4929, + "filtered": 8.492922783, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } } @@ -1086,11 +1086,11 @@ ANALYZE "ref": ["dbt3_s001.orders.o_orderkey"], "r_loops": 71, "rows": 4, - "r_rows": 6.7042, + "r_rows": 6.704225352, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 8.4929, - "r_filtered": 7.7731, + "filtered": 8.492922783, + "r_filtered": 7.773109244, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } } @@ -1177,7 +1177,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_receiptDATE"], "rows": 18, - "filtered": 0.5662, + "filtered": 0.566194832, "index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-10-10'" }, @@ -1190,7 +1190,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, - "filtered": 5.6667, + "filtered": 5.666666508, "attached_condition": "orders.o_totalprice between 200000 and 250000" } } @@ -1234,8 +1234,8 @@ ANALYZE "r_rows": 18, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 0.5662, - "r_filtered": 38.889, + "filtered": 0.566194832, + "r_filtered": 38.88888889, "index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-10-10'" }, @@ -1252,8 +1252,8 @@ ANALYZE "r_rows": 1, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 5.6667, - "r_filtered": 14.286, + "filtered": 5.666666508, + "r_filtered": 14.28571429, "attached_condition": "orders.o_totalprice between 200000 and 250000" } } @@ -1299,7 +1299,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_receiptDATE"], "rows": 18, - "filtered": 0.5662, + "filtered": 0.566194832, "index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-10-10'" }, @@ -1312,7 +1312,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, - "filtered": 5.6667, + "filtered": 5.666666508, "attached_condition": "orders.o_totalprice between 200000 and 250000" } } @@ -1356,8 +1356,8 @@ ANALYZE "r_rows": 18, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 0.5662, - "r_filtered": 38.889, + "filtered": 0.566194832, + "r_filtered": 38.88888889, "index_condition": "lineitem.l_receiptDATE between '1996-10-05' and '1996-10-10'", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-10-10'" }, @@ -1374,8 +1374,8 @@ ANALYZE "r_rows": 1, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 5.6667, - "r_filtered": 14.286, + "filtered": 5.666666508, + "r_filtered": 14.28571429, "attached_condition": "orders.o_totalprice between 200000 and 250000" } } @@ -1422,7 +1422,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 41, - "filtered": 3.3333, + "filtered": 3.333333254, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" }, @@ -1440,7 +1440,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 3.0475, + "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1478,8 +1478,8 @@ ANALYZE "r_rows": 41, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.3333, - "r_filtered": 2.439, + "filtered": 3.333333254, + "r_filtered": 2.43902439, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" }, @@ -1501,8 +1501,8 @@ ANALYZE "r_rows": 6, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.0475, - "r_filtered": 66.667, + "filtered": 3.047460556, + "r_filtered": 66.66666667, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1545,7 +1545,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 41, - "filtered": 3.3333, + "filtered": 3.333333254, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" }, @@ -1563,7 +1563,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 3.0475, + "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1601,8 +1601,8 @@ ANALYZE "r_rows": 41, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.3333, - "r_filtered": 2.439, + "filtered": 3.333333254, + "r_filtered": 2.43902439, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" }, @@ -1624,8 +1624,8 @@ ANALYZE "r_rows": 6, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.0475, - "r_filtered": 66.667, + "filtered": 3.047460556, + "r_filtered": 66.66666667, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1676,7 +1676,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 41, - "filtered": 2.0711, + "filtered": 2.071111202, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'" }, @@ -1694,7 +1694,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 3.0475, + "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1737,8 +1737,8 @@ ANALYZE "r_rows": 41, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 2.0711, - "r_filtered": 2.439, + "filtered": 2.071111202, + "r_filtered": 2.43902439, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'" }, @@ -1760,8 +1760,8 @@ ANALYZE "r_rows": 6, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.0475, - "r_filtered": 66.667, + "filtered": 3.047460556, + "r_filtered": 66.66666667, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1809,7 +1809,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 41, - "filtered": 2.0711, + "filtered": 2.071111202, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'" }, @@ -1827,7 +1827,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, - "filtered": 3.0475, + "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -1870,8 +1870,8 @@ ANALYZE "r_rows": 41, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 2.0711, - "r_filtered": 2.439, + "filtered": 2.071111202, + "r_filtered": 2.43902439, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'" }, @@ -1893,8 +1893,8 @@ ANALYZE "r_rows": 6, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 3.0475, - "r_filtered": 66.667, + "filtered": 3.047460556, + "r_filtered": 66.66666667, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } } @@ -2147,10 +2147,10 @@ EXPLAIN "used_key_parts": ["f1"] }, "rows": 1, - "selectivity_pct": 1.5873 + "selectivity_pct": 1.587301587 }, "rows": 1, - "filtered": 1.5873, + "filtered": 1.587301612, "index_condition": "t1.f1 is null", "attached_condition": "t1.f2 is null and (t1.f2 between 'a' and 'z' or t1.f1 = 'a')" } @@ -2174,10 +2174,10 @@ EXPLAIN "used_key_parts": ["f1"] }, "rows": 1, - "selectivity_pct": 1.5873 + "selectivity_pct": 1.587301587 }, "rows": 1, - "filtered": 1.5873, + "filtered": 1.587301612, "index_condition": "t1.f1 is null", "attached_condition": "t1.f2 is null and (t1.f2 between 'a' and 'z' or t1.f1 = 'a')" } @@ -2877,7 +2877,7 @@ ANALYZE "used_key_parts": ["fh"] }, "rows": 6, - "selectivity_pct": 17.143, + "selectivity_pct": 17.14285714, "r_rows": 5, "r_selectivity_pct": 40, "r_buffer_size": "REPLACED", @@ -2888,7 +2888,7 @@ ANALYZE "r_rows": 2, "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", - "filtered": 17.143, + "filtered": 17.1428566, "r_filtered": 100 }, "buffer_type": "incremental", diff --git a/sql/my_json_writer.cc b/sql/my_json_writer.cc index 0097eb6b658..ca519981b27 100644 --- a/sql/my_json_writer.cc +++ b/sql/my_json_writer.cc @@ -183,7 +183,7 @@ void Json_writer::add_double(double val) #if __has_feature(memory_sanitizer) // FIXME: remove this workaround for __msan_unpoison(&val, sizeof val); // main.range_mrr_icp & many other tests #endif - size_t len= my_snprintf(buf, sizeof(buf), "%lg", val); + size_t len= my_snprintf(buf, sizeof(buf), "%-.11lg", val); add_unquoted_str(buf, len); } |