[MDEV-13853] Spatial index does not work properly with InnoDB Created: 2017-09-20  Updated: 2020-08-25  Resolved: 2017-09-20

Status: Closed
Project: MariaDB Server
Component/s: GIS, Storage Engine - InnoDB
Affects Version/s: 10.2.7
Fix Version/s: 10.2.9

Type: Bug Priority: Major
Reporter: Claudio Nanni Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Environment:

RHEL

Attachments: File testcase.tar.gz    
Issue Links:
Relates
relates to MDEV-12462 SPATIAL index fails to work with CONT... Closed
relates to MDEV-13716 point_big test fails in 10.2 Closed

 Description   

Spatial index fails in returning the results, dropping the index it works.
Attached case for InnoDB and MyISAM tables.

 Comments   
Comment by Elena Stepanova [ 2017-09-20 ]

Reproducible on 10.2.8, but not on the current 10.2 tree.

The problem was fixed by this commit:

commit ea876b39f33af6b7d54f2a0a5def0fbf40b30e27
 
Author: Alexey Botchkov <holyfoot@askmonty.org>
 
Date:   Tue Sep 12 11:58:49 2017 +0400
 
 
 
    MDEV-13716 point_big test fails in 10.2.
 
    
            Implementation for the reverse spatial predicates was lost
 
            somehow.

It's in the main tree already, so it should be released in 10.2.9.

Generated at Thu Feb 08 08:08:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.