diff options
Diffstat (limited to 'mysql-test/main/cte_recursive.result')
-rw-r--r-- | mysql-test/main/cte_recursive.result | 38 |
1 files changed, 19 insertions, 19 deletions
diff --git a/mysql-test/main/cte_recursive.result b/mysql-test/main/cte_recursive.result index 0dfc2df7b61..7ed8a30136a 100644 --- a/mysql-test/main/cte_recursive.result +++ b/mysql-test/main/cte_recursive.result @@ -1409,7 +1409,7 @@ EXPLAIN "filtered": 100 }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "686", "join_type": "BNL", "attached_condition": "prev_gen.father = folks.`id` or prev_gen.mother = folks.`id`" } @@ -1636,16 +1636,16 @@ i div 4 - (i % 4) = ps.i div 4 - (ps.i % 4) ) SELECT regexp_replace(board,concat('(',REPEAT('.', 4),')'),'\\1\n') n_queens FROM solutions WHERE n_queens = 4; n_queens --*-- ----* -*--- ---*- - --*- *--- ---* -*-- +-*-- +---* +*--- +--*- + # # MDEV-10883: execution of prepared statement from SELECT # with recursive CTE that renames columns @@ -3781,12 +3781,12 @@ where (dt.a1) in (with recursive cte as (select a2 from t2 where a2='2' select a2 from cte); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 3 -1 PRIMARY <subquery3> eq_ref distinct_key distinct_key 23 func 1 -3 MATERIALIZED <derived4> ALL NULL NULL NULL NULL 2 -4 DERIVED t2 const PRIMARY PRIMARY 22 const 1 Using index -5 RECURSIVE UNION <derived4> ALL NULL NULL NULL NULL 2 Using where -5 RECURSIVE UNION tt2 ref b1 b1 23 cte.a2 2 -NULL UNION RESULT <union4,5> ALL NULL NULL NULL NULL NULL +1 PRIMARY <subquery5> eq_ref distinct_key distinct_key 23 func 1 +5 MATERIALIZED <derived3> ALL NULL NULL NULL NULL 2 +3 DERIVED t2 const PRIMARY PRIMARY 22 const 1 Using index +4 RECURSIVE UNION <derived3> ALL NULL NULL NULL NULL 2 Using where +4 RECURSIVE UNION tt2 ref b1 b1 23 cte.a2 2 +NULL UNION RESULT <union3,4> ALL NULL NULL NULL NULL NULL analyze format=json select fv from (select t1.a1, f1(t1.a2) fv from t1) dt where (dt.a1) in (with recursive cte as (select a2 from t2 where a2='2' @@ -3810,7 +3810,7 @@ ANALYZE "r_filtered": 100 }, "table": { - "table_name": "<subquery3>", + "table_name": "<subquery5>", "access_type": "eq_ref", "possible_keys": ["distinct_key"], "key": "distinct_key", @@ -3826,9 +3826,9 @@ ANALYZE "materialized": { "unique": 1, "query_block": { - "select_id": 3, + "select_id": 5, "table": { - "table_name": "<derived4>", + "table_name": "<derived3>", "access_type": "ALL", "r_loops": 1, "rows": 2, @@ -3839,14 +3839,14 @@ ANALYZE "materialized": { "query_block": { "recursive_union": { - "table_name": "<union4,5>", + "table_name": "<union3,4>", "access_type": "ALL", "r_loops": 0, "r_rows": null, "query_specifications": [ { "query_block": { - "select_id": 4, + "select_id": 3, "r_loops": 1, "r_total_time_ms": "REPLACED", "table": { @@ -3868,12 +3868,12 @@ ANALYZE }, { "query_block": { - "select_id": 5, + "select_id": 4, "operation": "UNION", "r_loops": 1, "r_total_time_ms": "REPLACED", "table": { - "table_name": "<derived4>", + "table_name": "<derived3>", "access_type": "ALL", "r_loops": 1, "rows": 2, |