[postgis-tickets] [PostGIS] #4329: PostgreSQL 12 many regression failures rounding and extra warning output

[PostGIS]

#4329: PostgreSQL 12 many regression failures rounding and extra warning output
----------------------+---------------------------
  Reporter:  robe     |      Owner:  robe
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.5.2
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:  postgres 12
----------------------+---------------------------

Comment (by robe):

 In [changeset:"17268" 17268]:
 {{{
 #!CommitTicketReference repository="" revision="17268"
 Missed some spots in last commit
 Change from using CTE to use subquery so results are the same across all
 platforms
 reason necessary in PostgreSQL 12, CTE changed from being always
 materialized to being often inlined.
 This means PG12, no longer behaves like old CTE and behaves more like
 subquery.
 As a result 12 CTE is outputting 4 warnings instead of 1 like older
 versions.
 Changing to just subquery should force all to output 4 warnings.
 references #4329 for PostGIS 3.0
 }}}

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