Changeset: a4da63f0e5e1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a4da63f0e5e1
Modified Files:
geom/sql/functions/Tests/ST_Transform-3.12.test
Branch: Dec2023
Log Message:
Round floating point numbers inside GEOM output.
diffs (65 lines):
diff --git a/geom/sql/functions/Tests/ST_Transform-3.12.test
b/geom/sql/functions/Tests/ST_Transform-3.12.test
--- a/geom/sql/functions/Tests/ST_Transform-3.12.test
+++ b/geom/sql/functions/Tests/ST_Transform-3.12.test
@@ -1,14 +1,14 @@
# Point from 4326 to 4326
-query T rowsort
+query T python .floatutil.filter
SELECT ST_AsText(ST_Transform(st_setsrid(st_pointfromtext('POINT (-4.4657183
48.38249)'), 4326), 4326))
----
-POINT (-4.4657183 48.38249)
+POINT (-4.466 48.382)
# Point from 4326 to 3035
-query T rowsort
+query T python .floatutil.filter
SELECT ST_AsText(ST_Transform(st_setsrid(st_pointfromtext('POINT (-4.4657183
48.38249)'), 4326), 3035))
----
-POINT (3256910.236847341 2912495.4152792906)
+POINT (3256910.237 2912495.415)
# MultiPoint from 4326 to 3035
query T python .floatutil.filter
@@ -17,32 +17,32 @@ SELECT ST_AsText(ST_Transform(st_setsrid
MULTIPOINT ((3256910.237 2912495.415), (3254672.923 2912934.464), (3237755.624
2883346.764), (3255480.256 2912648.020), (3254781.139 2913053.767),
(3259904.443 2881843.116), (3226399.412 2873698.514), (3251885.336
2888932.855), (3225814.103 2875919.873), (3256910.474 2912497.300))
# Linestring from 4326 to 3035
-query T rowsort
+query T python .floatutil.filter
SELECT ST_AsText(ST_Transform(st_setsrid(st_linefromtext('LINESTRING
(-5.6873484 48.344147, -5.6681333 48.33428, -5.6679835 48.33422, -5.66766
48.33412)'), 4326), 3035))
----
-LINESTRING (3167671.8168278513 2926719.292472556, 3168833.765553358
2925341.3530472373, 3168843.2145084543 2925332.4584952043, 3168864.2978334744
2925316.4775951537)
+LINESTRING (3167671.817 2926719.292, 3168833.766 2925341.353, 3168843.215
2925332.458, 3168864.298 2925316.478)
# MultiLinestring from 4326 to 3035
-query T rowsort
+query T python .floatutil.filter
SELECT ST_AsText(ST_Transform(st_setsrid(st_geomfromtext('MULTILINESTRING
((-5.6873484 48.344147, -5.6681333 48.33428), (-5.6681333 48.33428, -5.6679835
48.33422), (-5.6679835 48.33422, -5.66766 48.33412))'), 4326), 3035))
----
-MULTILINESTRING ((3167671.8168278513 2926719.292472556, 3168833.765553358
2925341.3530472373), (3168833.765553358 2925341.3530472373, 3168843.2145084543
2925332.4584952043), (3168843.2145084543 2925332.4584952043, 3168864.2978334744
2925316.4775951537))
+MULTILINESTRING ((3167671.817 2926719.292, 3168833.766 2925341.353),
(3168833.766 2925341.353, 3168843.215 2925332.458), (3168843.215 2925332.458,
3168864.298 2925316.478))
# Polygon from 4326 to 3035
-query T rowsort
+query T python .floatutil.filter
SELECT ST_AsText(ST_Transform(st_setsrid(st_polygonfromtext('POLYGON ((-70 35,
-70 39, -65 39, -65 35, -70 35))'), 4326), 3035))
----
-POLYGON ((-1551336.6886370108 4960140.610519264, -1181855.207118743
5226023.370006166, -1007637.697308938 4831052.145729965, -1359624.1787992017
4542397.806396248, -1551336.6886370108 4960140.610519264))
+POLYGON ((-1551336.689 4960140.611, -1181855.207 5226023.370, -1007637.697
4831052.146, -1359624.179 4542397.806, -1551336.689 4960140.611))
# MultiPolygon from 4326 to 3035
-query T rowsort
+query T python .floatutil.filter
SELECT ST_AsText(ST_Transform(st_setsrid(st_geomfromtext('MULTIPOLYGON (((-20
-50, -20 -40, 30 -40, 30 -50, -20 -50)), ((30 -50, 30 -45, 40 -45, 40 -50, 30
-50)))'), 4326), 3035))
----
-MULTIPOLYGON (((951463.5890125036 -6309234.415106328, 687127.3565636296
-5482088.556344701, 6760173.911872292 -5732283.7683529835, 6581741.604272356
-6509599.735591641, 951463.5890125036 -6309234.415106328)), ((6581741.604272356
-6509599.735591641, 6682271.808015617 -6128844.200428242, 7839821.83702993
-5902264.746195812, 7690536.410987496 -6309234.415106328, 6581741.604272356
-6509599.735591641)))
+MULTIPOLYGON (((951463.589 -6309234.415, 687127.357 -5482088.556, 6760173.912
-5732283.768, 6581741.604 -6509599.736, 951463.589 -6309234.415)),
((6581741.604 -6509599.736, 6682271.808 -6128844.200, 7839821.837 -5902264.746,
7690536.411 -6309234.415, 6581741.604 -6509599.736)))
# GeometryCollection from 4326 to 3035
# TODO: Not yet supported
-#query T rowsort
+#query T python .floatutil.filter
#SELECT ST_AsText(ST_Transform(st_setsrid(st_geomfromtext('GEOMETRYCOLLECTION
(POLYGON ((-20 -50, -20 -40, 30 -40, 30 -50, -20 -50)), POLYGON ((30 -50, 30
-45, 40 -45, 40 -50, 30 -50)), MULTIPOINT (-4.4657183 48.38249, -4.4965715
48.38242, -4.644325 48.092247))'), 4326), 3035))
#----
-#GEOMETRYCOLLECTION (POLYGON ((951463.5890125036 -6309234.415106328,
687127.3565636296 -5482088.556344701, 6760173.911872292 -5732283.768352984,
6581741.604272356 -6509599.735591641, 951463.5890125036 -6309234.415106328)),
POLYGON((6581741.604272356 -6509599.735591641, 6682271.808015617
-6128844.200428242, 7839821.83702993 -5902264.746195812, 7690536.410987496
-6309234.415106328, 6581741.604272356 -6509599.735591641)), MULTIPOINT
(3256910.236847341 2912495.415279291, 3254672.923283204 2912934.464415785,
3237755.624311555 2883346.764096317))
+#GEOMETRYCOLLECTION (POLYGON ((951463.589 -6309234.415, 687127.357
-5482088.556, 6760173.912 -5732283.768, 6581741.604 -6509599.736, 951463.589
-6309234.415)), POLYGON((6581741.604 -6509599.736, 6682271.808 -6128844.200,
7839821.837 -5902264.746, 7690536.411 -6309234.415, 6581741.604 -6509599.736)),
MULTIPOINT (3256910.237 2912495.415, 3254672.923 2912934.464, 3237755.624
2883346.764))
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
