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

CHECK TABLE reports bogus corruption on a UNIQUE INDEX that includes NULL

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

      Corruption found while testing MDEV-37659

      origin/MDEV-37659 7ca59491647bac063b235b53523f7e9fe6a403f0

      		 
      # 2025-10-09T23:35:15 [4096944] ERROR: Executor: The query ' CHECK TABLE t2 EXTENDED  /* E_R Thread5 QNO 14 CON_ID 22 */ ' passed but has a result set line 'test.t2 check Warning InnoDB: Index 'uidx2' contains 5 entries, should be 6.'.
      		 
       
      		 
      In mysql.err log seeing this entry
      		 
      [ERROR] InnoDB: Flagged corruption of `uidx2` in table `test`.`t2` in CHECK TABLE; Wrong count

      RR trace is present on SDP:-
      /data/results/1760078060/TBR-36

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37659 CHECK TABLE…EXTENDED reports a bogus error on a column prefix index

          • Major - Major loss of function.
          • In Testing

          Activity

            People

              marko Marko Mäkelä
              saahil Saahil Alam
              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.