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

Implement CHECK TABLE…EXTENDED for SPATIAL INDEX

Details

    Description

      MySQL 8.0.42 includes the following change:
      Bug #37359538 Extend check table to verify MBR in spatial index to original geometry
      This looks like a very simple change that would be technically trivial to apply to MariaDB Server 10.6, where MDEV-24402 implemented CHECK TABLE…EXTENDED for B-tree indexes. However, no test case is included, and to my understanding, this would not implement a check that would cover all currently visible versions of the SPATIAL INDEX. It is also worth noting that it could be difficult to test this as long as bugs like MDEV-15275, MDEV-15284 and MDEV-16269 remain open.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15275 innodb_gis.rtree_purge failed in buildbot with timeout

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15284 innodb_gis.rtree_concurrent_srch fails with COUNT(*) mismatch

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16269 innodb_gis.rtree_compress2 failed in buildbot with wrong result

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24402 CHECK TABLE may miss some cases of index inconsistencies

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36614 Merge applicable changes from InnoDB 8.0.42

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              Unassigned Unassigned
              marko Marko Mäkelä
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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