[postgis-tickets] [PostGIS] #4785: Proj master branch (7.2.0) rergess failuers

[PostGIS]

#4785: Proj master branch (7.2.0) rergess failuers
----------------------------+---------------------------
 Reporter:  Taro Matsuzawa  |      Owner:  pramsey
     Type:  defect          |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 3.1.0
Component:  postgis         |    Version:  master
 Keywords:                  |
----------------------------+---------------------------
 I'm working on [https://github.com/postgis/docker-postgis/pull/211 docker-
 postgis multistage build].

 I find current proj master (7.2.0) will fail regress test.

 {{{
 root at 299eff78c5c7:/tmp/pgis_reg# cat test_103_diff
 --- tickets_expected    2020-11-04 05:44:04.975681093 +0000
 +++ /tmp/pgis_reg/test_103_out  2020-11-04 05:46:40.753850135 +0000
 @@ -195,7 +195,7 @@
  #1543|MULTILINESTRING((0 0,10 0,10 10,0 0),(0 0))|POLYGON((0 0,10 10,10
 0,0 0))
  #1578|f|f
  #1580.1|Point[S]
 -ERROR:  transform: tolerance condition error (-20)
 +#1580.2|0101000020430D000093107C45F81B7341B97937FF14E8AC41
  #1580.3|Point[S]
  #1596.1|public.road_pg.roads_geom SRID:3395 TYPE:POINT DIMS:2
  ERROR:  invalid SRID: 330000 not found in spatial_ref_sys
 }}}

 The patch only pass test.

 {{{
 diff --git a/regress/core/tickets.sql b/regress/core/tickets.sql
 index abb39264f..3df953b11 100644
 --- a/regress/core/tickets.sql
 +++ b/regress/core/tickets.sql
 @@ -591,7 +591,6 @@ select '#1578', st_within(p, mp), st_intersects(p, mp)
 FROM inp;

  -- #1580
  select '#1580.1', ST_Summary(ST_Transform('SRID=4326;POINT(0
 0)'::geometry, 3395));
 -select '#1580.2', ST_Transform('SRID=4326;POINT(180 90)'::geometry,
 3395); -- fails
  select '#1580.3', ST_Summary(ST_Transform('SRID=4326;POINT(0
 0)'::geometry, 3395));

  -- #1596 --
 diff --git a/regress/core/tickets_expected b/regress/core/tickets_expected
 index d0cc88a3e..701510256 100644
 --- a/regress/core/tickets_expected
 +++ b/regress/core/tickets_expected
 @@ -195,7 +195,6 @@ ERROR:  got NULL for SRID (500001)
  #1543|MULTILINESTRING((0 0,10 0,10 10,0 0),(0 0))|POLYGON((0 0,10 10,10
 0,0 0))
  #1578|f|f
  #1580.1|Point[S]
 -ERROR:  transform: tolerance condition error (-20)
  #1580.3|Point[S]
  #1596.1|public.road_pg.roads_geom SRID:3395 TYPE:POINT DIMS:2
  ERROR:  invalid SRID: 330000 not found in spatial_ref_sys
 }}}

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