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

Unique hash key on column prefix is computed incorrectly

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t (a TINYBLOB, b CHAR(64), UNIQUE(a,b(8))) ENGINE=InnoDB;
      INSERT INTO t VALUES ('foo','bar');
      CHECK TABLE t EXTENDED;
       
      # Cleanup
      DROP TABLE t;
      

      10.6 79dc3989f

      CHECK TABLE t EXTENDED;
      Table	Op	Msg_type	Msg_text
      test.t	check	Warning	InnoDB: Index 'a' contains 0 entries, should be 1.
      test.t	check	error	Corrupt
      DROP TABLE t;
      bug.15430 'innodb'                       [ fail ]  Found warnings/errors in server log file!
              Test ended at 2022-11-06 14:15:27
      line
      2022-11-06 14:15:26 4 [ERROR] InnoDB: Flagged corruption of `a` in table `test`.`t` in CHECK TABLE; Wrong count
      

      The error started showing up on 10.6 after

      commit ab0190101b0587e0e03b2d75a967050b9a85fd1b (HEAD)
      Author: Marko Mäkelä
      Date:   Fri Oct 21 10:02:54 2022 +0300
       
          MDEV-24402: InnoDB CHECK TABLE ... EXTENDED
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              12 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.