[SCM] PostGIS branch master updated. 3.6.0rc2-700-gdc6337753
git at osgeo.org
git at osgeo.org
Tue Jun 30 22:45:06 PDT 2026
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".
The branch, master has been updated
via dc6337753b8ce98dde25fc260bfad194ef430b4e (commit)
via be75f1e94293bbbc68ec187fb6ac9ece870ee6a1 (commit)
from b6204431fcfdb386ca58fe495fa23bdbd5461b5b (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit dc6337753b8ce98dde25fc260bfad194ef430b4e
Merge: b6204431f be75f1e94
Author: Darafei Praliaskouski <me at komzpa.net>
Date: Wed Jul 1 09:44:24 2026 +0400
Merge pull request https://github.com/postgis/postgis/pull/906
raster: add ST_Union band type regression
commit be75f1e94293bbbc68ec187fb6ac9ece870ee6a1
Author: Darafei Praliaskouski <me at komzpa.net>
Date: Wed Jun 17 01:43:18 2026 +0400
raster: add ST_Union band type regression
Closes #5317
diff --git a/raster/test/regress/rt_union.sql b/raster/test/regress/rt_union.sql
index fb93ae042..13decca06 100644
--- a/raster/test/regress/rt_union.sql
+++ b/raster/test/regress/rt_union.sql
@@ -76,6 +76,52 @@ FROM (
) foo
ORDER BY uniontype, y, x;
+WITH v(rast) AS (
+ VALUES (
+ ST_AddBand(
+ ST_AddBand(ST_MakeEmptyRaster(1, 1, 0, 0, 1, -1, 0, 0, 0), 1, '8BUI', 10, 0),
+ 2, '16BUI', 300, 0
+ )
+ ), (
+ ST_AddBand(
+ ST_AddBand(ST_MakeEmptyRaster(1, 1, 0, 0, 1, -1, 0, 0, 0), 1, '8BUI', 20, 0),
+ 2, '16BUI', 400, 0
+ )
+ )
+), u AS (
+ SELECT ST_Union(rast, ARRAY[ROW(1, 'SUM'), ROW(2, 'MAX')]::unionarg[]) AS rast
+ FROM v
+)
+SELECT
+ 'ticket-5317-array',
+ ST_BandPixelType(rast, 1),
+ ST_Value(rast, 1, 1, 1),
+ ST_BandPixelType(rast, 2),
+ ST_Value(rast, 2, 1, 1)
+FROM u;
+
+WITH v(rast) AS (
+ VALUES (
+ ST_AddBand(
+ ST_AddBand(ST_MakeEmptyRaster(1, 1, 0, 0, 1, -1, 0, 0, 0), 1, '8BUI', 10, 0),
+ 2, '16BUI', 300, 0
+ )
+ ), (
+ ST_AddBand(
+ ST_AddBand(ST_MakeEmptyRaster(1, 1, 0, 0, 1, -1, 0, 0, 0), 1, '8BUI', 20, 0),
+ 2, '16BUI', 400, 0
+ )
+ )
+), u AS (
+ SELECT ST_Union(rast, 2, 'MAX') AS rast
+ FROM v
+)
+SELECT
+ 'ticket-5317-band',
+ ST_BandPixelType(rast, 1),
+ ST_Value(rast, 1, 1, 1)
+FROM u;
+
TRUNCATE raster_union_out;
TRUNCATE raster_union_in;
diff --git a/raster/test/regress/rt_union_expected b/raster/test/regress/rt_union_expected
index 699b9df4d..8f32317be 100644
--- a/raster/test/regress/rt_union_expected
+++ b/raster/test/regress/rt_union_expected
@@ -52,6 +52,8 @@ SUM|2|2|3
SUM|3|2|2
SUM|2|3|2
SUM|3|3|2
+ticket-5317-array|8BUI|30|16BUI|400
+ticket-5317-band|16BUI|400
NOTICE: No pixels found for band 1
COUNT|1|1|1
COUNT|2|1|1
-----------------------------------------------------------------------
Summary of changes:
raster/test/regress/rt_union.sql | 46 +++++++++++++++++++++++++++++++++++
raster/test/regress/rt_union_expected | 2 ++
2 files changed, 48 insertions(+)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list