• MySQL Build Team's avatar
    Backport into build-201002030816-5.0.87sp1 · 9e6ba65b
    MySQL Build Team authored
    > ------------------------------------------------------------
    > revno: 2818.1.4
    > revision-id: ramil@mysql.com-20091021090408-208mvwwrcroi2j8c
    > parent: azundris@mysql.com-20091021033856-ydodp4q42o58e7ka
    > committer: Ramil Kalimullin <ramil@mysql.com>
    > branch nick: b47019-5.0-bugteam
    > timestamp: Wed 2009-10-21 14:04:08 +0500
    > message:
    >   Fix for bug#47019: Assertion failed: 0, file .\rt_mbr.c, 
    >   line 138 when forcing a spatial index
    >   
    >   Problem: "Spatial indexes can be involved in the search 
    >   for queries that use a function such as MBRContains() 
    >   or MBRWithin() in the WHERE clause".
    >   Using spatial indexes for JOINs with =, <=> etc.
    >   predicates is incorrect.
    >   
    >   Fix: disable spatial indexes for such queries.
    9e6ba65b
select.test 175 KB