This is an automated email from the ASF dual-hosted git repository. reshke pushed a commit to branch main in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit 7a2b1360d4775e341763a3e9d79412381b7cb2f2 Author: Soumyadeep Chakraborty <[email protected]> AuthorDate: Tue Aug 15 16:00:16 2023 -0700 Update ORCA ans files for index costing change With the planner cost model changes introduced in 167a67f7f82, two ORCA answer files were missed. ORCA falls back to planner in these files, and a similar plan diff needs to be incorporated. --- src/test/regress/expected/select_optimizer.out | 16 ++++++---------- 1 file changed, 6 insertions(+), 10 deletions(-) diff --git a/src/test/regress/expected/select_optimizer.out b/src/test/regress/expected/select_optimizer.out index 9a3592bea0..a40e6fa177 100644 --- a/src/test/regress/expected/select_optimizer.out +++ b/src/test/regress/expected/select_optimizer.out @@ -887,19 +887,15 @@ RESET enable_indexscan; explain (costs off) select unique1, unique2 from onek2 where (unique2 = 11 or unique1 = 0) and stringu1 < 'B'; - QUERY PLAN --------------------------------------------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Gather Motion 3:1 (slice1; segments: 3) -> Bitmap Heap Scan on onek2 - Recheck Cond: (((unique2 = 11) AND (stringu1 < 'B'::name)) OR (unique1 = 0)) - Filter: (stringu1 < 'B'::name) - -> BitmapOr - -> Bitmap Index Scan on onek2_u2_prtl - Index Cond: (unique2 = 11) - -> Bitmap Index Scan on onek2_u1_prtl - Index Cond: (unique1 = 0) + Recheck Cond: (stringu1 < 'B'::name) + Filter: ((unique2 = 11) OR (unique1 = 0)) + -> Bitmap Index Scan on onek2_u2_prtl Optimizer: Postgres query optimizer -(10 rows) +(6 rows) select unique1, unique2 from onek2 where (unique2 = 11 or unique1 = 0) and stringu1 < 'B'; --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
