PostGIS Raster driver: Crashes in mode 2 with rotated, non missign tiles, side by side

[pracine]

The driver crashes with this command:

C:\Windows\System32>gdal_translate -oF GTiff "PG:host='localhost' dbname='test3' user='postgres' password='1postgres' ta
ble='test06' mode=2" c:/temp/test06-mode2.tif

on this table:

CREATE TABLE test06 AS
SELECT 1 rid, ST_MapAlgebraExpr(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0,   0, 0.1, -0.1, 0.05, 0.05, 4269), '8BUI'::text, 1, 0), '32BUI', '([rast.x] - 1) * 10 + [rast.y]') rast 
UNION ALL 
SELECT 2 rid, ST_MapAlgebraExpr(ST_AddBand(ST_MakeEmptyRaster(10, 10, 1, 0.5, 0.1, -0.1, 0.05, 0.05, 4269), '8BUI'::text, 1, 0), '32BUI', '([rast.x] - 1) * 10 + [rast.y]') rast;

Not crashing is one thing, supporting this raster arrangement is another thing.

[pracine]

This table might be a little more complex has it has two tiles missing:

CREATE TABLE test05 AS
SELECT 1 rid, ST_MapAlgebraExpr(ST_AddBand(ST_MakeEmptyRaster(10, 10,   0,   0, 0.1, -0.1, 0.05, 0.05, 4269), '8BUI'::text, 1, 0), '32BUI', '([rast.x] - 1) * 10 + [rast.y]') rast 
UNION ALL 
SELECT 2 rid, ST_MapAlgebraExpr(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0.5, 1.5, 0.1, -0.1, 0.05, 0.05, 4269), '8BUI'::text, 1, 0), '32BUI', '([rast.x] - 1) * 10 + [rast.y]') rast;

[Even Rouault]

Removing obsolete milestone

[Even Rouault]

All those tickets have more than one year and nobody has acted on it, so the priority is not so high

[Even Rouault]

This ticket has been automatically closed because Trac is no longer used for GDAL bug tracking, since the project has migrated to GitHub. If you believe this ticket is still valid, you may file it to ​https://github.com/OSGeo/gdal/issues if it is not already reported there.