summaryrefslogtreecommitdiff
path: root/mysql-test/r/cte_recursive.result
diff options
context:
space:
mode:
authorSergei Petrunia <psergey@askmonty.org>2017-01-18 14:13:11 +0300
committerSergei Petrunia <psergey@askmonty.org>2017-01-18 14:13:11 +0300
commit25e5ce198228b4e9ca74015c7d320eb9c618d86b (patch)
treeee7d362c9c72a4fd8f82faf1eafb975c299e1112 /mysql-test/r/cte_recursive.result
parent9ea0b44c5696d9357465625c3fc9b7f57a856009 (diff)
downloadmariadb-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.
Diffstat (limited to 'mysql-test/r/cte_recursive.result')
-rw-r--r--mysql-test/r/cte_recursive.result65
1 files changed, 0 insertions, 65 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"
- }
- }
- }
- ]
- }
- }
- }
- }
- }
-}