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 CPU Architecture:Any
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).

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.