innodb_zip.innodb_prefix_index_liftedlimit 'xtradb' w4 [ fail ]  timeout after 9000 seconds

        Test ended at 2016-07-28 06:17:14

Test case timeout after 9000 seconds

== /mnt/data/buildot/maria-slave/work-opensuse-amd64/build/mysql-test/var/4/log/innodb_prefix_index_liftedlimit.log == 

DROP TABLE worklog5743_key4;

CREATE TABLE worklog5743_key8 (

col_1_blob BLOB (4000) , col_2_blob BLOB (4000) ,

PRIMARY KEY (col_1_blob(3072))

) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, engine = innodb;

INSERT INTO worklog5743_key8 VALUES(REPEAT("a", 4000) , REPEAT("o", 4000));

INSERT INTO worklog5743_key8 VALUES(REPEAT("b", 4000) , REPEAT("p", 4000));

SELECT col_1_blob  = REPEAT("a", 4000) , col_2_blob = REPEAT("o", 4000)

FROM worklog5743_key8;

col_1_blob  = REPEAT("a", 4000)	col_2_blob = REPEAT("o", 4000)

1	1

0	0

UPDATE worklog5743_key8 SET col_1_blob = REPEAT("c", 4000)

WHERE col_1_blob = REPEAT("a", 4000) AND col_2_blob = REPEAT("o", 4000);

SELECT col_1_blob = REPEAT("b", 3500) FROM worklog5743_key8

WHERE col_1_blob = REPEAT("c", 4000) AND col_2_blob = REPEAT("o", 4000);

col_1_blob = REPEAT("b", 3500)

0

INSERT INTO worklog5743_key8 VALUES(REPEAT("a", 4000),REPEAT("o", 4000));

DELETE FROM worklog5743_key8 WHERE col_1_blob = REPEAT("b", 4000);