Opened 2 years ago
#5082 new defect
st_linelocatepoint returns value over 1
| Reported by: | andrest | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS PostgreSQL |
| Component: | postgis | Version: | 3.1.x |
| Keywords: | st_linelocatepoint | Cc: |
Description
Trying to run line_interpolate_point gets an error because of:
- ERROR: line_interpolate_point: 2nd arg isn't within [0,1]
The second argument calls st_linelocatepoint, which should return qua definition values between 0 and 1.
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
But output of station showed in pgadmin is only "1".
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)"
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)"
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)"
