Debian Codegraph @

mysql-test/suite/gis/t/spatial_utility_function_validate.test

raw
1 ###############################################################################
2 # #
3 # ST_VALIDATE checks whether a geometry byte string is valid, #
4 # if so return it, otherwise return NULL. #
5 # #
6 # Creation Date: 2014-12-01 #
7 # Author : Pavan Naik #
8 # #
9 ###############################################################################
10
11
12 ############################################################################################
13 # Creating the spatial objects #
14 ############################################################################################
15
16 --echo # Creating the spatial Geometry object
17 USE test;
18
19 --echo # ST_VALIDATE must return null when its parameter is NULL
20 SELECT ST_ASTEXT(ST_VALIDATE( NULL ));
21 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT(NULL,0)));
22 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT(NULL,4053)));
23
24 --echo # ST_VALIDATE raises an error if the data is malformed
25 --error ER_GIS_INVALID_DATA
26 DO ST_VALIDATE( x'00000000DEADBEEF');
27
28 --echo # ST_VALIDATE raises an error if the SRS is not known
29 --error ER_SRS_NOT_FOUND
30 DO ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POINT(0 0)',10)));
31
32 --echo # ST_VALIDATE raises an error if longitude is out of range
33 --error ER_LONGITUDE_OUT_OF_RANGE
34 DO ST_VALIDATE(ST_GEOMFROMTEXT('POINT(0 270)', 4326));
35
36 --echo # ST_VALIDATE raises an error if latitude is out of range
37 --error ER_LATITUDE_OUT_OF_RANGE
38 DO ST_VALIDATE(ST_GEOMFROMTEXT('POINT(270 0)', 4326));
39
40 --echo # ST_VALIDATE returns the same geometry as it was given when it is valid
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))'))) AS
43 valid_polygon;
44 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
45 0),( 0.25 0.25, 0.25 0.75, 0.75 0.75, 0.75 0.25, 0.25 0.25))',4053))) AS
46 valid_polygon;
47 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
48 0),( 0.25 0.25, 0.25 0.75, 0.75 0.75, 0.75 0.25, 0.25 0.25))',2000))) AS
49 valid_polygon;
50 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
51 0),( 0.25 0.25, 0.25 0.75, 0.75 0.75, 0.75 0.25, 0.25 0.25))',4326))) AS
52 valid_polygon;
53
54 --echo # ST_VALIDATE returns NULL if the geometry is invalid
55 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
56 0),( 0.25 0.25, 1.75 0.25, 0.75 0.75, 0.25 0.75, 0.25 0.25))'))) AS
57 should_be_null;
58 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
59 0),( 0.25 0.25, 1.75 0.25, 0.75 0.75, 0.25 0.75, 0.25 0.25))',4053))) AS
60 should_be_null;
61 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
62 0),( 0.25 0.25, 1.75 0.25, 0.75 0.75, 0.25 0.75, 0.25 0.25))',2000))) AS
63 should_be_null;
64 SELECT ST_ASTEXT(ST_VALIDATE( ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0
65 0),( 0.25 0.25, 1.75 0.25, 0.75 0.75, 0.25 0.75, 0.25 0.25))',4326))) AS
66 should_be_null;