diff options
Diffstat (limited to 'mysql-test/main/win.result')
| -rw-r--r-- | mysql-test/main/win.result | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/mysql-test/main/win.result b/mysql-test/main/win.result index 1c3be0bd..93652834 100644 --- a/mysql-test/main/win.result +++ b/mysql-test/main/win.result @@ -1402,6 +1402,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "window_functions_computation": { "sorts": [ { @@ -1416,7 +1417,9 @@ EXPLAIN "table": { "table_name": "t0", "access_type": "ALL", + "loops": 1, "rows": 10, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -1437,6 +1440,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "filesort": { "sort_key": "t1.a", "window_functions_computation": { @@ -1453,7 +1457,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 10, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -1474,6 +1480,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "window_functions_computation": { "sorts": [ { @@ -1488,7 +1495,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 10, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -1511,6 +1520,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "having_condition": "MX in (3,5,7)", "filesort": { "sort_key": "t1.b", @@ -1528,7 +1538,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 10, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -1665,6 +1677,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "window_functions_computation": { "sorts": [ { @@ -1679,7 +1692,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -1697,6 +1712,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "window_functions_computation": { "sorts": [ { @@ -1711,7 +1727,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -1729,6 +1747,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "window_functions_computation": { "sorts": [ { @@ -1743,7 +1762,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -1761,6 +1782,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "window_functions_computation": { "sorts": [ { @@ -1775,7 +1797,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -1821,6 +1845,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "filesort": { "sort_key": "row_number() over ( order by t1.s1,t1.s2) desc", "window_functions_computation": { @@ -1837,7 +1862,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 6, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -1981,6 +2008,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "duplicate_removal": { "window_functions_computation": { "sorts": [ @@ -1996,7 +2024,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 9, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -2161,6 +2191,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "window_functions_computation": { "sorts": [ { @@ -2175,7 +2206,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 11, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -2228,6 +2261,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "window_functions_computation": { "sorts": [ { @@ -2242,7 +2276,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 6, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -3827,6 +3863,7 @@ ANALYZE }, "query_block": { "select_id": 1, + "cost": "REPLACED", "r_loops": 1, "r_total_time_ms": "REPLACED", "window_functions_computation": { @@ -3849,9 +3886,11 @@ ANALYZE "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 3, "r_rows": 3, + "cost": "REPLACED", "r_table_time_ms": "REPLACED", "r_other_time_ms": "REPLACED", "r_engine_stats": REPLACED, |