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

MariaRocks: rocksdb.type_text_indexes fails

Details

    Description

      rocksdb.type_text_indexes                [ fail ]
      		 
              Test ended at 2016-11-20 21:04:33
      		 
       
      		 
      CURRENT_TEST: rocksdb.type_text_indexes
      		 
      mysqltest: At line 164: query 'INSERT INTO t1 (b) VALUES (''), (_binary 0x0), (' ')' succeeded - should have failed with errno 1062...

      A part of testcase that fails:

      CREATE TABLE t1 (
      		 
        b LONGTEXT CHARACTER SET "latin1" COLLATE "latin1_bin",
      		 
        PRIMARY KEY b (b(32))
      		 
      ) ENGINE=rocksdb;
      		 
       
      		 
      --error ER_DUP_ENTRY
      		 
      INSERT INTO t1 (b) VALUES (''), (_binary 0x0), (' ');

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24250 Sorting behavior changed from 10.1 to 10.3

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-9658 Make MyRocks in MariaDB stable

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia added a comment - - edited

            The difference comes from

            void Field_blob::make_sort_key(uchar *to,uint length)

            In MariaDB the function was renamed to 

            void Field_blob::sort_string(uchar *to,uint length)

            MariaDB:

              if (!blob_length)
            		 
                bzero(to,length);

            facebook/mysql-5.6:

              if (!blob_length && field_charset->pad_char == 0)
            		 
                memset(to, 0, length);

            psergei Sergei Petrunia added a comment - - edited The difference comes from void Field_blob::make_sort_key(uchar *to,uint length) In MariaDB the function was renamed to void Field_blob::sort_string(uchar *to,uint length) MariaDB: if (!blob_length) bzero(to,length); facebook/mysql-5.6: if (!blob_length && field_charset->pad_char == 0) memset(to, 0, length);
            psergei Sergei Petrunia added a comment -

            The change in facebook/mysql-5.6 comes from:
            https://github.com/facebook/mysql-5.6/commit/c6ba56ca777d97ff73ed695b78a23674a3abed85

            This is a bug in MySQL: http://bugs.mysql.com/bug.php?id=81810 , that is also repeatable in MariaDB.

            psergei Sergei Petrunia added a comment - The change in facebook/mysql-5.6 comes from: https://github.com/facebook/mysql-5.6/commit/c6ba56ca777d97ff73ed695b78a23674a3abed85 This is a bug in MySQL: http://bugs.mysql.com/bug.php?id=81810 , that is also repeatable in MariaDB.
            psergei Sergei Petrunia added a comment -

            Fix pushed into 10.2-mariarocks tree.

            psergei Sergei Petrunia added a comment - Fix pushed into 10.2-mariarocks tree.

            People

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