| Bug #13600 | Non existant distance function in help | ||
|---|---|---|---|
| Submitted: | 29 Sep 2005 10:39 | Modified: | 5 Oct 2005 3:59 |
| Reporter: | [ name withheld ] (Basic Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.13 | OS: | Windows (WinXP sp2) |
| Assigned to: | Paul DuBois | CPU Architecture: | Any |
[5 Oct 2005 3:59]
Paul DuBois
The file containing the help table contents has been fixed (for Distance() and also Related() which had the same problem). The updated file will be included in future releases.
Description: The GIS function "distance" is in the help but it's not implemented, this is confusing for users. I opened a bug for this in v 4 and it was claimed as closed, but in 5 the issue is still here. How to repeat: mysql> help distance Name: 'DISTANCE' Description: Distance(g1,g2) Returns as a double-precision number the shortest distance between any two points in the two geometries. mysql> select DISTANCE(GeomFromText('POINT(2671 2500)'), GeomFromText('POINT(297 1 2520)')); ERROR 1305 (42000): FUNCTION .DISTANCE does not exist mysql> select version(); +------------------+ | version() | +------------------+ | 5.0.13-rc-nt-max | +------------------+ 1 row in set (0.39 sec) mysql> show variables like 'have%'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | have_archive | YES | | have_bdb | YES | | have_blackhole_engine | YES | | have_compress | YES | | have_crypt | NO | | have_csv | NO | | have_example_engine | YES | | have_federated_engine | YES | | have_geometry | YES |