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

MVCC read from index on CHAR or VARCHAR wrongly omits rows

    XMLWordPrintable

Details

    Description

      origin/10.6 af418bb9ef7e422282dc976640409a6af8fcd58c 2021-04-19T14:04:02+10:00
       
      Scenario:
      1. Start the server, create one table and fill it with 100 rows.
      2. Session 1 runs in a loop some update like
           UPDATE table100_innodb_int_autoinc SET `col_varchar_255_ucs2_key` = CONVERT( 'degsotrsfannidwyvkuvlkeslrryhpkeevqmbksdrzadzpyisznignsytihyjixyalxfxpnafjwzgnkbbayklurufrsajtzohanbuvcfyykvtmesobixwipkoihhqykvoejckythjnjshxgohmecmklxryubdexjgxehdiqqui' USING ASCII )
          Session 2 runs in a loop
          CHECK TABLE table100_innodb_int_autoinc EXTENDED
      After short time the CHECK TABLE harvests a
      test.table100_innodb_int_autoinc check Warning InnoDB: Index 'col_varchar_255_ucs2_key' contains 98 entries, should be 100.
       
      sdp:/data/Results/1618846463/TBR-36/dev/shm/vardir/1618846463/4/1/rr
           
      

      Attachments

        1. simp_many_indexes.cfg
          43 kB
          Matthias Leich
        2. TBR-36_micro.yy
          0.9 kB
          Matthias Leich
        3. TBR-36.zz
          1 kB
          Matthias Leich

        Issue Links

          Activity

            People

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