| 1 |
CREATE TABLE bug18384390 ( |
| 2 |
id INT AUTO_INCREMENT PRIMARY KEY, |
| 3 |
txt VARCHAR(10000) |
| 4 |
) ENGINE=INNODB STATS_AUTO_RECALC=0; |
| 5 |
INSERT INTO bug18384390 (txt) VALUES (REPEAT('0', 10000)); |
| 6 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 7 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 8 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 9 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 10 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 11 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 12 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 13 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 14 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 15 |
INSERT INTO bug18384390 (txt) SELECT txt FROM bug18384390; |
| 16 |
ANALYZE TABLE bug18384390; |
| 17 |
Table Op Msg_type Msg_text |
| 18 |
test.bug18384390 analyze status OK |
| 19 |
DROP TABLE bug18384390; |