#################################################### # Requirement F-13a: # # CAST(... AS GEOMCOLLECTION) must give the same # # same result as CAST(... AS GEOMETRYCOLLECTION) # #################################################### # # Casting using CAST(... AS GEOMETRYCOLLECTION) must be allowed. # Must return geometrycollection. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(1 1)) # # Casting using CAST(... AS GEOMCOLLECTION) must be allowed. # Must return geometrycollection. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMCOLLECTION)) GEOMETRYCOLLECTION(POINT(1 1)) # #################################################### # Requirement F-13b: # # CAST(point AS GEOMETRYCOLLECTION) # #################################################### # # Casting from POINT to GEOMETRYCOLLECTION is always allowed. # Must return geometrycollection. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(1 1)) # Must return 1. SELECT ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))'), CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMETRYCOLLECTION)); ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))'), CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMETRYCOLLECTION)) 1 # #################################################### # Requirement F-13c: # # CAST(linestring AS GEOMETRYCOLLECTION) # #################################################### # # Casting from LINESTRING to GEOMETRYCOLLECTION is always allowed. # Must return geometrycollection. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(LINESTRING(1 1,2 2)) # Must return 1. SELECT ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))'), CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS GEOMETRYCOLLECTION)); ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))'), CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS GEOMETRYCOLLECTION)) 1 # #################################################### # Requirement F-13d: # # CAST(polygon AS GEOMETRYCOLLECTION) # #################################################### # # Casting from POLYGON to GEOMETRYCOLLECTION is always allowed. # Must return geometrycollection. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1), (2 2, 3 2, 3 3, 2 3, 2 2))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1), (2 2, 3 2, 3 3, 2 3, 2 2))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POLYGON((1 1,4 1,4 4,1 4,1 1),(2 2,2 3,3 3,3 2,2 2))) # Must return 1. SELECT ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((1 1, 4 1, 4 4, 1 4, 1 1), (2 2, 3 2, 3 3, 2 3, 2 2)))'), CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1), (2 2, 3 2, 3 3, 2 3, 2 2))') AS GEOMETRYCOLLECTION)); ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((1 1, 4 1, 4 4, 1 4, 1 1), (2 2, 3 2, 3 3, 2 3, 2 2)))'), CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1), (2 2, 3 2, 3 3, 2 3, 2 2))') AS GEOMETRYCOLLECTION)) 1 # #################################################### # Requirement F-13e: # # CAST(multipoint AS GEOMETRYCOLLECTION) # #################################################### # # Casting from MULTIPOINT to GEOMETRYCOLLECTION is always allowed. # Must return geometrycollection. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(1 1),POINT(2 2)) # Must return 1. SELECT ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), POINT(2 2))'), CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS GEOMETRYCOLLECTION)); ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), POINT(2 2))'), CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS GEOMETRYCOLLECTION)) 1 # #################################################### # Requirement F-13f: # # CAST(multilinestring AS GEOMETRYCOLLECTION) # #################################################### # # Casting from MULTILINESTRING to GEOMETRYCOLLECTION is always allowed. # Must return geometrycollection. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(LINESTRING(1 1,2 2),LINESTRING(3 3,4 4)) # Must return 1. SELECT ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2), LINESTRING(3 3, 4 4))'), CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS GEOMETRYCOLLECTION)); ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2), LINESTRING(3 3, 4 4))'), CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS GEOMETRYCOLLECTION)) 1 # #################################################### # Requirement F-13g: # # CAST(multipolygon AS GEOMETRYCOLLECTION) # #################################################### # # Casting from MULTIPOLYGON to GEOMETRYCOLLECTION is always allowed. # Must return geometrycollection. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((5 5, 6 5, 6 6, 5 6, 5 5)))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((5 5, 6 5, 6 6, 5 6, 5 5)))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POLYGON((1 1,4 1,4 4,1 4,1 1)),POLYGON((5 5,6 5,6 6,5 6,5 5))) # Must return 1. SELECT ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)), POLYGON((5 5, 6 5, 6 6, 5 6, 5 5)))'), CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((5 5, 6 5, 6 6, 5 6, 5 5)))') AS GEOMETRYCOLLECTION)); ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((1 1, 4 1, 4 4, 1 4, 1 1)), POLYGON((5 5, 6 5, 6 6, 5 6, 5 5)))'), CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((5 5, 6 5, 6 6, 5 6, 5 5)))') AS GEOMETRYCOLLECTION)) 1 # #################################################### # Requirement F-13h: # # CAST(geometrycollection AS GEOMETRYCOLLECTION) # #################################################### # # Casting from GEOMETRYCOLLECTION to GEOMETRYCOLLECTION is always allowed. # Must return geometrycollection. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(2 2,3 3)) # Must return 1. SELECT ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))'), CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION)); ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))'), CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION)) 1 # ############################################# # Testing result of WKT input # ############################################# # # Casting from ST_GEOMFROMTEXT() to GEOMETRYCOLLECTION must return expected linestring. SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(1 1)) SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('LINESTRING(2 2, 3 3)') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('LINESTRING(2 2, 3 3)') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(LINESTRING(2 2,3 3)) SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POLYGON((4 4, 5 4, 5 5, 4 5, 4 4))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POLYGON((4 4, 5 4, 5 5, 4 5, 4 4))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POLYGON((4 4,5 4,5 5,4 5,4 4))) SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((6 6), (7 7))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((6 6), (7 7))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(6 6),POINT(7 7)) SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTILINESTRING((8 8, 9 9), (10 10, 11 11))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTILINESTRING((8 8, 9 9), (10 10, 11 11))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(LINESTRING(8 8,9 9),LINESTRING(10 10,11 11)) SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((12 12, 13 12, 13 13, 12 13, 12 12)), ((14 14, 15 14, 15 15, 14 15, 14 14)))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((12 12, 13 12, 13 13, 12 13, 12 12)), ((14 14, 15 14, 15 15, 14 15, 14 14)))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POLYGON((12 12,13 12,13 13,12 13,12 12)),POLYGON((14 14,15 14,15 15,14 15,14 14))) SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(16 16), LINESTRING(17 17, 18 18))') AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(16 16), LINESTRING(17 17, 18 18))') AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(16 16),LINESTRING(17 17,18 18)) # ############################################# # Testing result of user variable input # ############################################# # SET @point = ST_GEOMFROMTEXT('POINT(1 1)'); SET @linestring = ST_GEOMFROMTEXT('LINESTRING(2 2, 3 3)'); SET @polygon = ST_GEOMFROMTEXT('POLYGON((4 4, 5 4, 5 5, 4 5, 4 4))'); SET @multipoint = ST_GEOMFROMTEXT('MULTIPOINT((6 6), (7 7))'); SET @multilinestring = ST_GEOMFROMTEXT('MULTILINESTRING((8 8, 9 9), (10 10, 11 11))'); SET @multipolygon = ST_GEOMFROMTEXT('MULTIPOLYGON(((12 12, 13 12, 13 13, 12 13, 12 12)), ((14 14, 15 14, 15 15, 14 15, 14 14)))'); SET @geomcollection = ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(16 16), LINESTRING(17 17, 18 18))'); # # Casting from geometry in user variable to GEOMETRYCOLLECTION must return expected geometrycollection. SELECT ST_ASTEXT(CAST(@point AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(@point AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(1 1)) SELECT ST_ASTEXT(CAST(@linestring AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(@linestring AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(LINESTRING(2 2,3 3)) SELECT ST_ASTEXT(CAST(@polygon AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(@polygon AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POLYGON((4 4,5 4,5 5,4 5,4 4))) SELECT ST_ASTEXT(CAST(@multipoint AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(@multipoint AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(6 6),POINT(7 7)) SELECT ST_ASTEXT(CAST(@multilinestring AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(@multilinestring AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(LINESTRING(8 8,9 9),LINESTRING(10 10,11 11)) SELECT ST_ASTEXT(CAST(@multipolygon AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(@multipolygon AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POLYGON((12 12,13 12,13 13,12 13,12 12)),POLYGON((14 14,15 14,15 15,14 15,14 14))) SELECT ST_ASTEXT(CAST(@geomcollection AS GEOMETRYCOLLECTION)); ST_ASTEXT(CAST(@geomcollection AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(16 16),LINESTRING(17 17,18 18)) # ############################################# # Testing result of table column input # ############################################# # CREATE TABLE gis_geometrycollection_castable (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY); INSERT INTO gis_geometrycollection_castable VALUES (101, ST_GEOMFROMTEXT('POINT(1 1)')), (102, ST_GEOMFROMTEXT('LINESTRING(2 2, 3 3)')), (103, ST_GEOMFROMTEXT('POLYGON((4 4, 5 4, 5 5, 4 5, 4 4))')), (104, ST_GEOMFROMTEXT('MULTIPOINT((6 6), (7 7))')), (105, ST_GEOMFROMTEXT('MULTILINESTRING((8 8, 9 9), (10 10, 11 11))')), (106, ST_GEOMFROMTEXT('MULTIPOLYGON(((12 12, 13 12, 13 13, 12 13, 12 12)), ((14 14, 15 14, 15 15, 14 15, 14 14)))')), (107, ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(16 16), LINESTRING(17 17, 18 18))')); # # Casting from geometry column to GEOMETRYCOLLECTION must return expected geometrycollection. SELECT ST_ASTEXT(CAST(g AS GEOMETRYCOLLECTION)) FROM gis_geometrycollection_castable; ST_ASTEXT(CAST(g AS GEOMETRYCOLLECTION)) GEOMETRYCOLLECTION(POINT(1 1)) GEOMETRYCOLLECTION(LINESTRING(2 2,3 3)) GEOMETRYCOLLECTION(POLYGON((4 4,5 4,5 5,4 5,4 4))) GEOMETRYCOLLECTION(POINT(6 6),POINT(7 7)) GEOMETRYCOLLECTION(LINESTRING(8 8,9 9),LINESTRING(10 10,11 11)) GEOMETRYCOLLECTION(POLYGON((12 12,13 12,13 13,12 13,12 12)),POLYGON((14 14,15 14,15 15,14 15,14 14))) GEOMETRYCOLLECTION(POINT(16 16),LINESTRING(17 17,18 18)) # # Cleanup. DROP TABLE gis_geometrycollection_castable;