[postgis-tickets] [PostGIS] #5082: st_linelocatepoint returns value over 1

[PostGIS]

#5082: st_linelocatepoint returns value over 1
--------------------------------+--------------------------------
 Reporter:  andrest             |      Owner:  pramsey
     Type:  defect              |     Status:  new
 Priority:  medium              |  Milestone:  PostGIS PostgreSQL
Component:  postgis             |    Version:  3.1.x
 Keywords:  st_linelocatepoint  |
--------------------------------+--------------------------------
 Trying to run line_interpolate_point gets an error because of:
 1.      ERROR: line_interpolate_point: 2nd arg isn't within [0,1]
 [[br]]
 The second argument calls st_linelocatepoint, which should return qua
 definition values between 0 and 1.
 [[br]]
 Verification:
 Query select x,y,st_linelocatepoint(the_geom, the_geom2) station from zzz
 where st_linelocatepoint(x.the_geom, y.the_geom) >1 ;
 --> returns a row
 [[br]]
 But output of station showed in pgadmin is only "1".
 [[br]]
 Error on:
 PostgreSQL 11.12 (Debian 11.12-1.pgdg90+1) on x86_64-pc-linux-gnu,
 compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
 POSTGIS="3.1.2 cbe925d" [EXTENSION] PGSQL="110" GEOS="3.7.1-CAPI-1.11.1
 27a5e771" PROJ="Rel. 4.9.3, 15 August 2016" LIBXML="2.9.4"
 LIBJSON="0.12.1" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"
 [[br]]
 [[br]]
 No error:
 "PostgreSQL 11.11, compiled by Visual C++ build 1914, 64-bit
 POSTGIS=""3.0.3 3.0.3"" [EXTENSION] PGSQL=""110""
 GEOS=""3.8.1-CAPI-1.13.3"" PROJ=""7.1.1"" LIBXML=""2.9.9""
 LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.4.3 (Internal)"""

 ---
 PostgreSQL 11.14, compiled by Visual C++ build 1914, 64-bit POSTGIS="3.1.0
 3.1.0" [EXTENSION] PGSQL="110" GEOS="3.9.0-CAPI-1.14.1" PROJ="7.1.1"
 LIBXML="2.9.9" LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"
 [[br]]



 PostgreSQL 11.12 (Debian 11.12-1.pgdg90+1) on x86_64-pc-linux-gnu,
 compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
 POSTGIS="3.1.2 cbe925d" [EXTENSION] PGSQL="110" GEOS="3.7.1-CAPI-1.11.1
 27a5e771" PROJ="Rel. 4.9.3, 15 August 2016" LIBXML="2.9.4"
 LIBJSON="0.12.1" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5082>
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.