ST_Split fails to split on existing vertex
|Reported by:||strk||Owned by:||pramsey|
select st_line_locate_point(geom, st_pointn(geom, 745)) from offending; 0.692338478022024
The return from ST_Split, unioned back togheter, does NOT give the original geometry back.
This is most likely due to the fact that the split is not occurring exactly where the original vertex is but rather on a close-by point which results in snapping a segment on the new point.