Debian Codegraph @

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

raw
1 # Creating the spatial objects
2 CREATE TABLE gis_point (fid INTEGER NOT NULL PRIMARY KEY, g POINT);
3 # Inserting POINT Geometry Values
4 INSERT INTO gis_point VALUES
5 (101, ST_POINTFROMTEXT('POINT(0 0)')),
6 (102, ST_POINTFROMTEXT('POINT(1 0)')),
7 (103, ST_POINTFROMTEXT('POINT(0 1)')),
8 (104, ST_POINTFROMTEXT('POINT(1 1)')),
9 (105, ST_POINTFROMTEXT('POINT(-1 1)'));
10 INSERT INTO gis_point VALUES
11 (106, ST_POINTFROMWKB(ST_ASWKB(POINT(0,0)))),
12 (107, ST_POINTFROMWKB(ST_ASWKB(POINT(10,0)))),
13 (108, ST_POINTFROMWKB(ST_ASWKB(POINT(0,10)))),
14 (109, ST_POINTFROMWKB(ST_ASWKB(POINT(-10,0)))),
15 (110, ST_POINTFROMWKB(ST_ASWKB(POINT(0,-10))));
16 INSERT INTO gis_point VALUES
17 (111, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1 1)')))),
18 (112, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1e308 1e308)')))),
19 (113, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1e308 -1e308)')))),
20 (114, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1e308 1e308)')))),
21 (115, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1e308 -1e308)'))));
22 # Displaying the inserted POINT Geometry Data
23 SELECT fid, ST_ASTEXT(g) FROM gis_point;
24 fid ST_ASTEXT(g)
25 101 POINT(0 0)
26 102 POINT(1 0)
27 103 POINT(0 1)
28 104 POINT(1 1)
29 105 POINT(-1 1)
30 106 POINT(0 0)
31 107 POINT(10 0)
32 108 POINT(0 10)
33 109 POINT(-10 0)
34 110 POINT(0 -10)
35 111 POINT(1 1)
36 112 POINT(1e308 1e308)
37 113 POINT(1e308 -1e308)
38 114 POINT(-1e308 1e308)
39 115 POINT(-1e308 -1e308)
40 #=======================================================================
41 # ST_X(point)
42 #=======================================================================
43 SELECT ST_ASTEXT(ST_X(ST_POINTFROMTEXT('POINT(0 0)'),5));
44 ST_ASTEXT(ST_X(ST_POINTFROMTEXT('POINT(0 0)'),5))
45 POINT(5 0)
46 SELECT ST_ASTEXT(ST_X(ST_POINTFROMTEXT('POINT(10 10)'), 5));
47 ST_ASTEXT(ST_X(ST_POINTFROMTEXT('POINT(10 10)'), 5))
48 POINT(5 10)
49 SELECT ST_ASTEXT(ST_X(ST_POINTFROMTEXT('POINT(1e308 1e308)'), 1e205));
50 ST_ASTEXT(ST_X(ST_POINTFROMTEXT('POINT(1e308 1e308)'), 1e205))
51 POINT(1e205 1e308)
52 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))), 5.5555));
53 ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))), 5.5555))
54 POINT(5.5555 -1.1111)
55 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))), 50.0000));
56 ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))), 50.0000))
57 POINT(50 10)
58 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))), -1e205));
59 ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))), -1e205))
60 POINT(-1e205 -1e308)
61 #=======================================================================
62 # ST_Y(point)
63 #=======================================================================
64 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMTEXT('POINT(0 0)'),5));
65 ST_ASTEXT(ST_Y(ST_POINTFROMTEXT('POINT(0 0)'),5))
66 POINT(0 5)
67 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMTEXT('POINT(10 10)'), 5));
68 ST_ASTEXT(ST_Y(ST_POINTFROMTEXT('POINT(10 10)'), 5))
69 POINT(10 5)
70 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMTEXT('POINT(1e308 1e308)'), 1e205));
71 ST_ASTEXT(ST_Y(ST_POINTFROMTEXT('POINT(1e308 1e308)'), 1e205))
72 POINT(1e308 1e205)
73 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))), 5.5555));
74 ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))), 5.5555))
75 POINT(1.1111 5.5555)
76 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))), 50.0000));
77 ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))), 50.0000))
78 POINT(10 50)
79 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))), -1e205));
80 ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))), -1e205))
81 POINT(-1e308 -1e205)
82 #=======================================================================
83 # ST_X(point)
84 #=======================================================================
85 SELECT ST_ASTEXT(ST_X(NULL, 5));
86 ST_ASTEXT(ST_X(NULL, 5))
87 NULL
88 SELECT ST_ASTEXT(ST_X(POINT(4, 5), NULL));
89 ST_ASTEXT(ST_X(POINT(4, 5), NULL))
90 NULL
91 SELECT ST_ASTEXT(ST_X(NULL, NULL));
92 ST_ASTEXT(ST_X(NULL, NULL))
93 NULL
94 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(NULL), NULL));
95 ST_ASTEXT(ST_X(ST_POINTFROMWKB(NULL), NULL))
96 NULL
97 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1)), 5)));
98 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')), 5)))' at line 1
99 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1)), )));
100 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')), )))' at line 1
101 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1, 2)), a)));
102 ERROR 42S22: Unknown column 'a' in 'field list'
103 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(a,b)), c)));
104 ERROR 42S22: Unknown column 'a' in 'field list'
105 SELECT ST_ASTEXT(ST_X(ST_POINTFROMTEXT('NULL'), NULL));
106 ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
107 SELECT ST_ASTEXT(ST_X(ST_POINTFROMTEXT('POINT()'), 5));
108 ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
109 SELECT ST_ASTEXT(ST_X(ST_POINTFROMTEXT('POINT(1)'), 5));
110 ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
111 #=======================================================================
112 # ST_Y(point)
113 #=======================================================================
114 SELECT ST_ASTEXT(ST_Y(NULL, 5));
115 ST_ASTEXT(ST_Y(NULL, 5))
116 NULL
117 SELECT ST_ASTEXT(ST_Y(POINT(4, 5), NULL));
118 ST_ASTEXT(ST_Y(POINT(4, 5), NULL))
119 NULL
120 SELECT ST_ASTEXT(ST_Y(NULL, NULL));
121 ST_ASTEXT(ST_Y(NULL, NULL))
122 NULL
123 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMWKB(NULL), NULL));
124 ST_ASTEXT(ST_Y(ST_POINTFROMWKB(NULL), NULL))
125 NULL
126 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1)), 5)));
127 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')), 5)))' at line 1
128 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1)), )));
129 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')), )))' at line 1
130 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1, 2)), a)));
131 ERROR 42S22: Unknown column 'a' in 'field list'
132 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(a,b)), c)));
133 ERROR 42S22: Unknown column 'a' in 'field list'
134 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMTEXT('NULL'), NULL));
135 ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
136 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMTEXT('POINT()'), 5));
137 ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
138 SELECT ST_ASTEXT(ST_Y(ST_POINTFROMTEXT('POINT(1)'), 5));
139 ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
140 # Try to use ST_X and ST_Y with out of range point values.
141 SELECT ST_X(POINT(pow(2, 2048), 4), 5);
142 ERROR 22003: DOUBLE value is out of range in 'pow(2,2048)'
143 SELECT ST_Y(POINT(pow(2, 2048), 4), 5);
144 ERROR 22003: DOUBLE value is out of range in 'pow(2,2048)'
145 SELECT ST_Y(POINT(4, pow(2, 2048)), 5);
146 ERROR 22003: DOUBLE value is out of range in 'pow(2,2048)'
147 SELECT ST_X(POINT(4, pow(2, 2048)), 5);
148 ERROR 22003: DOUBLE value is out of range in 'pow(2,2048)'
149 SELECT ST_X(POINT(4, 5), pow(2, 2048));
150 ERROR 22003: DOUBLE value is out of range in 'pow(2,2048)'
151 SELECT ST_Y(POINT(4, 5), pow(2, 2048));
152 ERROR 22003: DOUBLE value is out of range in 'pow(2,2048)'
153 SELECT ST_X(ST_GeomFromText('LINESTRING(0 0, 1 1)'), 5);
154 ERROR 22S01: POINT value is a geometry of unexpected type LINESTRING in st_x.
155 SELECT ST_Y(ST_GeomFromText('LINESTRING(0 0, 1 1)'), 5);
156 ERROR 22S01: POINT value is a geometry of unexpected type LINESTRING in st_y.
157 SELECT ST_X(ST_GEOMFROMTEXT('POLYGON((0 0,2 2,0 2,0 0))'), -1024);
158 ERROR 22S01: POINT value is a geometry of unexpected type POLYGON in st_x.
159 SELECT ST_Y(ST_GEOMFROMTEXT('POLYGON((0 0,2 2,0 2,0 0))'), -1024);
160 ERROR 22S01: POINT value is a geometry of unexpected type POLYGON in st_y.
161 SELECT ST_X(ST_GEOMFROMTEXT('MULTIPOINT(10 40, 40 30, 20 20, 30 10)'), 1024);
162 ERROR 22S01: POINT value is a geometry of unexpected type MULTIPOINT in st_x.
163 SELECT ST_Y(ST_GEOMFROMTEXT('MULTIPOINT(10 40, 40 30, 20 20, 30 10)'), 1024);
164 ERROR 22S01: POINT value is a geometry of unexpected type MULTIPOINT in st_y.
165 SELECT ST_X(ST_GEOMFROMTEXT("MULTILINESTRING((10 10, 20 20, 10 40),"
166 "(40 40, 30 30, 40 20, 30 10))"), 1024);
167 ERROR 22S01: POINT value is a geometry of unexpected type MULTILINESTRING in st_x.
168 SELECT ST_Y(ST_GEOMFROMTEXT("MULTILINESTRING((10 10, 20 20, 10 40),"
169 "(40 40, 30 30, 40 20, 30 10))"), 1024);
170 ERROR 22S01: POINT value is a geometry of unexpected type MULTILINESTRING in st_y.
171 SELECT ST_X(ST_GEOMFROMTEXT("MULTIPOLYGON(((40 40, 20 45, 45 30, 40 40)),"
172 "((20 35, 10 30, 10 10, 30 5, 45 20, 20 35)))"), -1024);
173 ERROR 22S01: POINT value is a geometry of unexpected type MULTIPOLYGON in st_x.
174 SELECT ST_Y(ST_GEOMFROMTEXT("MULTIPOLYGON(((40 40, 20 45, 45 30, 40 40)),"
175 "((20 35, 10 30, 10 10, 30 5, 45 20, 20 35)))"), -1024);
176 ERROR 22S01: POINT value is a geometry of unexpected type MULTIPOLYGON in st_y.
177 SELECT ST_X(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION("
178 "POINT(4 6),"
179 "LINESTRING(4 6,7 10),"
180 "POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10)),"
181 "MULTIPOINT (10 40, 40 30, 20 20, 30 10),"
182 "MULTILINESTRING ((10 10, 20 20, 10 40),"
183 "(40 40, 30 30, 40 20, 30 10)),"
184 "MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),"
185 "((15 5, 40 10, 10 20, 5 10, 15 5)))"
186 ")"
187 ), 1024);
188 ERROR 22S01: POINT value is a geometry of unexpected type GEOMCOLLECTION in st_x.
189 SELECT ST_Y(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION("
190 "POINT(4 6),"
191 "LINESTRING(4 6,7 10),"
192 "POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10)),"
193 "MULTIPOINT (10 40, 40 30, 20 20, 30 10),"
194 "MULTILINESTRING ((10 10, 20 20, 10 40),"
195 "(40 40, 30 30, 40 20, 30 10)),"
196 "MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),"
197 "((15 5, 40 10, 10 20, 5 10, 15 5)))"
198 ")"
199 ), 1024);
200 ERROR 22S01: POINT value is a geometry of unexpected type GEOMCOLLECTION in st_y.
201 # Final cleanup
202 DROP TABLE gis_point;