[postgis-tickets] [PostGIS] #3957: ST_StartPoint - not works correctly

[PostGIS]

#3957: ST_StartPoint - not works correctly
----------------------+---------------------------
  Reporter:  sanyasi  |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.4.3
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+---------------------------
Description changed by robe:

Old description:

> In the Quantum, I draw a point, and the line emerging from it.
>
> 1) select
> ST_x(ST_StartPoint(geo)),ST_y(ST_StartPoint(geo)),ST_StartPoint(geo),geo
> from devicelink WHERE "gid"=17178;
>
> 2) SELECT ST_x(geo),ST_y(geo),geo FROM map.devices WHERE
> ip='192.168.1.1';
>
> 1)
> 36.1191425241613;56.7842403055775;"0101000020E6100000F46AEE0F400F4240825480FC61644C40";"0102000020E610000002000000F46AEE0F400F4240825480FC61644C401998EA8F410F4240DCEC82F163644C40"
>
> 2)
> 36.1191425241613;56.7842403055775;"0101000020E6100000F76AEE0F400F4240835480FC61644C40"
>

> "PostgreSQL 9.5.10 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
> 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bit POSTGIS="2.4.2 r16113" PGSQL="95"
> GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL
> 1.10.1, released 2013/08/26" LIBXML="2.9.1" L (...)"
>

> POSTGIS="2.3.2" works correctly

New description:

 In the Quantum, I draw a point, and the line emerging from it.

 1)
 {{{
 select
 ST_x(ST_StartPoint(geo)),ST_y(ST_StartPoint(geo)),ST_StartPoint(geo),geo
 from devicelink WHERE "gid"=17178;
 }}}


 2)
 {{{
 SELECT ST_x(geo),ST_y(geo),geo FROM map.devices WHERE ip='192.168.1.1';
 }}}


 1)
 {{{
 36.1191425241613;56.7842403055775;"0101000020E6100000F46AEE0F400F4240825480FC61644C40";"0102000020E610000002000000F46AEE0F400F4240825480FC61644C401998EA8F410F4240DCEC82F163644C40"
 }}}


 2)
 {{{
 36.1191425241613;56.7842403055775;"0101000020E6100000F76AEE0F400F4240835480FC61644C40"
 }}}



 "PostgreSQL 9.5.10 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bit POSTGIS="2.4.2 r16113" PGSQL="95"
 GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL
 1.10.1, released 2013/08/26" LIBXML="2.9.1" L (...)"


 POSTGIS="2.3.2" works correctly

--

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3957#comment:1>
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.