• Ramil Kalimullin's avatar
    Fix for bug#47019: Assertion failed: 0, file .\rt_mbr.c, · 17ed6b9a
    Ramil Kalimullin authored
    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.
    
    
    mysql-test/r/select.result:
      Fix for bug#47019: Assertion failed: 0, file .\rt_mbr.c, 
      line 138 when forcing a spatial index
        - test result.
    mysql-test/t/select.test:
      Fix for bug#47019: Assertion failed: 0, file .\rt_mbr.c, 
      line 138 when forcing a spatial index
        - test case.
    sql/sql_select.cc:
      Fix for bug#47019: Assertion failed: 0, file .\rt_mbr.c, 
      line 138 when forcing a spatial index
        - disable spatial indexes for queries which use 
      non-spatial conditions (e.g. NATURAL JOINs).
    17ed6b9a
sql_select.cc 505 KB