[postgis-tickets] r14410 - Add test for (non-literal) NULL TopoElementArray
Sandro Santilli
strk at keybit.net
Fri Nov 20 11:00:04 PST 2015
Author: strk
Date: 2015-11-20 11:00:04 -0800 (Fri, 20 Nov 2015)
New Revision: 14410
Modified:
trunk/topology/test/regress/topoelementarray_agg.sql
trunk/topology/test/regress/topoelementarray_agg_expected
Log:
Add test for (non-literal) NULL TopoElementArray
Modified: trunk/topology/test/regress/topoelementarray_agg.sql
===================================================================
--- trunk/topology/test/regress/topoelementarray_agg.sql 2015-11-20 18:42:02 UTC (rev 14409)
+++ trunk/topology/test/regress/topoelementarray_agg.sql 2015-11-20 19:00:04 UTC (rev 14410)
@@ -1,8 +1,13 @@
set client_min_messages to WARNING;
-SELECT 1,topology.TopoElementArray_agg('{1,3}'::topology.TopoElement);
+SELECT 1, topology.TopoElementArray_agg('{1,3}'::topology.TopoElement);
SELECT 2, topology.TopoElementArray_agg(e) from (
- select '{4,1}'::topology.TopoElement as e union
- select '{5,2}'
-) as foo;
+ VALUES ('{4,1}'::TopoElement),
+ ('{5,2}')
+) as foo(e);
+
+-- See https://trac.osgeo.org/postgis/ticket/3372
+SELECT 3, topology.TopoElementArray_agg(e) from (
+ SELECT '{4,1}'::TopoElement WHERE false
+) as foo(e);
Modified: trunk/topology/test/regress/topoelementarray_agg_expected
===================================================================
--- trunk/topology/test/regress/topoelementarray_agg_expected 2015-11-20 18:42:02 UTC (rev 14409)
+++ trunk/topology/test/regress/topoelementarray_agg_expected 2015-11-20 19:00:04 UTC (rev 14410)
@@ -1,2 +1,3 @@
1|{{1,3}}
2|{{4,1},{5,2}}
+3|
More information about the postgis-tickets
mailing list