This is an automated email from the ASF dual-hosted git repository.
oppenheimer01 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 6e9a47bf945 Fix answer file for pg_trgm
6e9a47bf945 is described below
commit 6e9a47bf9453f02a6476f8719ed4ab343d81ef0a
Author: Jinbao Chen <[email protected]>
AuthorDate: Mon May 4 11:07:20 2026 -0400
Fix answer file for pg_trgm
---
contrib/pg_trgm/expected/pg_trgm_optimizer.out | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
diff --git a/contrib/pg_trgm/expected/pg_trgm_optimizer.out
b/contrib/pg_trgm/expected/pg_trgm_optimizer.out
index 8684f352aed..96e6fc1767c 100644
--- a/contrib/pg_trgm/expected/pg_trgm_optimizer.out
+++ b/contrib/pg_trgm/expected/pg_trgm_optimizer.out
@@ -3507,15 +3507,15 @@ select t,similarity(t,'gwertyu1988') as sml from
test_trgm where t % 'gwertyu198
explain (costs off)
select t <-> 'q0987wertyu0988', t from test_trgm order by t <->
'q0987wertyu0988' limit 2;
- QUERY PLAN
------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------
Limit
-> Gather Motion 3:1 (slice1; segments: 3)
Merge Key: ((t <-> 'q0987wertyu0988'::text))
- -> Sort
- Sort Key: ((t <-> 'q0987wertyu0988'::text))
- -> Seq Scan on test_trgm
- Optimizer: GPORCA
+ -> Limit
+ -> Index Scan using trgm_idx on test_trgm
+ Order By: (t <-> 'q0987wertyu0988'::text)
+ Optimizer: Postgres query optimizer
(7 rows)
select t <-> 'q0987wertyu0988', t from test_trgm order by t <->
'q0987wertyu0988' limit 2;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
