20 lines
880 B
Plaintext
20 lines
880 B
Plaintext
CREATE TABLE bug18384390 (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
txt VARCHAR(10000)
|
|
) ENGINE=INNODB STATS_AUTO_RECALC=0;
|
|
INSERT INTO bug18384390 (txt) VALUES (REPEAT('0', 10000));
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390;
|
|
ANALYZE TABLE bug18384390;
|
|
Table Op Msg_type Msg_text
|
|
test.bug18384390 analyze status OK
|
|
DROP TABLE bug18384390;
|