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

rocksdb.add_index_inplace fails randomly with wrong result with FORCE INDEX

    XMLWordPrintable

    Details

      Description

      rocksdb.add_index_inplace 'write_prepared' w2 [ fail ]
      CURRENT_TEST: rocksdb.add_index_inplace
      --- D:/winx64-packages/build/src/storage/rocksdb/mysql-test/rocksdb/r/add_index_inplace.result	2019-08-16 07:57:33.000000000 +0000
      +++ D:\winx64-packages\build\src\storage\rocksdb\mysql-test\rocksdb\r\add_index_inplace.reject	2019-08-16 11:32:23.060422600 +0000
      @@ -322,7 +322,7 @@
       1
       SELECT COUNT(*) FROM t1 FORCE INDEX(kj);
       COUNT(*)
      -1
      +0
       DROP TABLE t1;
       disconnect con2;
       # Establish connection con1 (user=root)
      

      This happened for me in buildbot in 10.5 yesterday and according to cross reference report happens quite often

        Attachments

          Activity

            People

            Assignee:
            psergey Sergei Petrunia
            Reporter:
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: