[postgis-tickets] r16610 - Debbie / Postgres 9.4 calls function twice.

Darafei komzpa at gmail.com
Wed Jun 6 02:29:33 PDT 2018


Author: komzpa
Date: 2018-06-06 02:29:33 -0700 (Wed, 06 Jun 2018)
New Revision: 16610

Modified:
   trunk/regress/tickets.sql
Log:
Debbie / Postgres 9.4 calls function twice.

References #4103



Modified: trunk/regress/tickets.sql
===================================================================
--- trunk/regress/tickets.sql	2018-06-05 17:11:34 UTC (rev 16609)
+++ trunk/regress/tickets.sql	2018-06-06 09:29:33 UTC (rev 16610)
@@ -1088,8 +1088,7 @@
 --#4089
 select '#4089', st_astext(st_geomfromtwkb(st_AsTWKB(st_GeometryFromText('LINESTRING Z(1 1 1, 3 3 1)'), 1, 0, 0, false, true)));
 
-select '#4103', ST_Intersects(ST_PointOnSurface(geom), geom)
-from (select '0103000020110F0000010000000A000000000000C41E644741000000EEA2A75A41000000F420644741000000629EA75A410000007A2D644741000000E49FA75A41000000C02E644741000000409DA75A41000000286A64474100000064A4A75A410000007867644741000000FAA9A75A41000000E82B644741000000D2A2A75A41000000222D64474100000046A0A75A41000000242B6447410000006CA4A75A41000000C41E644741000000EEA2A75A41'::geometry geom) z;
+select '#4103', ST_Intersects(ST_PointOnSurface('0103000020110F0000010000000A000000000000C41E644741000000EEA2A75A41000000F420644741000000629EA75A410000007A2D644741000000E49FA75A41000000C02E644741000000409DA75A41000000286A64474100000064A4A75A410000007867644741000000FAA9A75A41000000E82B644741000000D2A2A75A41000000222D64474100000046A0A75A41000000242B6447410000006CA4A75A41000000C41E644741000000EEA2A75A41'::geometry), '0103000020110F0000010000000A000000000000C41E644741000000EEA2A75A41000000F420644741000000629EA75A410000007A2D644741000000E49FA75A41000000C02E644741000000409DA75A41000000286A64474100000064A4A75A410000007867644741000000FAA9A75A41000000E82B644741000000D2A2A75A41000000222D64474100000046A0A75A41000000242B6447410000006CA4A75A41000000C41E644741000000EEA2A75A41'::geometry);
 
 -- Clean up
 DELETE FROM spatial_ref_sys;



More information about the postgis-tickets mailing list