[PostGIS] #5718: `st_isvalid(point(NaN, NaN))` is true

PostGIS trac at osgeo.org
Sat Apr 20 19:05:09 PDT 2024


#5718: `st_isvalid(point(NaN, NaN))` is true
---------------------+---------------------
 Reporter:  n0099    |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:
Component:  postgis  |    Version:  3.4.x
 Keywords:           |
---------------------+---------------------
 {{{#!sql
 SELECT *, st_isvalid(a), st_x(a), st_y(a)
 FROM (SELECT
 st_pointfromwkb('\x0101000000000000000000F8FF000000000000F8FF') a) t;
 }}}
 ||=a=||=st_isvalid=||=st_x=||=st_y=||
 ||`0101000000000000000000F87F000000000000F87F`||`true`||`null`||`null`||

 and in MySQL it will get an error:
 {{{#!sql
 SELECT *, st_isvalid(a), st_x(a), st_y(a)
 FROM (SELECT st_pointfromwkb(0x0101000000000000000000F8FF000000000000F8FF)
 a) t;
 }}}
 > `[22001][3037] Data truncation: Invalid GIS data provided to function
 st_isvalid.`
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5718>
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.


More information about the postgis-tickets mailing list