Debian Codegraph @

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

raw
1 # Creating the spatial Geometry object
2 USE test;
3 # ST_VALIDATE must return null when its parameter is NULL
4 SELECT ST_ASTEXT(ST_VALIDATE( NULL ));
5 ST_ASTEXT(ST_VALIDATE( NULL ))
6 NULL
7 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT(NULL,0)));
8 ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT(NULL,0)))
9 NULL
10 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT(NULL,4053)));
11 ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT(NULL,4053)))
12 NULL
13 # ST_VALIDATE raises an error if the data is malformed
14 DO ST_VALIDATE( x'00000000DEADBEEF');
15 ERROR 22023: Invalid GIS data provided to function st_validate.
16 # ST_VALIDATE raises an error if the SRS is not known
17 DO ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POINT(0 0)',10)));
18 ERROR SR001: There's no spatial reference system with SRID 10.
19 # ST_VALIDATE raises an error if longitude is out of range
20 DO ST_VALIDATE(ST_GEOMFROMTEXT('POINT(0 270)', 4326));
21 ERROR 22S02: Longitude 270.000000 is out of range in function st_geomfromtext. It must be within (-180.000000, 180.000000].
22 # ST_VALIDATE raises an error if latitude is out of range
23 DO ST_VALIDATE(ST_GEOMFROMTEXT('POINT(270 0)', 4326));
24 ERROR 22S03: Latitude 270.000000 is out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000].
25 # ST_VALIDATE returns the same geometry as it was given when it is valid
26 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
27 0),( 0.25 0.25, 0.25 0.75, 0.75 0.75, 0.75 0.25, 0.25 0.25))'))) AS
28 valid_polygon;
29 valid_polygon
30 POLYGON((0 0,1 0,1 1,0 1,0 0),(0.25 0.25,0.25 0.75,0.75 0.75,0.75 0.25,0.25 0.25))
31 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
32 0),( 0.25 0.25, 0.25 0.75, 0.75 0.75, 0.75 0.25, 0.25 0.25))',4053))) AS
33 valid_polygon;
34 valid_polygon
35 POLYGON((0 0,1 0,1 1,0 1,0 0),(0.25 0.25,0.25 0.75,0.75 0.75,0.75 0.25,0.25 0.25))
36 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
37 0),( 0.25 0.25, 0.25 0.75, 0.75 0.75, 0.75 0.25, 0.25 0.25))',2000))) AS
38 valid_polygon;
39 valid_polygon
40 POLYGON((0 0,1 0,1 1,0 1,0 0),(0.25 0.25,0.25 0.75,0.75 0.75,0.75 0.25,0.25 0.25))
41 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
42 0),( 0.25 0.25, 0.25 0.75, 0.75 0.75, 0.75 0.25, 0.25 0.25))',4326))) AS
43 valid_polygon;
44 valid_polygon
45 POLYGON((0 0,1 0,1 1,0 1,0 0),(0.25 0.25,0.25 0.75,0.75 0.75,0.75 0.25,0.25 0.25))
46 # ST_VALIDATE returns NULL if the geometry is invalid
47 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
48 0),( 0.25 0.25, 1.75 0.25, 0.75 0.75, 0.25 0.75, 0.25 0.25))'))) AS
49 should_be_null;
50 should_be_null
51 NULL
52 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
53 0),( 0.25 0.25, 1.75 0.25, 0.75 0.75, 0.25 0.75, 0.25 0.25))',4053))) AS
54 should_be_null;
55 should_be_null
56 NULL
57 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
58 0),( 0.25 0.25, 1.75 0.25, 0.75 0.75, 0.25 0.75, 0.25 0.25))',2000))) AS
59 should_be_null;
60 should_be_null
61 NULL
62 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
63 0),( 0.25 0.25, 1.75 0.25, 0.75 0.75, 0.25 0.75, 0.25 0.25))',4326))) AS
64 should_be_null;
65 should_be_null
66 NULL