This is an automated email from the ASF dual-hosted git repository. avamingli pushed a commit to branch main in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit e24b737aa6aa33d95e2be9d5c967a8a2d8ac064d Author: Zhang Mingli <[email protected]> AuthorDate: Mon Dec 30 19:57:31 2024 +0800 Fix test cases of cherry-pick. --- src/test/regress/expected/gp_recursive_cte.out | 1 + src/test/regress/expected/with_optimizer.out | 6 +++--- src/test/singlenode_regress/expected/with.out | 6 +++--- 3 files changed, 7 insertions(+), 6 deletions(-) diff --git a/src/test/regress/expected/gp_recursive_cte.out b/src/test/regress/expected/gp_recursive_cte.out index 00b08e4b84..e0f47dac81 100644 --- a/src/test/regress/expected/gp_recursive_cte.out +++ b/src/test/regress/expected/gp_recursive_cte.out @@ -770,6 +770,7 @@ select id,name from cte; 4 | AAA>B1>C1_2 5 | AAA>B1>C1_3 (9 rows) + -- WTIH RECURSIVE and subquery with recursive cte (n) as ( diff --git a/src/test/regress/expected/with_optimizer.out b/src/test/regress/expected/with_optimizer.out index fa150c6aa5..ec7b6c6ce8 100644 --- a/src/test/regress/expected/with_optimizer.out +++ b/src/test/regress/expected/with_optimizer.out @@ -1964,9 +1964,9 @@ WITH RECURSIVE foo(i) AS UNION ALL SELECT i+1 FROM foo WHERE i < 5) AS t ) SELECT * FROM foo; -ERROR: recursive reference to query "foo" must not appear within a subquery -LINE 5: (SELECT i+1 FROM foo WHERE i < 10 - ^ +ERROR: recursive reference to query "foo" must not appear more than once +LINE 7: SELECT i+1 FROM foo WHERE i < 5) AS t + ^ WITH RECURSIVE foo(i) AS (values (1) UNION ALL diff --git a/src/test/singlenode_regress/expected/with.out b/src/test/singlenode_regress/expected/with.out index 886674bcf5..a583889351 100644 --- a/src/test/singlenode_regress/expected/with.out +++ b/src/test/singlenode_regress/expected/with.out @@ -1948,9 +1948,9 @@ WITH RECURSIVE foo(i) AS UNION ALL SELECT i+1 FROM foo WHERE i < 5) AS t ) SELECT * FROM foo; -ERROR: recursive reference to query "foo" must not appear within a subquery -LINE 5: (SELECT i+1 FROM foo WHERE i < 10 - ^ +ERROR: recursive reference to query "foo" must not appear more than once +LINE 7: SELECT i+1 FROM foo WHERE i < 5) AS t + ^ WITH RECURSIVE foo(i) AS (values (1) UNION ALL --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
