1union - GEOMETRYCOLLECTION M (Polygon with hole / Linestring) 2:memory: #use in-memory database 3SELECT AsText(GUnion(GeomFromText('GEOMETRYCOLLECTIONM(LINESTRINGM(30 30 1, 31 31 2), POLYGONM((10 10 1, 15 10 2, 15 15 3, 10 15 4, 10 10 1), (11 11 1, 12 11 2, 12 12 3, 11 12 4, 11 11 1)))'), GeomFromText('GEOMETRYCOLLECTIONM(LINESTRINGM(31 31 2, 35 0 1), POLYGONM((15 10 2, 16 10 1, 16 15 3, 10 15 4, 15 10 2)))'))); 41 # rows (not including the header row) 51 # columns 6AsText(GUnion(GeomFromText('GEOMETRYCOLLECTIONM(LINESTRINGM(30 30 1, 31 31 2), POLYGONM((10 10 1, 15 10 2, 15 15 3, 10 15 4, 10 10 1), (11 11 1, 12 11 2, 12 12 3, 11 12 4, 11 11 1)))'), GeomFromText('GEOMETRYCOLLECTIONM(LINESTRINGM(31 31 2, 35 0 1), POLYGONM((15 10 2, 16 10 1, 16 15 3, 10 15 4, 15 10 2)))'))) 7GEOMETRYCOLLECTION M(LINESTRING M(30 30 0, 31 31 0), LINESTRING M(31 31 0, 35 0 0), POLYGON M((15 10 0, 10 10 0, 10 15 0, 15 15 0, 16 15 0, 16 10 0, 15 10 0), (11 11 0, 12 11 0, 12 12 0, 11 12 0, 11 11 0))) 8