Changeset: 49e62bdffa6f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/49e62bdffa6f
Modified Files:
sql/test/pg_regress/Tests/polygon.test
Branch: Dec2025
Log Message:
Approve normalized output.
diffs (185 lines):
diff --git a/sql/test/pg_regress/Tests/polygon.test
b/sql/test/pg_regress/Tests/polygon.test
--- a/sql/test/pg_regress/Tests/polygon.test
+++ b/sql/test/pg_regress/Tests/polygon.test
@@ -10,7 +10,7 @@ INSERT INTO POLYGON_TBL(f1) VALUES ('POL
query T rowsort
SELECT cast('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' as geometry)
----
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+POLYGON ((1 0, 3 1, 3 3, 1 0))
statement error
INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 0.0, 0.0 0.0))')
@@ -54,16 +54,11 @@ INSERT INTO POLYGON_TBL(f1) VALUES ('POL
query TT rowsort
SELECT '' AS four, POLYGON_TBL.* FROM POLYGON_TBL
----
-(empty)
-POLYGON ((0 1, 0 1, 0 1, 0 1))
-(empty)
-POLYGON ((0 1, 1 1, 0 1))
-(empty)
-POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
-(empty)
-POLYGON ((2 0, 2 4, 0 0, 2 0))
-(empty)
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+(empty) POLYGON ((0 0, 2 0, 2 4, 0 0))
+(empty) POLYGON ((0 1, 0 1, 0 1, 0 1))
+(empty) POLYGON ((0 1, 0 1, 0 1, 0 2, 0 1))
+(empty) POLYGON ((0 1, 1 1, 0 1))
+(empty) POLYGON ((1 0, 3 1, 3 3, 1 0))
statement ok
CREATE VIEW POLYGON_TBL_VW AS SELECT f1, cast(f1 as varchar(244)) as txt FROM
POLYGON_TBL
@@ -71,82 +66,53 @@ CREATE VIEW POLYGON_TBL_VW AS SELECT f1,
query TT rowsort
SELECT * FROM POLYGON_TBL_VW
----
-POLYGON ((0 1, 0 1, 0 1, 0 1))
-POLYGON ((0 1, 0 1, 0 1, 0 1))
-POLYGON ((0 1, 1 1, 0 1))
-POLYGON ((0 1, 1 1, 0 1))
-POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
-POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
-POLYGON ((2 0, 2 4, 0 0, 2 0))
-POLYGON ((2 0, 2 4, 0 0, 2 0))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+POLYGON ((0 0, 2 0, 2 4, 0 0)) POLYGON ((0 0, 2 0, 2 4, 0 0))
+POLYGON ((0 1, 0 1, 0 1, 0 1)) POLYGON ((0 1, 0 1, 0 1, 0 1))
+POLYGON ((0 1, 0 1, 0 1, 0 2, 0 1)) POLYGON ((0 1, 0 1, 0 1, 0 2, 0 1))
+POLYGON ((0 1, 1 1, 0 1)) POLYGON ((0 1, 1 1, 0 1))
+POLYGON ((1 0, 3 1, 3 3, 1 0)) POLYGON ((1 0, 3 1, 3 3, 1 0))
query TTT rowsort
SELECT '' AS three, p.*
FROM POLYGON_TBL_VW p
WHERE p.f1 && 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'
----
-(empty)
-POLYGON ((0 1, 1 1, 0 1))
-POLYGON ((0 1, 1 1, 0 1))
-(empty)
-POLYGON ((2 0, 2 4, 0 0, 2 0))
-POLYGON ((2 0, 2 4, 0 0, 2 0))
-(empty)
-POLYGON ((3 1, 3 3, 1 0, 3 1))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+(empty) POLYGON ((0 0, 2 0, 2 4, 0 0)) POLYGON ((0 0, 2 0, 2 4, 0 0))
+(empty) POLYGON ((0 1, 1 1, 0 1)) POLYGON ((0 1, 1 1, 0 1))
+(empty) POLYGON ((1 0, 3 1, 3 3, 1 0)) POLYGON ((1 0, 3 1, 3 3, 1 0))
query TTT rowsort
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
WHERE st_overlaps(p.f1, 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')
----
-(empty)
-POLYGON ((2 0, 2 4, 0 0, 2 0))
-POLYGON ((2 0, 2 4, 0 0, 2 0))
+(empty) POLYGON ((0 0, 2 0, 2 4, 0 0)) POLYGON ((0 0, 2 0, 2 4, 0 0))
query TTT rowsort
SELECT '' AS four, p.*
FROM POLYGON_TBL_VW p
WHERE p.f1 &< 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'
----
-(empty)
-POLYGON ((0 1, 0 1, 0 1, 0 1))
-POLYGON ((0 1, 0 1, 0 1, 0 1))
-(empty)
-POLYGON ((0 1, 1 1, 0 1))
-POLYGON ((0 1, 1 1, 0 1))
-(empty)
-POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
-POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
-(empty)
-POLYGON ((2 0, 2 4, 0 0, 2 0))
-POLYGON ((2 0, 2 4, 0 0, 2 0))
-(empty)
-POLYGON ((3 1, 3 3, 1 0, 3 1))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+(empty) POLYGON ((0 0, 2 0, 2 4, 0 0)) POLYGON ((0 0, 2 0, 2 4, 0 0))
+(empty) POLYGON ((0 1, 0 1, 0 1, 0 1)) POLYGON ((0 1, 0 1, 0 1, 0 1))
+(empty) POLYGON ((0 1, 0 1, 0 1, 0 2, 0 1)) POLYGON ((0 1, 0 1, 0
1, 0 2, 0 1))
+(empty) POLYGON ((0 1, 1 1, 0 1)) POLYGON ((0 1, 1 1, 0 1))
+(empty) POLYGON ((1 0, 3 1, 3 3, 1 0)) POLYGON ((1 0, 3 1, 3 3, 1 0))
query TTT rowsort
SELECT '' AS two, p.*
FROM POLYGON_TBL_VW p
WHERE p.f1 &> 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'
----
-(empty)
-POLYGON ((3 1, 3 3, 1 0, 3 1))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+(empty) POLYGON ((1 0, 3 1, 3 3, 1 0)) POLYGON ((1 0, 3 1, 3 3, 1 0))
query TTT rowsort
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
WHERE p.f1 << 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'
----
-(empty)
-POLYGON ((0 1, 0 1, 0 1, 0 1))
-POLYGON ((0 1, 0 1, 0 1, 0 1))
-(empty)
-POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
-POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
+(empty) POLYGON ((0 1, 0 1, 0 1, 0 1)) POLYGON ((0 1, 0 1, 0 1, 0 1))
+(empty) POLYGON ((0 1, 0 1, 0 1, 0 2, 0 1)) POLYGON ((0 1, 0 1, 0
1, 0 2, 0 1))
query TTT rowsort
SELECT '' AS zero, p.*
@@ -159,45 +125,35 @@ SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
WHERE p.f1 @ 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'
----
-(empty)
-POLYGON ((3 1, 3 3, 1 0, 3 1))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+(empty) POLYGON ((1 0, 3 1, 3 3, 1 0)) POLYGON ((1 0, 3 1, 3 3, 1 0))
query TTT rowsort
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
WHERE p.f1 ~= 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'
----
-(empty)
-POLYGON ((3 1, 3 3, 1 0, 3 1))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+(empty) POLYGON ((1 0, 3 1, 3 3, 1 0)) POLYGON ((1 0, 3 1, 3 3, 1 0))
query TTT rowsort
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
WHERE st_equals(p.f1, 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')
----
-(empty)
-POLYGON ((3 1, 3 3, 1 0, 3 1))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+(empty) POLYGON ((1 0, 3 1, 3 3, 1 0)) POLYGON ((1 0, 3 1, 3 3, 1 0))
query TTT rowsort
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
WHERE p.f1 ~ 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'
----
-(empty)
-POLYGON ((3 1, 3 3, 1 0, 3 1))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+(empty) POLYGON ((1 0, 3 1, 3 3, 1 0)) POLYGON ((1 0, 3 1, 3 3, 1 0))
query TTT rowsort
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
WHERE st_contains(p.f1, 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')
----
-(empty)
-POLYGON ((3 1, 3 3, 1 0, 3 1))
-POLYGON ((3 1, 3 3, 1 0, 3 1))
+(empty) POLYGON ((1 0, 3 1, 3 3, 1 0)) POLYGON ((1 0, 3 1, 3 3, 1 0))
query I rowsort
SELECT ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))') <<
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false"
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
