| 1 |
CREATE TABLE bug59733(a INT AUTO_INCREMENT PRIMARY KEY,b CHAR(1)) ENGINE=InnoDB |
| 2 |
STATS_PERSISTENT=1 STATS_AUTO_RECALC=0; |
| 3 |
INSERT INTO bug59733 VALUES(0,'x'); |
| 4 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 5 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 6 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 7 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 8 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 9 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 10 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 11 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 12 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 13 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 14 |
INSERT INTO bug59733 SELECT 0,b FROM bug59733; |
| 15 |
CREATE INDEX b ON bug59733 (b); |
| 16 |
DELETE FROM bug59733 WHERE (a%100)=0; |
| 17 |
DROP INDEX b ON bug59733; |
| 18 |
CREATE INDEX b ON bug59733 (b); |
| 19 |
DROP TABLE bug59733; |