Changeset: cb648d85fce3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cb648d85fce3 Modified Files: sql/test/cte/Tests/All sql/test/cte/Tests/test_outer_joins_recursive_cte.test Branch: recursive_cte Log Message:
corrected test for outer joins diffs (24 lines): 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 @@ -12,7 +12,7 @@ test_cte_overflow test_cte test_issue_5673 #test_nested_recursive_cte -#test_outer_joins_recursive_cte +test_outer_joins_recursive_cte test_recursive_cte_tutorial test_recursive_cte_union_all test_recursive_cte_union diff --git a/sql/test/cte/Tests/test_outer_joins_recursive_cte.test b/sql/test/cte/Tests/test_outer_joins_recursive_cte.test --- a/sql/test/cte/Tests/test_outer_joins_recursive_cte.test +++ b/sql/test/cte/Tests/test_outer_joins_recursive_cte.test @@ -14,7 +14,7 @@ WITH RECURSIVE t(x) AS SELECT x + 1 FROM (SELECT t.x+1 FROM v AS _(p) FULL OUTER JOIN t ON t.x = p) AS _(x) WHERE x < 10 -) SELECT * FROM v AS _(p) RIGHT OUTER JOIN t ON t.x = p ORDER BY p, t.x NULLS LAST; +) SELECT * FROM v AS _(p) RIGHT OUTER JOIN t ON t.x = p ORDER BY p NULLS LAST, t.x; ---- 1 1 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
