rasql - different output from project() between centos 7 and ubuntu 22.04

[Bang Pham Huu]

The test coverage is from wcst_import test.

sdom() of test_world_temp collection is: [0:35,0:17]

Run this query:

SELECT encode(project( c[0:35,0:8], "-180,0,180,90", "EPSG:4326", "EPSG:3857", near ), "image/png" ,\"nodata\":[]}") FROM test_world_temp AS c

• on centos 7, it returns grid domains:

Size is 33, 17

• on ubuntu 22.04, it returns grid domains:

Size is 6, 37

The test case for it is test_wcs/queries/196-subsettingCrs_3857_proper_bounds_check.kvp in system test.

[Dimitar Misev]

looks like a flipped axis problem to me?

[Bang Pham Huu]

NOTE: the problem is due to gdal changed behavior for Ubuntu 22.04. To reproduce, create a tiff file:

rasql -q 'select encode(c[0:38,0:8], "tiff") from test_mean_summer_airtemp as c' --out file
gdal_translate -a_ullr -180 90 180 0 rasql_1.tif -a_srs EPSG:4326 test.tiff

then warp it to compared on centos 7 and ubuntu 22.04

gdalwarp test.tiff -t_srs EPSG:3857 warp.tiff

On centos 7, it returns:

Creating output file that is 39P x 10L.

On ubuntu 22.04, it returns:

Creating output file that is 7P x 39L.