[postgis-tickets] [PostGIS] #4730: Overlay GEOS 3.9 regress failures
PostGIS
trac at osgeo.org
Wed Jul 29 18:52:46 PDT 2020
#4730: Overlay GEOS 3.9 regress failures
----------------------+---------------------------
Reporter: robe | Owner: pramsey
Type: defect | Status: new
Priority: blocker | Milestone: PostGIS 3.1.0
Component: postgis | Version: master
Resolution: | Keywords:
----------------------+---------------------------
Comment (by robe):
Sadly could only address one topology test by normalizing, rest appear to
be caused by behavior change :(
So what it shows now is:
{{{
PostgreSQL 13beta2 on x86_64-w64-mingw32, compiled by gcc.exe (x86_64
-posix-seh-rev0, Built by MinGW-W64 project) 8.1.0, 64-bit
Postgis 3.1.0dev - (3.1.0alpha2-23-g81b9af77b) - 2020-07-30 00:20:13
scripts 3.1.0dev 3.1.0alpha2-23-g81b9af77b
GEOS: 3.9.0-CAPI-1.14.0
PROJ: 6.2.1
Running tests
regress/legacy_validate .. ok in 745 ms
regress/legacy_predicate .. ok in 1021 ms
regress/legacy_invalid .. ok in 442 ms
regress/sqlmm .. ok in 430 ms
regress/legacy_query .. ok in 839 ms
regress/addnode .. ok in 724 ms
regress/addedge .. ok in 817 ms
regress/addface .. ok in 2297 ms
regress/addface2.5d .. ok in 446 ms
regress/addtopogeometrycolumn .. ok in 497 ms
regress/polygonize .. ok in 447 ms
regress/st_addisoedge .. ok in 421 ms
regress/st_addisonode .. ok in 449 ms
regress/st_addedgemodface .. ok in 637 ms
regress/st_addedgenewfaces .. ok in 634 ms
regress/st_changeedgegeom .. ok in 464 ms
regress/st_createtopogeo .. failed (diff expected obtained:
/projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_17_diff)
-----------------------------------------------------------------------------
--- regress/st_createtopogeo_expected 2020-07-29 20:16:50.707793500
-0400
+++ /projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_17_out
2020-07-29 21:46:54.908906000 -0400
@@ -23,20 +23,17 @@
T9|2 nodes|4 edges|3 faces
T10|MULTIPOLYGON(((0 0,5 10,10 0,0 0)),((0 20,5 10,10 20,0 20)))
T10|1 nodes|2 edges|2 faces
-T11|GEOMETRYCOLLECTION(LINESTRING(0 0,10 0),POINT(5 0))
-T11|3 nodes|2 edges|0 faces
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+T11|0 nodes|0 edges|0 faces
T12|GEOMETRYCOLLECTION(LINESTRING(0 0,10 0),POINT(0 0),POINT(10 0))
T12|2 nodes|1 edges|0 faces
-T13|GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)),((5 5,5
15,15 15,15 5,5 5),(10 10,12 10,10 12,10 10))),LINESTRING(0 0,20
0),MULTIPOINT(0 0,10 0,5 0),MULTILINESTRING((0 0,10 0),(10 0,15
5)),POINT(5 0),POINT(10.5 10.5),POINT(100 500))
-T13|10 nodes|12 edges|5 faces
-T13|1 isolated nodes in face 0
-T13|1 isolated nodes in face 5
-T14|GEOMETRYCOLLECTION(LINESTRING(8 30,16 30,16 38,3 38,3 30,8
30),POINT(4 31),LINESTRING(4 31,7 31,7 34,4 34,4 31),POINT(8 30),POINT(9
6),LINESTRING(9 6,9 14),LINESTRING(9 6,21 6),POLYGON((9 14,21 14,21 6,9
6,9 14)),POINT(9 14),LINESTRING(9 14,9 22),LINESTRING(9 14,21
14),POLYGON((9 22,21 22,21 14,9 14,9 22)),POINT(9 22),LINESTRING(9 22,21
22),POINT(9 35),LINESTRING(9 35,13 35),POINT(13 35),POLYGON((25 30,17
30,17 40,31 40,31 30,25 30)),POINT(20 37),POINT(21 6),LINESTRING(21 6,21
14),LINESTRING(21 6,35 6),POLYGON((21 14,35 14,35 6,21 6,21 14)),POINT(21
14),LINESTRING(21 14,21 22),LINESTRING(35 14,21 14),POLYGON((21 22,35
22,35 14,21 14,21 22)),POINT(21 22),LINESTRING(21 22,35 22),POINT(25
30),LINESTRING(25 30,25 35),POINT(25 35),POINT(35 6),LINESTRING(35 6,35
14),LINESTRING(35 6,47 6),POLYGON((35 14,47 14,47 6,35 6,35 14)),POINT(35
14),LINESTRING(35 14,35 22),LINESTRING(35 14,47 14),POLYGON((35 22,47
22,47 14,35 14,35 22)),POINT(35 22),LINESTRING(35 22,47 22),LINESTRING(36
38,38 35,41 34,42 33,45 32,47 28,50 28,52 32,57 33),POINT(36
38),LINESTRING(41 40,45 40,47 42,62 41,61 38,59 39,57 36,57 33),POINT(41
40),POINT(47 6),LINESTRING(47 6,47 14),POINT(47 14),LINESTRING(47 14,47
22),POINT(47 22),POINT(57 33))
-T14|22 nodes|24 edges|9 faces
-T14|1 isolated nodes in face 3
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+T13|0 nodes|0 edges|0 faces
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+T14|0 nodes|0 edges|0 faces
T15|GEOMETRYCOLLECTION(LINESTRING(-5 -2,0 0),LINESTRING(0 0,10
10),LINESTRING(0 0,5 2,10 10),LINESTRING(10 10,12 10))
T15|4 nodes|4 edges|1 faces
-T16|GEOMETRYCOLLECTION(LINESTRING(0 0,10 0),LINESTRING(0 3,20
4),LINESTRING(10 0,20 4))
-T16|4 nodes|3 edges|0 faces
-T17|MULTILINESTRING((832709.937 816560.25,832705.813 816470.25,832661.937
816561.875),(832705.812 816470.25,832709.937 816560.25),(832661.938
816561.875,832705.813 816470.25))
-T17|7 nodes|8 edges|2 faces
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+T16|0 nodes|0 edges|0 faces
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+T17|0 nodes|0 edges|0 faces
-----------------------------------------------------------------------------
regress/st_getfacegeometry .. ok in 457 ms
regress/st_getfaceedges .. ok in 788 ms
regress/st_modedgeheal .. ok in 1474 ms
regress/st_modedgesplit .. ok in 864 ms
regress/st_newedgeheal .. ok in 1481 ms
regress/st_newedgessplit .. ok in 577 ms
regress/st_remedgenewface .. ok in 1324 ms
regress/st_remedgemodface .. ok in 1302 ms
regress/st_simplify .. failed (diff expected obtained:
/projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_26_diff)
-----------------------------------------------------------------------------
--- regress/st_simplify_expected 2020-07-29 20:16:50.715788000
-0400
+++ /projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_26_out
2020-07-29 21:47:05.072452700 -0400
@@ -1,9 +1,8 @@
t
L1
+ERROR: Spatial exception - geometry intersects edge 1
N2
-S1|f|t
-S2|f|t
+S1|f|
+S2|f|
L2
-HS1|f|t
-HS2|f|t
f
-----------------------------------------------------------------------------
regress/topoelement .. ok in 95 ms
regress/topoelementarray_agg .. ok in 95 ms
regress/topogeo_addlinestring .. failed (diff expected obtained:
/projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_29_diff)
-----------------------------------------------------------------------------
--- regress/topogeo_addlinestring_expected 2020-07-29
20:16:55.448350000 -0400
+++ /projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_29_out
2020-07-29 21:47:08.832928700 -0400
@@ -25,166 +25,66 @@
contained|E|18|sn10|en27
contained|E|29|sn27|en28
contained|E|30|sn28|en13
-overlap|31
-overlap|32
-overlap|N|29||POINT(49 22)
-overlap|N|30||POINT(45 22)
-overlap|E|8|sn18|en30
-overlap|E|31|sn19|en29
-overlap|E|32|sn30|en19
-cross|34
-cross|35
-cross|N|31||POINT(49 18)
-cross|N|32||POINT(47 17.6)
-cross|N|33||POINT(44 17)
-cross|E|15|sn12|en32
-cross|E|33|sn32|en19
-cross|E|34|sn31|en32
-cross|E|35|sn32|en33
-snap|7
-snap|36
-snap|38
-snap|N|34||POINT(18 22.200000000000003)
-snap|N|35||POINT(22.400000000000002 22)
-snap|N|36||POINT(21.200000000000003 20.400000000000002)
-snap|E|7|sn17|en35
-snap|E|36|sn34|en17
-snap|E|37|sn35|en18
-snap|E|38|sn35|en36
-snap_again|7
-snap_again|36
-snap_again|38
-crossover|4
-crossover|N|
-crossover|N|
-crossover|N|
-crossover|N|
-crossover|N|
-crossover|E|
-crossover|E|
-crossover|E|
-crossover|E|
-crossover|E|
-crossover|E|
-crossover|E|
-crossover|E|
-crossover|E|
-crossover|E|
-crossover_again|4
-contains|25
-contains|46
-contains|47
-contains|N|
-contains|N|
-contains|E|
-contains|E|
-nodecross|48
-nodecross|49
-nodecross|N|44||POINT(18 37)
-nodecross|N|45||POINT(22 37)
-nodecross|E|48|sn44|en4
-nodecross|E|49|sn4|en45
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses an edge (endnodes in
faces 0 and 9187201950435737471)
+ERROR: SQL/MM Spatial exception - geometry crosses an edge (endnodes in
faces 0 and 9187201950435737471)
+ERROR: SQL/MM Spatial exception - geometry crosses an edge (endnodes in
faces 0 and 9187201950435737471)
+ERROR: SQL/MM Spatial exception - geometry crosses edge 9
+ERROR: SQL/MM Spatial exception - geometry crosses edge 9
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
iso_ex_2segs|28
-#1613.1|50
-#1613.1|N|46||POINT(556267.6 144887)
-#1613.1|N|47||POINT(556267 144887.4)
-#1613.1|E|50|sn46|en47
-#1613.2|52
-#1613.2|53
-#1613.2|N|
-#1613.2|N|
-#1613.2|N|
-#1613.2|E|
-#1613.2|E|
-#1613.2|E|
-#1613.2|E|
-#1631.1|54
-#1631.1|N|51||POINT(556267.6 144887)
-#1631.1|N|52||POINT(556267.6 144888)
-#1631.1|E|54|sn51|en52
-#1631.2|55
-#1631.2|56
-#1631.2|N|53||POINT(556254.6 144886.6)
-#1631.2|N|54||POINT(556267.6 144887)
-#1631.2|E|55|sn53|en51
-#1631.2|E|56|sn51|en54
-#1641.1|57
-#1641.1|N|55||POINT(-0.2 0.4)
-#1641.1|N|56||POINT(0.2 0.4)
-#1641.1|E|57|sn55|en56
-#1641.2|59
-#1641.2|60
-#1641.2|N|57||POINT(0 0.2)
-#1641.2|N|58||POINT(0 0.4)
-#1641.2|N|59||POINT(0 0.4)
-#1641.2|E|57|sn55|en58
-#1641.2|E|58|sn58|en56
-#1641.2|E|59|sn57|en58
-#1641.2|E|60|sn58|en59
-#1641.3|61
-#1641.3|N|60||POINT(-0.2 0.4)
-#1641.3|N|61||POINT(0.2 0.4)
-#1641.3|E|61|sn60|en61
-#1641.4|63
-#1641.4|64
-#1641.4|N|62||POINT(0 0.2)
-#1641.4|N|63||POINT(0 0.4)
-#1641.4|N|64||POINT(0 0.4)
-#1641.4|E|61|sn60|en63
-#1641.4|E|62|sn63|en61
-#1641.4|E|63|sn62|en63
-#1641.4|E|64|sn63|en64
+#1613.1|36
+#1613.1|N|45||POINT(556267.6 144887)
+#1613.1|N|46||POINT(556267 144887.4)
+#1613.1|E|36|sn45|en46
+ERROR: SQL/MM Spatial exception - geometry crosses edge 36
+#1631.1|37
+#1631.1|N|49||POINT(556267.6 144887)
+#1631.1|N|50||POINT(556267.6 144888)
+#1631.1|E|37|sn49|en50
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+#1641.1|38
+#1641.1|N|53||POINT(-0.2 0.4)
+#1641.1|N|54||POINT(0.2 0.4)
+#1641.1|E|38|sn53|en54
+ERROR: SQL/MM Spatial exception - geometry crosses edge 38
+#1641.3|39
+#1641.3|N|57||POINT(-0.2 0.4)
+#1641.3|N|58||POINT(0.2 0.4)
+#1641.3|E|39|sn57|en58
+ERROR: SQL/MM Spatial exception - geometry crosses edge 39
#1650.1
-#1650.265
-#1650.2|N|65||POINT(0 0)
-#1650.2|N|66||POINT(0 1)
-#1650.2|E|65|sn65|en66
-#1650.3|65
-#1650.3|66
-#1650.3|N|67||POINT(10 0)
-#1650.3|E|66|sn65|en67
-#1654.1|N|68
-#1654.1|N|68|0|POINT(0 0)
-#1654.2|67
-#1654.2|68
-#1654.2|N|69||POINT(-10 1)
-#1654.2|N|70||POINT(10 1)
-#1654.2|E|67|sn69|en68
-#1654.2|E|68|sn68|en70
-#1706.1|E|69
-#1706.1|N|71||POINT(20 10)
-#1706.1|N|72||POINT(10 20)
-#1706.1|E|69|sn71|en72
-#1706.2|E*|69
-#1706.2|E*|70
-#1706.2|E*|71
-#1706.2|E*|73
-#1706.2|N|73||POINT(10 0)
-#1706.2|N|74||POINT(10 10)
-#1706.2|N|75||POINT(9 12)
-#1706.2|N|76||POINT(15 10)
-#1706.2|E|69|sn71|en76
-#1706.2|E|70|sn74|en75
-#1706.2|E|71|sn73|en74
-#1706.2|E|72|sn75|en72
-#1706.2|E|73|sn76|en74
-#1714.1|N|77
-#1714.1|N|77|0|POINT(10 0)
-#1714.2|E*|74
-#1714.2|N|78||POINT(0 20)
-#1714.2|E|74|sn77|en78
+#1650.240
+#1650.2|N|61||POINT(0 0)
+#1650.2|N|62||POINT(0 1)
+#1650.2|E|40|sn61|en62
+#1650.3|41
+#1650.3|N|63||POINT(10 0)
+#1650.3|E|41|sn62|en63
+#1654.1|N|64
+#1654.1|N|64|0|POINT(0 0)
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+#1706.1|E|42
+#1706.1|N|67||POINT(20 10)
+#1706.1|N|68||POINT(10 20)
+#1706.1|E|42|sn67|en68
+ERROR: Spatial exception - geometry intersects edge 42
+#1714.1|N|70
+#1714.1|N|70|0|POINT(10 0)
+#1714.2|E*|43
+#1714.2|N|71||POINT(0 20)
+#1714.2|E|43|sn70|en71
Topology 'city_data' dropped
t3280.start|t
t3280|L11
t3280|L22
-t3280|L1b2
-t3280|L1b4
+ERROR: Spatial exception - geometry intersects edge 2
t3280.end|Topology 'bug3280' dropped
t3380.start|t
t3380.L1|1
-t3380.L2|3
-t3380.L2|4
-t3380.L3|5
+ERROR: SQL/MM Spatial exception - geometry crosses edge 1
+t3380.L3|2
t3380.end|Topology 'bug3380' dropped
t3402.start|t
t3402.L1|1
@@ -192,23 +92,20 @@
t3402.end|Topology 'bug3402' dropped
t3412.start|t
t3412.L1|1
-t3412.L2|4
+ERROR: SQL/MM Spatial exception - geometry crosses a node
t3412.end|Topology 'bug3412' dropped
t3371.start|t
t3371.L1|1
-t3371.L2|3
-t3371.L2|2
+ERROR: Spatial exception - geometry intersects edge 1
t3371.end|Topology 'bug3711' dropped
t3838.start|t
t3838.L1|1
-t3838.L2|9
+ERROR: SQL/MM Spatial exception - geometry crosses a node
t3838.end|Topology 'bug3838' dropped
t1855_1.start|t
t1855_1.0|1
t1855_1.end|Topology 'bug1855' dropped
t1855_2.start|t
t1855_2.0|1
-t1855_2.1|3
-t1855_2.1|5
-t1855_2.1|6
+ERROR: SQL/MM Spatial exception - geometry crosses edge 1
t1855_2.end|Topology 'bug1855' dropped
-----------------------------------------------------------------------------
regress/topogeo_addpoint .. ok in 772 ms
regress/topogeo_addpolygon .. failed (diff expected obtained:
/projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_31_diff)
-----------------------------------------------------------------------------
--- regress/topogeo_addpolygon_expected 2020-07-29 20:16:50.722786900
-0400
+++ /projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_31_out
2020-07-29 21:47:11.040251800 -0400
@@ -19,44 +19,19 @@
iso_uni_hole|E|29|sn25|en25
iso_uni_hole|F|11
iso_uni_hole|F|12
-ex|4
-ex_union|6
-ex_union|7
-half|4
-half|E|30|sn14|en18
-half|F|13
-split|4
-split|13
-split|N||POINT(28 18)
-split|E|
-split|E|
-split|E|
-split|E|
-split|F|
-split|F|
-ex_hole|3
-ex_hole|5
-ex_hole|6
-ex_hole|7
-ex_hole|8
-ex_hole|13
-ex_hole|14
-ex_hole|15
-ex_hole_snap|3
-ex_hole_snap|5
-ex_hole_snap|6
-ex_hole_snap|7
-ex_hole_snap|8
-ex_hole_snap|13
-ex_hole_snap|14
-ex_hole_snap|15
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
Topology 'city_data' dropped
t1855_0.start|t
t1855_0.0|1
-t1855_0.1|2
+ERROR: Spatial exception - geometry intersects edge 1
t1855_0.end|Topology 'bug1855' dropped
t1946.start|t
t1946.0|1
-t1946.1|2
-t1946.2|1
+ERROR: Spatial exception - geometry intersects edge 1
+ERROR: SQL/MM Spatial exception - geometry crosses edge 2
t1946.end|Topology 'bug1946' dropped
-----------------------------------------------------------------------------
regress/topogeom_edit .. ok in 561 ms
regress/topogeometry_type .. ok in 817 ms
regress/topojson .. ok in 900 ms
regress/topologysummary .. ok in 157 ms
regress/topo2.5d .. ok in 551 ms
regress/totopogeom .. failed (diff expected obtained:
/projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_37_diff)
-----------------------------------------------------------------------------
--- regress/totopogeom_expected 2020-07-29 20:16:50.763784300 -0400
+++ /projects/postgis/tmp/3.1.0dev_pg13_geos3.9_gdal3.0.2w64/test_37_out
2020-07-29 21:47:16.584352100 -0400
@@ -32,21 +32,19 @@
MULTIPOLYGON EMPTY
MULTIPOLYGON EMPTY
GEOMETRYCOLLECTION EMPTY
-tolerance_1|0.5
-tolerance_topo_1|0.5
-tolerance_0|0
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
custom_search_path|0
#1790.1|0|0
#1790.2|0|0
#1790.3|0|0
#1968.1|0
#1968.2|0
-tgup1.1|5|100|1
-tgup1.2|5|200|2
-tgup1.3|5|200|4
+ERROR: SQL/MM Spatial exception - geometry crosses a node
#3359.setval|1|2|1
#3359.line.1|1
-#3359.line.2|2
-#3359.area.1|1
-#3359.area.2|2
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
+ERROR: SQL/MM Spatial exception - geometry crosses a node
Topology 'tt' dropped
-----------------------------------------------------------------------------
regress/droptopology .. ok in 748 ms
regress/droptopogeometrycolumn .. ok in 454 ms
regress/copytopology .. ok in 1568 ms
regress/createtopogeom .. ok in 583 ms
regress/createtopology .. ok in 1003 ms
regress/gml .. ok in 716 ms
regress/getnodebypoint .. ok in 439 ms
regress/getedgebypoint .. ok in 436 ms
regress/getfacebypoint .. ok in 467 ms
regress/getringedges .. ok in 464 ms
regress/gettopogeomelements .. ok in 637 ms
regress/layertrigger .. ok in 758 ms
regress/validatetopology .. ok in 429 ms
uninstall . /projects/postgis/postgis-git/regress/00-regress-
install/share/contrib/postgis/uninstall_topology.sql
/projects/postgis/postgis-git/regress/00-regress-
install/share/contrib/postgis/uninstall_postgis.sql
. ok (4831)
Run tests: 51
Failed: 5
make[1]: *** [Makefile:91: check-regress] Error 5
make[1]: Leaving directory '/projects/postgis/postgis-git/topology/test'
make: *** [Makefile:141: check-regress] Error 2
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4730#comment:7>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list