Debian Codegraph @

mysql-test/suite/gis/r/cast_as_point.result

raw
1 ########################################
2 # Requirement F-7a: #
3 # CAST(point AS POINT) #
4 ########################################
5 #
6 # Casting from POINT to POINT is always allowed.
7 # Must return Point.
8 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT));
9 ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT))
10 POINT(1 1)
11 # Must return 1.
12 SELECT ST_EQUALS(ST_GEOMFROMTEXT('POINT(1 1)'), CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT));
13 ST_EQUALS(ST_GEOMFROMTEXT('POINT(1 1)'), CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT))
14 1
15 #
16 ########################################
17 # Requirement F-7b: #
18 # CAST(multipoint AS POINT) #
19 ########################################
20 #
21 # Casting from MULTIPOINT with only one point to POINT is allowed.
22 # Must return Point.
23 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1))') AS POINT));
24 ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1))') AS POINT))
25 POINT(1 1)
26 # Must return 1.
27 SELECT ST_EQUALS(ST_GEOMFROMTEXT('POINT(1 1)'), CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1))') AS POINT));
28 ST_EQUALS(ST_GEOMFROMTEXT('POINT(1 1)'), CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1))') AS POINT))
29 1
30 #
31 # Casting from MULTIPOINT with multiple points to POINT is not allowed.
32 # Must raise error.
33 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS POINT));
34 ERROR 22S01: Invalid cast from MULTIPOINT to POINT.
35 #
36 ########################################
37 # Requirement F-7c: #
38 # CAST(geometrycollection AS POINT) #
39 ########################################
40 #
41 # Casting from GEOMETRYCOLLECTION with only one point to POINT is allowed.
42 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))') AS POINT));
43 ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))') AS POINT))
44 POINT(1 1)
45 # Must return 1.
46 SELECT ST_EQUALS(ST_GEOMFROMTEXT('POINT(1 1)'), CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))') AS POINT));
47 ST_EQUALS(ST_GEOMFROMTEXT('POINT(1 1)'), CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))') AS POINT))
48 1
49 #
50 # Casting from empty GEOMETRYCOLLECTION to POINT is not allowed.
51 # Must raise error.
52 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()') AS POINT));
53 ERROR 22S01: Invalid cast from GEOMCOLLECTION to POINT.
54 #
55 # Casting from GEOMETRYCOLLECTION with multiple points to POINT is not allowed.
56 # Must raise error.
57 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), POINT(2 2))') AS POINT));
58 ERROR 22S01: Invalid cast from GEOMCOLLECTION to POINT.
59 #
60 # Casting from GEOMETRYCOLLECTION with not only points to POINT is not allowed.
61 # Must raise error.
62 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), GEOMETRYCOLLECTION())') AS POINT));
63 ERROR 22S01: Invalid cast from GEOMCOLLECTION to POINT.
64 #
65 ########################################
66 # Requirement F-7d: #
67 # Disallowed casts to POINT #
68 ########################################
69 #
70 # Casting from LINESTRING to POINT is not allowed.
71 # Must raise error.
72 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS POINT));
73 ERROR 22S01: Invalid cast from LINESTRING to POINT.
74 #
75 # Casting from POLYGON to POINT is not allowed.
76 # Must raise error.
77 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 2 2, 3 3, 1 1))') AS POINT));
78 ERROR 22S01: Invalid cast from POLYGON to POINT.
79 #
80 # Casting from MULTILINESTRING to POINT is not allowed.
81 # Must raise error.
82 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (1 1, 2 2))') AS POINT));
83 ERROR 22S01: Invalid cast from MULTILINESTRING to POINT.
84 #
85 # Casting from MULTIPOLYGON to POINT is not allowed.
86 # Must raise error.
87 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 2 2, 3 3, 1 1)), ((1 1, 2 2, 3 3, 1 1)))') AS POINT));
88 ERROR 22S01: Invalid cast from MULTIPOLYGON to POINT.
89 #
90 #############################################
91 # Testing result of WKT input #
92 #############################################
93 #
94 # Casting from ST_GEOMFROMTEXT(<wkt>) to POINT must return expected point.
95 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT));
96 ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT))
97 POINT(1 1)
98 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((2 2))') AS POINT));
99 ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((2 2))') AS POINT))
100 POINT(2 2)
101 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 3))') AS POINT));
102 ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 3))') AS POINT))
103 POINT(3 3)
104 #
105 #############################################
106 # Testing result of user variable input #
107 #############################################
108 #
109 SET @point = ST_GEOMFROMTEXT('POINT(1 1)');
110 SET @multipoint = ST_GEOMFROMTEXT('MULTIPOINT((2 2))');
111 SET @geomcollection = ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 3))');
112 #
113 # Casting from geometry in user variable to POINT must return expected point.
114 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT));
115 ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT))
116 POINT(1 1)
117 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((2 2))') AS POINT));
118 ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((2 2))') AS POINT))
119 POINT(2 2)
120 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 3))') AS POINT));
121 ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 3))') AS POINT))
122 POINT(3 3)
123 #
124 #############################################
125 # Testing result of table column input #
126 #############################################
127 #
128 CREATE TABLE gis_point_castable (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
129 INSERT INTO gis_point_castable values
130 (101, ST_GEOMFROMTEXT('POINT(1 1)')),
131 (102, ST_GEOMFROMTEXT('MULTIPOINT((2 2))')),
132 (103, ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 3))'));
133 #
134 # Casting from geometry column to POINT must return expected point.
135 SELECT ST_ASTEXT(CAST(g AS POINT)) FROM gis_point_castable;
136 ST_ASTEXT(CAST(g AS POINT))
137 POINT(1 1)
138 POINT(2 2)
139 POINT(3 3)
140 #
141 # Cleanup.
142 DROP TABLE gis_point_castable;