diff options
Diffstat (limited to 'mysql-test/main/rowid_filter_innodb.result')
-rw-r--r-- | mysql-test/main/rowid_filter_innodb.result | 88 |
1 files changed, 88 insertions, 0 deletions
diff --git a/mysql-test/main/rowid_filter_innodb.result b/mysql-test/main/rowid_filter_innodb.result index db2e4052a21..b3b34710888 100644 --- a/mysql-test/main/rowid_filter_innodb.result +++ b/mysql-test/main/rowid_filter_innodb.result @@ -80,6 +80,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -98,6 +99,7 @@ EXPLAIN "selectivity_pct": 10.07493755 }, "rows": 510, + "cost": "COST_REPLACED", "filtered": 10.07493782, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" @@ -121,6 +123,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -148,6 +151,7 @@ ANALYZE "r_loops": 1, "rows": 510, "r_rows": 60, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 10.07493782, @@ -235,6 +239,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -245,6 +250,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_shipDATE"], "rows": 510, + "cost": "COST_REPLACED", "filtered": 10.07493782, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" @@ -268,6 +274,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -282,6 +289,7 @@ ANALYZE "r_loops": 1, "rows": 510, "r_rows": 510, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 10.07493782, @@ -372,6 +380,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -387,6 +396,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_shipDATE"], "rows": 98, + "cost": "COST_REPLACED", "filtered": 100, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-01-31'", "using_index": true @@ -402,6 +412,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, + "cost": "COST_REPLACED", "filtered": 4.733333111, "attached_condition": "orders.o_totalprice between 200000 and 230000" } @@ -427,6 +438,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -446,6 +458,7 @@ ANALYZE "r_loops": 1, "rows": 98, "r_rows": 98, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 100, @@ -466,6 +479,7 @@ ANALYZE "r_loops": 98, "rows": 1, "r_rows": 1, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 4.733333111, @@ -507,6 +521,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -522,6 +537,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_shipDATE"], "rows": 98, + "cost": "COST_REPLACED", "filtered": 100, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-01-31'", "using_index": true @@ -537,6 +553,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, + "cost": "COST_REPLACED", "filtered": 4.733333111, "attached_condition": "orders.o_totalprice between 200000 and 230000" } @@ -562,6 +579,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -581,6 +599,7 @@ ANALYZE "r_loops": 1, "rows": 98, "r_rows": 98, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 100, @@ -601,6 +620,7 @@ ANALYZE "r_loops": 98, "rows": 1, "r_rows": 1, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 4.733333111, @@ -644,6 +664,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -668,6 +689,7 @@ EXPLAIN "selectivity_pct": 10.07493755 }, "rows": 510, + "cost": "COST_REPLACED", "filtered": 10.07493782, "index_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'", "attached_condition": "lineitem.l_quantity > 45" @@ -683,6 +705,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, + "cost": "COST_REPLACED", "filtered": 9.600000381, "attached_condition": "orders.o_totalprice between 180000 and 230000" } @@ -710,6 +733,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -743,6 +767,7 @@ ANALYZE "r_loops": 1, "rows": 510, "r_rows": 60, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 10.07493782, @@ -763,6 +788,7 @@ ANALYZE "r_loops": 60, "rows": 1, "r_rows": 1, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 9.600000381, @@ -812,6 +838,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -822,6 +849,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totalprice"], "rows": 144, + "cost": "COST_REPLACED", "filtered": 100, "attached_condition": "orders.o_totalprice between 180000 and 230000", "using_index": true @@ -843,6 +871,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, + "cost": "COST_REPLACED", "filtered": 0.855656624, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30' and lineitem.l_quantity > 45" } @@ -870,6 +899,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -884,6 +914,7 @@ ANALYZE "r_loops": 1, "rows": 144, "r_rows": 144, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 100, @@ -910,6 +941,7 @@ ANALYZE "r_loops": 144, "rows": 4, "r_rows": 6.625, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 0.855656624, @@ -965,6 +997,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -975,6 +1008,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totalprice"], "rows": 71, + "cost": "COST_REPLACED", "filtered": 100, "attached_condition": "orders.o_totalprice between 200000 and 230000", "using_index": true @@ -995,6 +1029,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, + "cost": "COST_REPLACED", "filtered": 8.492922783, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } @@ -1020,6 +1055,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -1034,6 +1070,7 @@ ANALYZE "r_loops": 1, "rows": 71, "r_rows": 71, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 100, @@ -1059,6 +1096,7 @@ ANALYZE "r_loops": 71, "rows": 4, "r_rows": 6.704225352, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 8.492922783, @@ -1126,6 +1164,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -1136,6 +1175,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totalprice"], "rows": 71, + "cost": "COST_REPLACED", "filtered": 100, "attached_condition": "orders.o_totalprice between 200000 and 230000", "using_index": true @@ -1156,6 +1196,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, + "cost": "COST_REPLACED", "filtered": 8.492922783, "attached_condition": "lineitem.l_shipDATE between '1997-01-01' and '1997-06-30'" } @@ -1181,6 +1222,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -1195,6 +1237,7 @@ ANALYZE "r_loops": 1, "rows": 71, "r_rows": 71, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 100, @@ -1220,6 +1263,7 @@ ANALYZE "r_loops": 71, "rows": 4, "r_rows": 6.704225352, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 8.492922783, @@ -1298,6 +1342,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -1314,6 +1359,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_receiptDATE"], "rows": 18, + "cost": "COST_REPLACED", "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'" @@ -1329,6 +1375,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, + "cost": "COST_REPLACED", "filtered": 5.666666508, "attached_condition": "orders.o_totalprice between 200000 and 250000" } @@ -1358,6 +1405,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -1378,6 +1426,7 @@ ANALYZE "r_loops": 1, "rows": 18, "r_rows": 18, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 0.566194832, @@ -1398,6 +1447,7 @@ ANALYZE "r_loops": 7, "rows": 1, "r_rows": 1, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 5.666666508, @@ -1435,6 +1485,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -1451,6 +1502,7 @@ EXPLAIN "key_length": "4", "used_key_parts": ["l_receiptDATE"], "rows": 18, + "cost": "COST_REPLACED", "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'" @@ -1466,6 +1518,7 @@ EXPLAIN "used_key_parts": ["o_orderkey"], "ref": ["dbt3_s001.lineitem.l_orderkey"], "rows": 1, + "cost": "COST_REPLACED", "filtered": 5.666666508, "attached_condition": "orders.o_totalprice between 200000 and 250000" } @@ -1495,6 +1548,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -1515,6 +1569,7 @@ ANALYZE "r_loops": 1, "rows": 18, "r_rows": 18, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 0.566194832, @@ -1535,6 +1590,7 @@ ANALYZE "r_loops": 7, "rows": 1, "r_rows": 1, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 5.666666508, @@ -1579,6 +1635,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -1589,6 +1646,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 41, + "cost": "COST_REPLACED", "filtered": 3.333333254, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" @@ -1609,6 +1667,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, + "cost": "COST_REPLACED", "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } @@ -1638,6 +1697,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -1652,6 +1712,7 @@ ANALYZE "r_loops": 1, "rows": 41, "r_rows": 41, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 3.333333254, @@ -1677,6 +1738,7 @@ ANALYZE "r_loops": 1, "rows": 4, "r_rows": 6, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 3.047460556, @@ -1717,6 +1779,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -1727,6 +1790,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 41, + "cost": "COST_REPLACED", "filtered": 3.333333254, "index_condition": "orders.o_totaldiscount between 18000 and 20000", "attached_condition": "orders.o_totalprice between 200000 and 220000" @@ -1747,6 +1811,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, + "cost": "COST_REPLACED", "filtered": 3.047460556, "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } @@ -1776,6 +1841,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -1790,6 +1856,7 @@ ANALYZE "r_loops": 1, "rows": 41, "r_rows": 41, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 3.333333254, @@ -1815,6 +1882,7 @@ ANALYZE "r_loops": 1, "rows": 4, "r_rows": 6, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 3.047460556, @@ -1858,6 +1926,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "REPLACED", "nested_loop": [ { "table": { @@ -1873,6 +1942,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 41, + "cost": "REPLACED", "filtered": "REPLACED", "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,6 +1963,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, + "cost": "REPLACED", "filtered": "REPLACED", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } @@ -1922,6 +1993,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -1941,6 +2013,7 @@ ANALYZE "r_loops": 1, "rows": 41, "r_rows": 41, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": "REPLACED", @@ -1966,6 +2039,7 @@ ANALYZE "r_loops": 1, "rows": 4, "r_rows": 6, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": "REPLACED", @@ -2006,6 +2080,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "REPLACED", "nested_loop": [ { "table": { @@ -2021,6 +2096,7 @@ EXPLAIN "key_length": "9", "used_key_parts": ["o_totaldiscount"], "rows": 41, + "cost": "REPLACED", "filtered": "REPLACED", "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'" @@ -2041,6 +2117,7 @@ EXPLAIN "used_key_parts": ["l_orderkey"], "ref": ["dbt3_s001.orders.o_orderkey"], "rows": 4, + "cost": "REPLACED", "filtered": "REPLACED", "attached_condition": "lineitem.l_shipDATE between '1996-10-01' and '1996-12-01'" } @@ -2070,6 +2147,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -2089,6 +2167,7 @@ ANALYZE "r_loops": 1, "rows": 41, "r_rows": 41, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": "REPLACED", @@ -2114,6 +2193,7 @@ ANALYZE "r_loops": 1, "rows": 4, "r_rows": 6, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": "REPLACED", @@ -2199,6 +2279,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -2218,6 +2299,7 @@ EXPLAIN "selectivity_pct": 1.587301587 }, "rows": 1, + "cost": "COST_REPLACED", "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')" @@ -2230,6 +2312,7 @@ EXPLAIN "query_block": { "select_id": 2, "operation": "UNION", + "cost": "COST_REPLACED", "nested_loop": [ { "table": { @@ -2249,6 +2332,7 @@ EXPLAIN "selectivity_pct": 1.587301587 }, "rows": 1, + "cost": "COST_REPLACED", "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')" @@ -3203,6 +3287,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "nested_loop": [ @@ -3231,6 +3316,7 @@ ANALYZE "r_loops": 1, "rows": 2, "r_rows": 3, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 100, @@ -3252,6 +3338,7 @@ ANALYZE "r_loops": 1, "rows": 1, "r_rows": 3, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 100, @@ -3292,6 +3379,7 @@ ANALYZE "r_loops": 1, "rows": 24, "r_rows": 32, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "filtered": 14.46428585, |