Debian Codegraph @

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

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