Bug#1031410: Closing p-u requests for fixes included in 11.7

[Stephan Großberndt <s.grossberndt@sidebysite.de>]

Hi,

after further investigation this looks more like a bug in the backport.

At first I thought the change was about flipping x and y for all 
coordinate systems except those containing "lat/lon", which did not make 
much sense to me, but I would have been willing to accept this.

But apparently this flip is only in this PostGIS 3.1.1+dfsg-1+deb11u1 
version, earlier and later PostGIS versions correctly return x as x and 
y as y.

For this query:

SELECT 
ST_AsGeoJSON(ST_Transform(ST_SetSRID('0101000020110F000004F0844A1349264120ED527FE9DD5841'::geometry, 
3857), 31466));

the following versions correctly return x=2539841,y=5586869:

- PostgresQL 11 with PostGIS 2.5.1+dfsg-1 from Debian Sources
- PostgresQL 11 with PostGIS 2.5.5+dfsg-1.pgdg100+2 from PostgreSQL Sources
- PostgresQL 13 with PostGIS 3.1.1+dfsg-1 from Debian Sources
- PostgresQL 13 with PostGIS 3.3.2+dfsg-1.pgdg110+1 from Debian Sources


Only

- PostgresQL 13 with PostGIS 3.1.1+dfsg-1+deb11u1 from Debian Sources

incorrectly returns x=5586869,y=2539841

Should I file another bug report for this?

Regards,
Stephan Großberndt