Debian Codegraph @

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

raw
1 SELECT ST_FRECHETDISTANCE(NULL,NULL);
2 ST_FRECHETDISTANCE(NULL,NULL)
3 NULL
4 SELECT ST_FRECHETDISTANCE(NULL,'');
5 ST_FRECHETDISTANCE(NULL,'')
6 NULL
7 DO ST_FRECHETDISTANCE('LINESTRING(0 0, 0 1)');
8 ERROR 42000: Incorrect parameter count in the call to native function 'ST_FRECHETDISTANCE'
9 DO ST_FRECHETDISTANCE('','');
10 ERROR 22023: Invalid GIS data provided to function st_frechetdistance.
11 SELECT ST_FRECHETDISTANCE(0xffffffff01020000000500000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F00000000000000400000000000000040000000000000F03F00000000000000400000000000000040,0xffffffff01020000000500000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F00000000000000400000000000000040000000000000F03F00000000000000400000000000000040);
12 ERROR SR001: There's no spatial reference system with SRID 4294967295.
13 DO ST_FRECHETDISTANCE
14 (ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 1,1 2,2 2)', 4326),
15 ST_GEOMFROMTEXT('LINESTRING(0 1,1 0,1 1,1 2,1 3)', 0));
16 ERROR HY000: Binary geometry function st_frechetdistance given two geometries of different srids: 4326 and 0, which should have been identical.
17 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'), ST_GEOMFROMTEXT('POINT(0 1)'));
18 ERROR 22S00: st_frechetdistance(POINT, POINT) has not been implemented for Cartesian spatial reference systems.
19 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('MULTIPOINT(0 1)'));
20 ERROR 22S00: st_frechetdistance(LINESTRING, MULTIPOINT) has not been implemented for Cartesian spatial reference systems.
21 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 0))'));
22 ERROR 22S00: st_frechetdistance(LINESTRING, MULTILINESTRING) has not been implemented for Cartesian spatial reference systems.
23 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 0))'));
24 ERROR 22S00: st_frechetdistance(LINESTRING, POLYGON) has not been implemented for Cartesian spatial reference systems.
25 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 1 0, 1 1, 0 0)))'));
26 ERROR 22S00: st_frechetdistance(LINESTRING, MULTIPOLYGON) has not been implemented for Cartesian spatial reference systems.
27 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 1 0, 1 1, 0 0)))', 4326), ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)', 4326));
28 ERROR 22S00: st_frechetdistance(MULTIPOLYGON, LINESTRING) has not been implemented for geographic spatial reference systems.
29 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'), ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1))'));
30 ERROR 22S00: st_frechetdistance(LINESTRING, GEOMCOLLECTION) has not been implemented for Cartesian spatial reference systems.
31 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1))'), ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'));
32 ERROR 22S00: st_frechetdistance(GEOMCOLLECTION, LINESTRING) has not been implemented for Cartesian spatial reference systems.
33 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1))', 4326), ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1))', 4326));
34 ERROR 22S00: st_frechetdistance(GEOMCOLLECTION, GEOMCOLLECTION) has not been implemented for geographic spatial reference systems.
35 DO ST_FRECHETDISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1e308, 1e308 1e308)'), ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'));
36 ERROR 22003: FrechetDistance value is out of range in 'st_frechetdistance'
37 SELECT
38 ROUND(
39 ST_FRECHETDISTANCE
40 (ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 1,1 2,2 2)', 0),
41 ST_GEOMFROMTEXT('LINESTRING(0 1,1 0,1 1,1 2,1 3)', 0)),
42 2
43 ) AS dfd;
44 dfd
45 1.41
46 SELECT
47 ROUND(
48 ST_FRECHETDISTANCE
49 (ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 1,1 2,2 2)', 4326),
50 ST_GEOMFROMTEXT('LINESTRING(0 1,1 0,1 1,1 2,1 3)', 4326),
51 'foot'),
52 2
53 ) AS dfd;
54 dfd
55 514679.74