Changeset: c2dd4b448afb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/c2dd4b448afb
Modified Files:
sql/server/rel_optimize_proj.c
sql/test/cte/Tests/All
Branch: recursive_cte
Log Message:
handle nesting of recursive unions
diffs (24 lines):
diff --git a/sql/server/rel_optimize_proj.c b/sql/server/rel_optimize_proj.c
--- a/sql/server/rel_optimize_proj.c
+++ b/sql/server/rel_optimize_proj.c
@@ -3206,6 +3206,8 @@ rel_push_join_down_munion(visitor *v, sq
list *exps = rel->exps, *attr = rel->attr;
sql_exp *je = NULL;
+ if (is_recursive(l) || is_recursive(r))
+ return rel;
/* we would like to optimize in place reference rels which point
* to replica tables and let the replica optimizer handle those
* later. otherwise we miss the push join down optimization due
diff --git a/sql/test/cte/Tests/All b/sql/test/cte/Tests/All
--- a/sql/test/cte/Tests/All
+++ b/sql/test/cte/Tests/All
@@ -11,7 +11,7 @@ test_cte_in_cte
test_cte_overflow
test_cte
test_issue_5673
-#test_nested_recursive_cte
+test_nested_recursive_cte
test_outer_joins_recursive_cte
test_recursive_cte_tutorial
test_recursive_cte_union_all
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
