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

Unnecessary computations for SPATIAL INDEX

Details

    Description

      In InnoDB, spatial index (R-tree) records always start with a field whose length is DATA_MBR_LEN. This field is unfortunately declared as variable-length, so its length is always encoded.

      The InnoDB functions dict_index_copy_rec_order_prefix() and rec_copy_prefix_to_buf() are treating spatial indexes as if they could have any number of fields or any length for the first field.

      Attachments

        Activity

          marko Marko Mäkelä created issue -
          marko Marko Mäkelä made changes -
          Field Original Value New Value
          issue.field.resolutiondate 2018-04-30 09:11:43.0 2018-04-30 09:11:43.528
          marko Marko Mäkelä made changes -
          Fix Version/s 10.3.7 [ 23005 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 86853 ] MariaDB v4 [ 154282 ]

          People

            marko Marko Mäkelä
            marko Marko Mäkelä
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.