1
CREATE TABLE bug53046_1 (c1 INT PRIMARY KEY) ENGINE=INNODB;
2
CREATE TABLE bug53046_2 (c2 INT PRIMARY KEY,
3
FOREIGN KEY (c2) REFERENCES bug53046_1(c1)
4
ON UPDATE CASCADE ON DELETE CASCADE) ENGINE=INNODB;
5
INSERT INTO bug53046_1 VALUES (1);
6
INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
8
INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
10
INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
12
INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
14
INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
16
INSERT INTO bug53046_2 VALUES (1), (2);
17
ANALYZE TABLE bug53046_1;
18
Table Op Msg_type Msg_text
19
test.bug53046_1 analyze status OK
20
SHOW TABLE STATUS LIKE 'bug53046_1';
21
UPDATE bug53046_1 SET c1 = c1 - 1;
22
DELETE FROM bug53046_1;
23
INSERT INTO bug53046_1 VALUES (1);
24
INSERT INTO bug53046_2 VALUES (1);
25
TRUNCATE TABLE bug53046_2;
26
DROP TABLE bug53046_2;
27
DROP TABLE bug53046_1;