[postgis-tickets] [PostGIS] #5009: Inconsistent results when using empty geometries with different SRIDS

PostGIS trac at osgeo.org
Wed Oct 20 15:32:32 PDT 2021


#5009: Inconsistent results when using empty geometries with different SRIDS
-----------------------------+---------------------------
  Reporter:  samuelspurling  |      Owner:  pramsey
      Type:  defect          |     Status:  closed
  Priority:  low             |  Milestone:  PostGIS 3.1.5
 Component:  postgis         |    Version:  3.1.x
Resolution:  wontfix         |   Keywords:
-----------------------------+---------------------------
Changes (by robe):

 * status:  new => closed
 * resolution:   => wontfix


Comment:

 Okay so with the index, no fail.

 And when drop index


 {{{
 DROP INDEX test_table_lines_geom_idx;

 SELECT *
 FROM test_table_lines t
 WHERE st_dwithin(st_setsrid(ST_GeomFromText('MULTILINESTRING EMPTY'), 0),
 t.geom, 1);
 }}}

 Bam fail with:


 {{{
 ERROR:  LWGEOM_dwithin: Operation on mixed SRID geometries
 (MultiLineString, 0) != (LineString, 27700)
 SQL state: XX000
 }}}

 That said yes it's a regression and the behavior is not the same. That
 said is this something we can even fix even if we cared to fix it without
 some dier consequences?  I think the answer is NO.

 So marking this as a won't fix.

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


More information about the postgis-tickets mailing list