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 3155adb005a Fix answer file for horology
3155adb005a is described below
commit 3155adb005a50d6480d4e6405b6a6243689e0499
Author: Jinbao Chen <[email protected]>
AuthorDate: Mon Nov 3 10:58:08 2025 +0800
Fix answer file for horology
---
src/test/regress/expected/horology.out | 60 ++++++++++++++++++++--------------
1 file changed, 36 insertions(+), 24 deletions(-)
diff --git a/src/test/regress/expected/horology.out
b/src/test/regress/expected/horology.out
index a09c7368a29..f1d66186ee9 100644
--- a/src/test/regress/expected/horology.out
+++ b/src/test/regress/expected/horology.out
@@ -2434,12 +2434,15 @@ RESET TimeZone;
explain (costs off)
select count(*) from date_tbl
where f1 between '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+ QUERY PLAN
+-----------------------------------------------------------------------------------------
+ Finalize Aggregate
+ -> Gather Motion 3:1 (slice1; segments: 3)
+ -> Partial Aggregate
+ -> Seq Scan on date_tbl
+ Filter: ((f1 >= '01-01-1997'::date) AND (f1 <=
'01-01-1998'::date))
+ Optimizer: Postgres query optimizer
+(6 rows)
select count(*) from date_tbl
where f1 between '1997-01-01' and '1998-01-01';
@@ -2451,12 +2454,15 @@ select count(*) from date_tbl
explain (costs off)
select count(*) from date_tbl
where f1 not between '1997-01-01' and '1998-01-01';
- QUERY PLAN
---------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 < '01-01-1997'::date) OR (f1 > '01-01-1998'::date))
-(3 rows)
+ QUERY PLAN
+--------------------------------------------------------------------------------------
+ Finalize Aggregate
+ -> Gather Motion 3:1 (slice1; segments: 3)
+ -> Partial Aggregate
+ -> Seq Scan on date_tbl
+ Filter: ((f1 < '01-01-1997'::date) OR (f1 >
'01-01-1998'::date))
+ Optimizer: Postgres query optimizer
+(6 rows)
select count(*) from date_tbl
where f1 not between '1997-01-01' and '1998-01-01';
@@ -2468,12 +2474,15 @@ select count(*) from date_tbl
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: (((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
OR ((f1 >= '01-01-1998'::date) AND (f1 <= '01-01-1997'::date)))
-(3 rows)
+ QUERY
PLAN
+----------------------------------------------------------------------------------------------------------------------------------------------------------
+ Finalize Aggregate
+ -> Gather Motion 3:1 (slice1; segments: 3)
+ -> Partial Aggregate
+ -> Seq Scan on date_tbl
+ Filter: (((f1 >= '01-01-1997'::date) AND (f1 <=
'01-01-1998'::date)) OR ((f1 >= '01-01-1998'::date) AND (f1 <=
'01-01-1997'::date)))
+ Optimizer: Postgres query optimizer
+(6 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
@@ -2485,12 +2494,15 @@ select count(*) from date_tbl
explain (costs off)
select count(*) from date_tbl
where f1 not between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: (((f1 < '01-01-1997'::date) OR (f1 > '01-01-1998'::date)) AND
((f1 < '01-01-1998'::date) OR (f1 > '01-01-1997'::date)))
-(3 rows)
+ QUERY
PLAN
+-----------------------------------------------------------------------------------------------------------------------------------------------------
+ Finalize Aggregate
+ -> Gather Motion 3:1 (slice1; segments: 3)
+ -> Partial Aggregate
+ -> Seq Scan on date_tbl
+ Filter: (((f1 < '01-01-1997'::date) OR (f1 >
'01-01-1998'::date)) AND ((f1 < '01-01-1998'::date) OR (f1 >
'01-01-1997'::date)))
+ Optimizer: Postgres query optimizer
+(6 rows)
select count(*) from date_tbl
where f1 not between symmetric '1997-01-01' and '1998-01-01';
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
