You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by ch...@apache.org on 2026/05/07 01:25:27 UTC
(cloudberry) branch cbdb-postgres-merge updated: Fix answer file for pg_trgm
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 <ch...@gmail.com>
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: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org