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:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1bk OS:Linux (linux)
Assigned to: Timothy Smith
Tags: gis

[25 Nov 2006 16:31] Hartmut Holzgraefe
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
[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).