[PostGIS] #5782: XX000: Corrupted topology: adjacent edges 33 and -32 bind different face (1 and 0)

[PostGIS]

#5782: XX000: Corrupted topology: adjacent edges 33 and -32 bind different face (1
and 0)
-------------------------------+---------------------------
 Reporter:  Lars Aksel Opsahl  |      Owner:  pramsey
     Type:  defect             |     Status:  new
 Priority:  high               |  Milestone:  PostGIS 3.5.0
Component:  postgis            |    Version:
 Keywords:                     |
-------------------------------+---------------------------
 When running this code on


 {{{
 select topology.CreateTopology ('rmp_temp_data_01_5526_2', 4258, 1e-06);

 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A21000001D000000C0B380A8B5ED31406FD0A859974251404D4BDD9059EE314001698EEF8542514025A7A28A1CEF31404BEE5D0089425140B647DCB92AEF3140F91A58BB88425140878B46E737EF31400CF351CB8642514026A9D32B45EF3140173B6ED784425140FCFAF3556FEF31408A4851A37E425140D53A5284A9F03140005B796950425140C84AD83876F13140B4626EEB31425140F56FE7A72DF3314095AF7E06F14151409BD40C6BBEF33140A6A28A79DB4151403D887331EDF33140B77DA182D44151401FFFF38F55F4314018976FF7C441514091407B9F76F63140380F100EA641514078321D710AF7314061F3C7AB9D415140801488974BF731408CD435C49B4151405AEB4E273BF831405F985B07A14151402C2C4D6B5AF9314044AB3CC89A415140D7F2B7D786FA3140100A8988914151405500D5FADAFA314050CB49418F41514086878F6946FB3140C630D96E87415140577F478F94FB3140B203F92D804151407A9B1193FAFB3140CCA9897F774151401CB8BD1C7DFC31402C9556ED6C415140EFA8F8EC66FD314053AF581459415140A101AD3649FE31404BEC0C7146415140BD0FE29813FF314000285E3A354151400A5EA0548AFF3140ED0E8EB725415140FD6D3FA5D70532402C9DFD7B2D405140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A2100000030000007E32E78A3EEF314049272DD185425140D469DD2B45EF3140424E6ED7844251401AA1CDBA52EF31407F21C1D882425140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A2100000030000001AA1CDBA52EF31407F21C1D882425140D469DD2B45EF3140424E6ED7844251407E32E78A3EEF314049272DD185425140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A21000000300000038955FC948F3314046DA87FCEC4151408D3FDDA72DF331405E0B8106F14151400AC4A273D2F23140B16F7F7EFE415140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A2100000030000000AC4A273D2F23140B16F7F7EFE4151408D3FDDA72DF331405E0B8106F141514038955FC948F3314046DA87FCEC415140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A210000003000000829FE21B0BF83140ED302FF99F415140015C87974BF73140FE133AC49B415140D6F13F5D1FF73140FCA4330F9D415140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A210000003000000D6F13F5D1FF73140FCA4330F9D415140015C87974BF73140FE133AC49B415140829FE21B0BF83140ED302FF99F415140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A2100000030000000A1BAAA8B5ED31406FD0A85997425140653CEF9059EE3140AA8591EF85425140CBA0469CF6EE3140F40FB06788425140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A210000003000000CBA0469CF6EE3140F40FB06788425140653CEF9059EE3140AA8591EF854251400A1BAAA8B5ED31406FD0A85997425140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A2100000030000006406657B10F13140AA28181341425140B3964C84A9F03140EC847D69504251406A5784D908F03140E6C41C0D68425140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A2100000030000006A5784D908F03140E6C41C0D68425140B3964C84A9F03140EC847D69504251406406657B10F13140AA28181341425140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A2100000040000002279EF8639F431409BB84F24C94151400DAF039055F43140B0F46EF7C4415140CDE2729F76F6314070FE140EA6415140AB506A8DDEF63140AF9D0A29A0415140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A210000004000000AB506A8DDEF63140AF9D0A29A0415140CDE2729F76F6314070FE140EA64151400DAF039055F43140B0F46EF7C44151402279EF8639F431409BB84F24C9415140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A21000000900000048A235EF1FFE314050AB6CD749415140B751F8EC66FD3140416B5C14594151402F8CBA1C7DFC3140BA4357ED6C41514066F00793FAFB3140103A8C7F774151405EF2478F94FB31409ECEFB2D804151400F18A06946FB3140CD0CD86E87415140C327E7FADAFA314022DF49418F4151408F57A4D786FA3140DF688C8891415140D45198BF82F93140F4B5648A99415140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A210000009000000D45198BF82F93140F4B5648A994151408F57A4D786FA3140DF688C8891415140C327E7FADAFA314022DF49418F4151400F18A06946FB3140CD0CD86E874151405EF2478F94FB31409ECEFB2D8041514066F00793FAFB3140103A8C7F774151402F8CBA1C7DFC3140BA4357ED6C415140B751F8EC66FD3140416B5C145941514048A235EF1FFE314050AB6CD749415140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A21000000400000063ABC5BD19023240DDE24BDFC04051408173B1548AFF314037B38DB7254151401D5AE89813FF3140478F623A3541514025ED461466FE3140EA6988FC43415140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A21000000400000025ED461466FE3140EA6988FC434151401D5AE89813FF3140478F623A354151408173B1548AFF314037B38DB72541514063ABC5BD19023240DDE24BDFC0405140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A21000000600000030A2B312C1013240A5B7CAE695425140A349BD27BC0132407B0E54EC954251406EC47A65BC0132400FC3FC5C9642514002BAF5E0BC013240C8A5633E974251408E12ECCBC1013240F14EDA38974251409437EBDDC10132406FD0A85997425140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A2100000090000009437EBDDC10132406FD0A859974251408E12ECCBC1013240F14EDA389742514002BAF5E0BC013240C8A5633E97425140383F38A3BC0132406C34B0CD96425140A349BD27BC0132407B0E54EC9542514030A2B312C1013240A5B7CAE6954251406527F6D4C00132404846177695425140B35F5E42E3013240FB5F6B4F954251407D7EF737E30132402E46963C95425140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A21000000A0000007D7EF737E30132402E46963C95425140A6D2F4A3D80132409C40294E95425140E7C82D7FCE013240A5E8784495425140C97C40C5C3013240A5D5B85D954251405331E7A1B501324046381B7295425140AB4F492DAC013240728C84C3954251403C56C637A8013240109CCF9D95425140CE87F3D7AE013240E001D78596425140AC72676CB601324050C6F756974251400F7E7782B60132406FD0A85997425140',0);
 SELECT abs(topogeo_addlinestring) FROM
 topology.TopoGeo_addLinestring('rmp_temp_data_01_5526_2','0102000020A21000002A000000855F31A8D00132406FD0A859974251406F02258DD0013240360749289742514050F25D4EDF013240B302AD179742514013EF6B0FEE013240F7BA1B0797425140499383E5F70132404B0D09FC964251409D2AC6BB01023240661C01F196425140B5BCDD7D0102324009AB4D8096425140EC60F5530B0232405DFD3A759642514022E637160B023240018C870496425140CC31590110023240F2F108FF95425140588A4FEC140232401C9B7FF9954251408E0F92AE14023240C029CC88954251401A68889919023240E9D242839542514050EDCA5B190232408D618F1295425140FA38EC461E023240B70A060D95425140A15B221B1E02324025BC34BD9442514012E9F17F1D0232400D3994B694425140E35431DB1C0232404932AA9D94425140D9527AAA19023240D22F5A2294425140B1E9BD2D15023240AC807253934251400566741B15023240203F2250934251400B671AE61402324020AABD5393425140F909F38513023240F9BAB06B934251409D0F19C50E023240BD7151BE93425140F6AA63F40D02324011B17ECC934251405E086A040A02324049E5FC1094425140E2EEAC0207023240C9744A45944251404E9D0D3F06023240C0379652944251408490873E0502324019E74D5A944251400FFC0365000232409627CD7F94425140EE9736DEFB0132405529C8A294425140CCC97A45F80132408D9ACFC69442514073F631B8F6013240962F5FD6944251402E92B8E4F1013240DB6DBB06954251408993A8FAEF013240AB2AF11995425140B6D8921FE8013240430FCD3095425140D0D6873BE5013240DA473B39954251407D7EF737E30132402E46963C95425140B35F5E42E3013240FB5F6B4F954251407CBB466CD9013240E050735A954251406527F6D4C0013240484617769542514030A2B312C1013240A5B7CAE695425140',0);

 }}}

 is tested in this this versions

 {{{
 POSTGIS="3.5.0dev 3.4.0rc1-1272-g80806376a" [EXTENSION] PGSQL="160"
 GEOS="3.12.1-CAPI-1.18.1" PROJ="9.4.0 NETWORK_ENABLED=OFF
 URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=/Users/lop/Library/Application Support/proj
 DATABASE_PATH=/opt/homebrew/Cellar/proj/9.4.0/share/proj/proj.db"
 (compiled against PROJ 9.12.1) LIBXML="2.13.0" LIBJSON="0.17" TOPOLOGY
 }}}

 and also on

 {{{

 POSTGIS="3.5.0dev 3.4.0rc1-1310-g8349e1670" [EXTENSION] PGSQL="160"
 GEOS="3.13.0-CAPI-1.19.0" PROJ="9.3.0 NETWORK_ENABLED=OFF
 URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/tmp/proj
 DATABASE_PATH=/usr/local/share/proj/proj.db" (compiled against PROJ
 9.13.0) LIBXML="2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0
 (Internal)" TOPOLOGY
 }}}

 and


 {{{
 POSTGIS="3.4.2 c19ce56" [EXTENSION] PGSQL="160" GEOS="3.12.1-CAPI-1.18.1"
 (compiled against GEOS 3.10.2) SFCGAL="SFCGAL 1.4.1, CGAL 5.3.1, BOOST
 1.74.0" PROJ="8.2.1 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db"
 GDAL="GDAL 3.4.1, released 2021/12/27" LIBXML="2.9.13" LIBJSON="0.15"
 LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER

 }}}

 it fails on all
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5782>
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.