Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug53046.result

raw
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)
7 FROM bug53046_1;
8 INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
9 FROM bug53046_1;
10 INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
11 FROM bug53046_1;
12 INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
13 FROM bug53046_1;
14 INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
15 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;