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 06c2345cdde0aae57a517fee3051287502730117 Author: Zhang Mingli <[email protected]> AuthorDate: Wed Apr 19 08:04:49 2023 +0800 Fix typo. at the memont -> at the moment. Authored-by: Zhang Mingli [email protected] --- src/test/regress/expected/subselect_gp_indexes.out | 2 +- src/test/regress/expected/subselect_gp_indexes_optimizer.out | 2 +- src/test/regress/sql/subselect_gp_indexes.sql | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/test/regress/expected/subselect_gp_indexes.out b/src/test/regress/expected/subselect_gp_indexes.out index 4e11b3d83a..350a53f350 100644 --- a/src/test/regress/expected/subselect_gp_indexes.out +++ b/src/test/regress/expected/subselect_gp_indexes.out @@ -122,7 +122,7 @@ explain select t1.id1, (select count(*) from choose_seqscan_t2 t2 where t2.id1 = (12 rows) -- Test using a join within the subplan. It could perhaps use an Nested Loop Join + --- Index Scan to do the join, but at the memont, the planner doesn't consider distributing +-- Index Scan to do the join, but at the moment, the planner doesn't consider distributing -- the Function Scan. select t1.id1, (select count(*) from generate_series(1,5) g, choose_seqscan_t2 t2 where t1.id1 = t2.id1 and t2.id2 = g) from choose_seqscan_t1 t1 where t1.id1 < 10; id1 | count diff --git a/src/test/regress/expected/subselect_gp_indexes_optimizer.out b/src/test/regress/expected/subselect_gp_indexes_optimizer.out index f1c20bc959..543828264f 100644 --- a/src/test/regress/expected/subselect_gp_indexes_optimizer.out +++ b/src/test/regress/expected/subselect_gp_indexes_optimizer.out @@ -119,7 +119,7 @@ explain select t1.id1, (select count(*) from choose_seqscan_t2 t2 where t2.id1 = (13 rows) -- Test using a join within the subplan. It could perhaps use an Nested Loop Join + --- Index Scan to do the join, but at the memont, the planner doesn't consider distributing +-- Index Scan to do the join, but at the moment, the planner doesn't consider distributing -- the Function Scan. select t1.id1, (select count(*) from generate_series(1,5) g, choose_seqscan_t2 t2 where t1.id1 = t2.id1 and t2.id2 = g) from choose_seqscan_t1 t1 where t1.id1 < 10; id1 | count diff --git a/src/test/regress/sql/subselect_gp_indexes.sql b/src/test/regress/sql/subselect_gp_indexes.sql index 382f30f2bb..1b148cbfe1 100644 --- a/src/test/regress/sql/subselect_gp_indexes.sql +++ b/src/test/regress/sql/subselect_gp_indexes.sql @@ -25,7 +25,7 @@ select t1.id1, (select count(*) from choose_seqscan_t2 t2 where t2.id1 = t1.id1 explain select t1.id1, (select count(*) from choose_seqscan_t2 t2 where t2.id1 = t1.id1 and t2.id2 = 1) from choose_seqscan_t1 t1 where t1.id1 < 10; -- Test using a join within the subplan. It could perhaps use an Nested Loop Join + --- Index Scan to do the join, but at the memont, the planner doesn't consider distributing +-- Index Scan to do the join, but at the moment, the planner doesn't consider distributing -- the Function Scan. select t1.id1, (select count(*) from generate_series(1,5) g, choose_seqscan_t2 t2 where t1.id1 = t2.id1 and t2.id2 = g) from choose_seqscan_t1 t1 where t1.id1 < 10; explain select t1.id1, (select count(*) from generate_series(1,5) g, choose_seqscan_t2 t2 where t1.id1 = t2.id1 and t2.id2 = g) from choose_seqscan_t1 t1 where t1.id1 < 10; --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
