This is an automated email from the ASF dual-hosted git repository.
chenjinbao1989 pushed a commit to branch cbdb-postgres-merge
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/cbdb-postgres-merge by this
push:
new 4e96881044c Fix answer file for create_index_spgist
4e96881044c is described below
commit 4e96881044c207436a67a2eb37f753fac5cd021c
Author: Jinbao Chen <[email protected]>
AuthorDate: Fri Nov 7 22:42:17 2025 +0800
Fix answer file for create_index_spgist
---
src/test/regress/expected/create_index_spgist.out | 35 ++++++++++++-----------
src/test/regress/serial_schedule | 2 +-
src/test/regress/sql/create_index_spgist.sql | 5 +---
3 files changed, 20 insertions(+), 22 deletions(-)
diff --git a/src/test/regress/expected/create_index_spgist.out
b/src/test/regress/expected/create_index_spgist.out
index 2b964a52683..1db07bdebc5 100644
--- a/src/test/regress/expected/create_index_spgist.out
+++ b/src/test/regress/expected/create_index_spgist.out
@@ -924,13 +924,15 @@ SELECT count(*) FROM radix_text_tbl WHERE t ^@
'Worth';
EXPLAIN (COSTS OFF)
SELECT count(*) FROM radix_text_tbl WHERE starts_with(t, 'Worth');
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------------------
Aggregate
- -> Index Only Scan using sp_radix_ind on radix_text_tbl
- Index Cond: (t ^@ 'Worth'::text)
- Filter: starts_with(t, 'Worth'::text)
-(4 rows)
+ -> Gather Motion 3:1 (slice1; segments: 3)
+ -> Index Only Scan using sp_radix_ind on radix_text_tbl
+ Index Cond: (t ^@ 'Worth'::text)
+ Filter: starts_with(t, 'Worth'::text)
+ Optimizer: Postgres query optimizer
+(6 rows)
SELECT count(*) FROM radix_text_tbl WHERE starts_with(t, 'Worth');
count
@@ -1554,19 +1556,18 @@ SELECT count(*) FROM radix_text_tbl WHERE t ^@
'Worth';
2
(1 row)
-<<<<<<< HEAD
-RESET optimizer_enable_tablescan;
-=======
EXPLAIN (COSTS OFF)
SELECT count(*) FROM radix_text_tbl WHERE starts_with(t, 'Worth');
- QUERY PLAN
-------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Aggregate
- -> Bitmap Heap Scan on radix_text_tbl
- Filter: starts_with(t, 'Worth'::text)
- -> Bitmap Index Scan on sp_radix_ind
- Index Cond: (t ^@ 'Worth'::text)
-(5 rows)
+ -> Gather Motion 3:1 (slice1; segments: 3)
+ -> Bitmap Heap Scan on radix_text_tbl
+ Filter: starts_with(t, 'Worth'::text)
+ -> Bitmap Index Scan on sp_radix_ind
+ Index Cond: (t ^@ 'Worth'::text)
+ Optimizer: Postgres query optimizer
+(7 rows)
SELECT count(*) FROM radix_text_tbl WHERE starts_with(t, 'Worth');
count
@@ -1574,7 +1575,7 @@ SELECT count(*) FROM radix_text_tbl WHERE starts_with(t,
'Worth');
2
(1 row)
->>>>>>> REL_16_9
+RESET optimizer_enable_tablescan;
RESET enable_seqscan;
RESET enable_indexscan;
RESET enable_bitmapscan;
diff --git a/src/test/regress/serial_schedule b/src/test/regress/serial_schedule
index 7b992b969e9..340912d0818 100644
--- a/src/test/regress/serial_schedule
+++ b/src/test/regress/serial_schedule
@@ -66,7 +66,7 @@ test: create_misc
test: create_operator
test: create_procedure
test: create_index
-# test: create_index_spgist
+test: create_index_spgist
# test: create_view
# test: index_including
# test: index_including_gist
diff --git a/src/test/regress/sql/create_index_spgist.sql
b/src/test/regress/sql/create_index_spgist.sql
index 374e3a34b33..2abe625f5dd 100644
--- a/src/test/regress/sql/create_index_spgist.sql
+++ b/src/test/regress/sql/create_index_spgist.sql
@@ -431,14 +431,11 @@ EXPLAIN (COSTS OFF)
SELECT count(*) FROM radix_text_tbl WHERE t ^@ 'Worth';
SELECT count(*) FROM radix_text_tbl WHERE t ^@ 'Worth';
-<<<<<<< HEAD
-RESET optimizer_enable_tablescan;
-=======
EXPLAIN (COSTS OFF)
SELECT count(*) FROM radix_text_tbl WHERE starts_with(t, 'Worth');
SELECT count(*) FROM radix_text_tbl WHERE starts_with(t, 'Worth');
->>>>>>> REL_16_9
+RESET optimizer_enable_tablescan;
RESET enable_seqscan;
RESET enable_indexscan;
RESET enable_bitmapscan;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
