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

            psergei Sergei Petrunia
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.