test/sql_stmt_geos_tests/union22.testcase

union - GEOMETRYCOLLECTION Z (Polygon with hole / Linestring)
:memory: #use in-memory database
SELECT AsText(GUnion(GeomFromText('GEOMETRYCOLLECTIONZ(LINESTRINGZ(30 30 100, 31 31 101), POLYGONZ((10 10 100, 15 10 101, 15 15 102, 10 15 103, 10 10 100), (11 11 100, 12 11 101, 12 12 102, 11 12 103, 11 11 100)))'), GeomFromText('GEOMETRYCOLLECTIONZ(LINESTRINGZ(31 31 101, 35 0 100), POLYGONZ((15 10 101, 16 10 102, 16 15 102, 10 15 103, 15 10 101)))')));
1 # rows (not including the header row)
1 # columns
AsText(GUnion(GeomFromText('GEOMETRYCOLLECTIONZ(LINESTRINGZ(30 30 100, 31 31 101), POLYGONZ((10 10 100, 15 10 101, 15 15 102, 10 15 103, 10 10 100), (11 11 100, 12 11 101, 12 12 102, 11 12 103, 11 11 100)))'), GeomFromText('GEOMETRYCOLLECTIONZ(LINESTRINGZ(31 31 101, 35 0 100), POLYGONZ((15 10 101, 16 10 102, 16 15 102, 10 15 103, 15 10 101)))')))
GEOMETRYCOLLECTION Z(LINESTRING Z(30 30 100, 31 31 101), LINESTRING Z(31 31 101, 35 0 100), POLYGON Z((15 10 101, 10 10 100, 10 15 103, 15 15 102, 16 15 102, 16 10 102, 15 10 101), (11 11 100, 12 11 101, 12 12 102, 11 12 103, 11 11 100)))