| 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 |