12758
12758
DROP TABLE t1;
12760
# BUG#57162 - valgrind errors, random data when returning
12761
# ordered data from archive tables
12763
SET sort_buffer_size=32804;
12764
CREATE TABLE t1(a INT, b CHAR(255), c CHAR(255), d CHAR(255),
12765
e CHAR(255), f INT) ENGINE=ARCHIVE DEFAULT CHARSET utf8;
12766
INSERT INTO t1 VALUES(-1,'b','c','d','e',1);
12767
INSERT INTO t1 SELECT * FROM t1;
12768
INSERT INTO t1 SELECT * FROM t1;
12769
INSERT INTO t1 SELECT t1.* FROM t1,t1 t2,t1 t3,t1 t4,t1 t5,t1 t6;
12770
SELECT * FROM t1 ORDER BY f LIMIT 1;
12774
SET sort_buffer_size=DEFAULT;
12776
# BUG#11758979 - 51252: ARCHIVE TABLES CAUSE 100% CPU USAGE
12777
# AND HANG IN SHOW TABLE STATUS
12778
# (to be executed with valgrind)
12779
CREATE TABLE t1(a BLOB, b VARCHAR(200)) ENGINE=ARCHIVE;
12780
INSERT INTO t1 VALUES(NULL, '');
12782
# we need this select to workaround BUG#11764364
12786
CHECKSUM TABLE t1 EXTENDED;
12791
Table Op Msg_type Msg_text
12792
test.t1 optimize status OK