diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2017-01-18 14:13:11 +0300 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2017-01-18 14:13:11 +0300 |
commit | 25e5ce198228b4e9ca74015c7d320eb9c618d86b (patch) | |
tree | ee7d362c9c72a4fd8f82faf1eafb975c299e1112 | |
parent | 9ea0b44c5696d9357465625c3fc9b7f57a856009 (diff) | |
download | mariadb-git-25e5ce198228b4e9ca74015c7d320eb9c618d86b.tar.gz |
NOT FIXED: MDEV-10773: ANALYZE FORMAT=JSON query_with_CTE crashes
Remove the testcase. It turns out, the crash still happens, just not
on all platforms.
-rw-r--r-- | mysql-test/r/cte_recursive.result | 65 | ||||
-rw-r--r-- | mysql-test/t/cte_recursive.test | 12 |
2 files changed, 0 insertions, 77 deletions
diff --git a/mysql-test/r/cte_recursive.result b/mysql-test/r/cte_recursive.result index e68d5a38283..d5476aec1c4 100644 --- a/mysql-test/r/cte_recursive.result +++ b/mysql-test/r/cte_recursive.result @@ -2343,68 +2343,3 @@ select id + 1, uuid() from data_generator where id < 150000 select * from data_generator ) as a; drop table t1; -# -# MDEV-10773: ANALYZE FORMAT=JSON query_with_CTE crashes -# -analyze format=json -with recursive src(counter) as -(select 1 -union -select counter+1 from src where counter<10 -) select * from src; -ANALYZE -{ - "query_block": { - "select_id": 1, - "r_loops": 1, - "r_total_time_ms": "REPLACED", - "table": { - "table_name": "<derived2>", - "access_type": "ALL", - "r_loops": 1, - "rows": 2, - "r_rows": 10, - "r_total_time_ms": "REPLACED"e-4, - "filtered": 100, - "r_filtered": 100, - "materialized": { - "query_block": { - "recursive_union": { - "table_name": "<union2,3>", - "access_type": "ALL", - "r_loops": 0, - "r_rows": null, - "query_specifications": [ - { - "query_block": { - "select_id": 2, - "table": { - "message": "No tables used" - } - } - }, - { - "query_block": { - "select_id": 3, - "r_loops": 10, - "r_total_time_ms": "REPLACED", - "table": { - "table_name": "<derived2>", - "access_type": "ALL", - "r_loops": 10, - "rows": 2, - "r_rows": 1, - "r_total_time_ms": "REPLACED", - "filtered": 100, - "r_filtered": 90, - "attached_condition": "src.counter < 10" - } - } - } - ] - } - } - } - } - } -} diff --git a/mysql-test/t/cte_recursive.test b/mysql-test/t/cte_recursive.test index bb57a8600b6..ea0f73be259 100644 --- a/mysql-test/t/cte_recursive.test +++ b/mysql-test/t/cte_recursive.test @@ -1505,15 +1505,3 @@ select id, test_data ) as a; drop table t1; - ---echo # ---echo # MDEV-10773: ANALYZE FORMAT=JSON query_with_CTE crashes ---echo # ---replace_regex /"r_total_time_ms": [0-9]*[.]?[0-9]*/"r_total_time_ms": "REPLACED"/ -analyze format=json -with recursive src(counter) as -(select 1 - union - select counter+1 from src where counter<10 -) select * from src; - |