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

Non-spatial key on POINT silently changes prefix key length

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • 10.5, 10.6, 10.11, 11.4
    • Data types, GIS
    • None

    Description

      CREATE OR REPLACE TABLE t1 (a POINT, KEY(a(10)));
      SHOW CREATE TABLE t1;
      

      +-------+----------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                             |
      +-------+----------------------------------------------------------------------------------------------------------+
      | t1    | CREATE TABLE `t1` (
        `a` point DEFAULT NULL,
        KEY `a` (`a`(25))
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
      +-------+----------------------------------------------------------------------------------------------------------+
      

      The key length of 25 looks wrong. It should be 10, as in the CREATE statement.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 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.