[postgis-tickets] [PostGIS] #3777: POINT EMPTY, POINT 0 0 anomaly

[PostGIS]

#3777: POINT EMPTY, POINT 0 0 anomaly
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.3.3
 Component:  postgis  |    Version:  2.3.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 to remove ST_AsText out of the equation I did this:


 {{{
 SELECT geom, count(*)
 FROM (
 SELECT 'POINT(0 0)'::geometry geom
 UNION ALL
 SELECT 'POINT(0 0)'::geometry geom
 UNION ALL
 SELECT 'POINT(0 0)'::geometry geom
 UNION ALL
 SELECT 'POINT(0 1)'::geometry geom
 UNION ALL
 SELECT 'LINESTRING(0 0,0 1)'::geometry geom
 UNION ALL
 SELECT 'GEOMETRYCOLLECTION EMPTY'::geometry geom
 UNION ALL
 SELECT 'POINT EMPTY'::geometry geom
 ) foo
 GROUP BY geom;
 }}}

 In PostGIS 2.3.2 and PostgreSQL 10beta1 on x86_64-w64-mingw32, compiled by
 gcc.exe (x86_64-win32-seh-rev1, Built by MinGW-W64 project) 4.8.3, 64-bit
 POSTGIS="2.4.0dev r15435" GEOS="3.7.0dev-CAPI-1.11.0 8fe2ce6" PROJ="Rel.
 4.9.1, 04 March 2015" GDAL="GDAL 2.2.0, released 2017/04/28"
 LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" RASTER


 {{{
                                         geom
 | count
 ------------------------------------------------------------------------------------+-------
  010100000000000000000000000000000000000000
 |     2
  0101000000000000000000F87F000000000000F87F
 |     1
  010100000000000000000000000000000000000000
 |     1
 010200000002000000000000000000000000000000000000000000000000000000000000000000F03F
 |     1
  010700000000000000
 |     1
  01010000000000000000000000000000000000F03F
 |     1
 (6 rows)
 }}}




 In PostgreSQL 9.0.17, compiled by Visual C++ build 1500, 32-bit
 POSTGIS="1.5.5" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.6.1, 21 August 2008"
 LIBXML="2.7.8" USE_STATS (procs from 1.5 r7360 need upgrade), this
 returns:


 {{{
                                         geom
 | count
 ------------------------------------------------------------------------------------+-------
  010700000000000000
 |     4
 010200000002000000000000000000000000000000000000000000000000000000000000000000F03F
 |     1
  010700000000000000
 |     1
  01010000000000000000000000000000000000F03F
 |     1
 (4 rows)

 }}}

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