Bug #24588 MBROverlaps missing in 5.1?
| Submitted: | 25 Nov 2006 16:31 | Modified: | 7 Apr 2007 19:04 |
|---|---|---|---|
| Reporter: | Hartmut Holzgraefe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.1bk | OS: | Linux (linux) |
| Assigned to: | Timothy Smith | CPU Architecture: | Any |
| Tags: | gis | ||
[25 Nov 2006 20:12]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/15820 ChangeSet@1.2396, 2006-11-25 21:12:09+01:00, hartmut@walhalla.site +8 -0 Fixes and tests for Bug #24563 "MBROverlaps does not seem to function propertly" and for Bug #24588 "MBROverlaps missing in 5.1?"
[24 Mar 2007 0:03]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/22848 ChangeSet@1.2506, 2007-03-23 18:02:37-06:00, tsmith@siva.hindu.god +1 -0 Bug #24588: "MBROverlaps missing in 5.1?" The MBR-prefixed function aliases (e.g., MBROVERLAPS()) were missing in 5.1, after some code refactoring left them out. This simply adds them into the func_array list.
[6 Apr 2007 17:24]
Bugs System
Pushed into 5.1.18-beta
[7 Apr 2007 19:04]
Paul DuBois
Noted in 5.1.18 changelog. MBRDisjoint(), MBRequal(), MBRIntersects(), MBROverlaps(), MBRTouches(), and MBRWithin() were inadvertently omitted from recent versions of MySQL (5.1.14 to 5.1.17).
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: In current 5.1 the MBROverlaps function seems to be missing even though the geometry functions are enabled How to repeat: mysql> show variables like "have_geometry"\G *************************** 1. row *************************** Variable_name: have_geometry Value: YES 1 row in set (0.00 sec) mysql> select MBRContains(GeomFromText('POLYGON ((0 0, 0 3, 3 3, 3 0, 0 0))'), GeomFromText('POLYGON ((1 1, 1 4, 4 4, 4 1, 1 1))')) as result\G *************************** 1. row *************************** result: 0 1 row in set (0.06 sec) mysql> select MBROverlaps(GeomFromText('POLYGON ((0 0, 0 3, 3 3, 3 0, 0 0))'), GeomFromText('POLYGON ((1 1, 1 4, 4 4, 4 1, 1 1))')) as result\G ERROR 1305 (42000): FUNCTION test.MBROverlap does not exist