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 2d53b0f0a07 Fix answer for geometry/horology
2d53b0f0a07 is described below
commit 2d53b0f0a0724276685ffd0c4220232c69b58f60
Author: Jinbao Chen <[email protected]>
AuthorDate: Mon Nov 3 10:51:37 2025 +0800
Fix answer for geometry/horology
---
src/test/regress/expected/geometry.out | 34 ++++++++++++++++++++--------------
src/test/regress/expected/horology.out | 6 +++++-
2 files changed, 25 insertions(+), 15 deletions(-)
diff --git a/src/test/regress/expected/geometry.out
b/src/test/regress/expected/geometry.out
index 840e037a448..403d0d80e2b 100644
--- a/src/test/regress/expected/geometry.out
+++ b/src/test/regress/expected/geometry.out
@@ -5253,13 +5253,16 @@ SELECT * FROM circle_tbl WHERE f1 &&
circle(point(1,-2), 1)
EXPLAIN (COSTS OFF)
SELECT * FROM circle_tbl WHERE f1 && circle(point(1,-2), 1)
ORDER BY area(f1);
- QUERY PLAN
-----------------------------------------------
- Sort
- Sort Key: (area(f1))
- -> Seq Scan on circle_tbl
- Filter: (f1 && '<(1,-2),1>'::circle)
-(4 rows)
+ QUERY PLAN
+----------------------------------------------------
+ Gather Motion 3:1 (slice1; segments: 3)
+ Merge Key: (area(f1))
+ -> Sort
+ Sort Key: (area(f1))
+ -> Seq Scan on circle_tbl
+ Filter: (f1 && '<(1,-2),1>'::circle)
+ Optimizer: Postgres query optimizer
+(7 rows)
SELECT * FROM circle_tbl WHERE f1 && circle(point(1,-2), 1)
ORDER BY area(f1);
@@ -5283,13 +5286,16 @@ SELECT * FROM polygon_tbl WHERE f1 @>
'((1,1),(2,2),(2,1))'::polygon
EXPLAIN (COSTS OFF)
SELECT * FROM polygon_tbl WHERE f1 @> '((1,1),(2,2),(2,1))'::polygon
ORDER BY (poly_center(f1))[0];
- QUERY PLAN
---------------------------------------------------------
- Sort
- Sort Key: ((poly_center(f1))[0])
- -> Seq Scan on polygon_tbl
- Filter: (f1 @> '((1,1),(2,2),(2,1))'::polygon)
-(4 rows)
+ QUERY PLAN
+--------------------------------------------------------------
+ Gather Motion 3:1 (slice1; segments: 3)
+ Merge Key: ((poly_center(f1))[0])
+ -> Sort
+ Sort Key: ((poly_center(f1))[0])
+ -> Seq Scan on polygon_tbl
+ Filter: (f1 @> '((1,1),(2,2),(2,1))'::polygon)
+ Optimizer: Postgres query optimizer
+(7 rows)
SELECT * FROM polygon_tbl WHERE f1 @> '((1,1),(2,2),(2,1))'::polygon
ORDER BY (poly_center(f1))[0];
diff --git a/src/test/regress/expected/horology.out
b/src/test/regress/expected/horology.out
index 1f60d040269..a09c7368a29 100644
--- a/src/test/regress/expected/horology.out
+++ b/src/test/regress/expected/horology.out
@@ -643,7 +643,11 @@ SELECT timestamp without time zone 'Jan 1, 4713 BC' +
interval '109203489 days'
(1 row)
SELECT timestamp without time zone '2000-01-01' - interval '2483590 days' AS
"out of range";
-ERROR: timestamp out of range
+ out of range
+-----------------------------
+ Mon Aug 16 00:00:00 4560 BC
+(1 row)
+
SELECT timestamp without time zone '294276-12-31 23:59:59' + interval
'9223372036854775807 microseconds' AS "out of range";
ERROR: timestamp out of range
SELECT timestamp without time zone '12/31/294276' - timestamp without time
zone '12/23/1999' AS "106751991 Days";
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
