[postgis-tickets] [PostGIS] #4436: ST_EstimatedExtent tests and PgSQL 12

[PostGIS]

#4436: ST_EstimatedExtent tests and PgSQL 12
---------------------+---------------------------
 Reporter:  pramsey  |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  high     |  Milestone:  PostGIS 2.5.3
Component:  postgis  |    Version:  2.5.x
 Keywords:           |
---------------------+---------------------------
 The new Pg!2 CTE behaviour allowing the planner inside the optimization
 fence changes the results of some of our regression tests. For example,
 estimated_extent.sql, if called without a `MATERIALIZE` keyword will run
 the estimated extent query four times for this test (resulting in four
 warnings in the output) instead of the expected one.
 {{{
 with e as materialized ( select ST_EstimatedExtent('c1','g') as e )
 select '#3391.1', round(st_xmin(e.e)::numeric, 2),
 round(st_xmax(e.e)::numeric, 2),
 round(st_ymin(e.e)::numeric, 2), round(st_ymax(e.e)::numeric, 2) from e;
 psql: WARNING:  stats for "c1.g" do not exist
  ?column? | round | round | round | round
 ----------+-------+-------+-------+-------
  #3391.1  |       |       |       |
 (1 row)
 }}}

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