Debian Codegraph @

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

raw
1 # Top-level coverage tests for ST_FRECHETDISTANCE function.
2
3 # NULL handling
4 SELECT ST_FRECHETDISTANCE(NULL,NULL);
5 SELECT ST_FRECHETDISTANCE(NULL,'');
6
7 # Test error wrong number of arguments.
8 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
9 DO ST_FRECHETDISTANCE('LINESTRING(0 0, 0 1)');
10
11 # Test error forwarding from geometry parsing.
12 --error ER_GIS_INVALID_DATA
13 DO ST_FRECHETDISTANCE('','');
14
15 --error ER_SRS_NOT_FOUND
16 SELECT ST_FRECHETDISTANCE(0xffffffff01020000000500000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F00000000000000400000000000000040000000000000F03F00000000000000400000000000000040,0xffffffff01020000000500000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F00000000000000400000000000000040000000000000F03F00000000000000400000000000000040);
17
18 --error ER_GIS_DIFFERENT_SRIDS
19 DO ST_FRECHETDISTANCE
20 (ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 1,1 2,2 2)', 4326),
21 ST_GEOMFROMTEXT('LINESTRING(0 1,1 0,1 1,1 2,1 3)', 0));
22
23 # Test error on unsupported types.
24 # there are no unsupported types
25
26 # Test error on not implemented types.
27 --error ER_NOT_IMPLEMENTED_FOR_CARTESIAN_SRS
28 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'), ST_GEOMFROMTEXT('POINT(0 1)'));
29 --error ER_NOT_IMPLEMENTED_FOR_CARTESIAN_SRS
30 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('MULTIPOINT(0 1)'));
31 --error ER_NOT_IMPLEMENTED_FOR_CARTESIAN_SRS
32 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 0))'));
33 --error ER_NOT_IMPLEMENTED_FOR_CARTESIAN_SRS
34 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 0))'));
35 --error ER_NOT_IMPLEMENTED_FOR_CARTESIAN_SRS
36 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 1 0, 1 1, 0 0)))'));
37 --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS
38 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 1 0, 1 1, 0 0)))', 4326), ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)', 4326));
39 --error ER_NOT_IMPLEMENTED_FOR_CARTESIAN_SRS
40 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1))'));
41 --error ER_NOT_IMPLEMENTED_FOR_CARTESIAN_SRS
42 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1))'), ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'));
43 --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS
44 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1))', 4326), ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1))', 4326));
45
46
47 # Test error due to numeric overflow.
48 --error ER_DATA_OUT_OF_RANGE
49 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1e308, 1e308 1e308)'), ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'));
50
51
52 # Excercise code on supported types.
53 # Cartesian
54 SELECT
55 ROUND(
56 ST_FRECHETDISTANCE
57 (ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 1,1 2,2 2)', 0),
58 ST_GEOMFROMTEXT('LINESTRING(0 1,1 0,1 1,1 2,1 3)', 0)),
59 2
60 ) AS dfd;
61
62 # Geographic
63 SELECT
64 ROUND(
65 ST_FRECHETDISTANCE
66 (ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 1,1 2,2 2)', 4326),
67 ST_GEOMFROMTEXT('LINESTRING(0 1,1 0,1 1,1 2,1 3)', 4326),
68 'foot'),
69 2
70 ) AS dfd;
71
72 # End of top-level coverage test.