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