[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