Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13853

Spatial index does not work properly with InnoDB

Details

    Description

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

      Attachments

        Issue Links

          Activity

            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.

            elenst Elena Stepanova added a comment - 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.

            People

              Unassigned Unassigned
              claudio.nanni Claudio Nanni
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.