[MDEV-11320] MariaRocks: rocksdb.type_text_indexes fails Created: 2016-11-20  Updated: 2020-11-22  Resolved: 2016-11-21

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-9658 Make MyRocks in MariaDB stable Closed
Problem/Incident
causes MDEV-24250 Sorting behavior changed from 10.1 to... Closed

 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), (' ');



 Comments   
Comment by Sergei Petrunia [ 2016-11-20 ]

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);

Comment by Sergei Petrunia [ 2016-11-20 ]

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.

Comment by Sergei Petrunia [ 2016-11-21 ]

Fix pushed into 10.2-mariarocks tree.

Generated at Thu Feb 08 07:49:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.