2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
CREATE TABLE t1 (a INT AUTO_INCREMENT KEY) ENGINE=INNODB;
8
CREATE TABLE t2 (b INT AUTO_INCREMENT KEY, c INT, FOREIGN KEY(b) REFERENCES t1(a)) ENGINE=INNODB;
9
SET FOREIGN_KEY_CHECKS=0;
10
INSERT INTO t1 VALUES (10);
11
INSERT INTO t1 VALUES (NULL),(NULL),(NULL);
12
INSERT INTO t2 VALUES (5,0);
13
INSERT INTO t2 VALUES (NULL,LAST_INSERT_ID());
14
SET FOREIGN_KEY_CHECKS=1;
15
SELECT * FROM t1 ORDER BY a;
21
SELECT * FROM t2 ORDER BY b;
25
SELECT * FROM t1 ORDER BY a;
31
SELECT * FROM t2 ORDER BY b;
35
SET TIMESTAMP=1000000000;
36
CREATE TABLE t3 ( a INT UNIQUE );
37
SET FOREIGN_KEY_CHECKS=0;
38
INSERT INTO t3 VALUES (1),(1);
39
Got one of the listed errors
40
SET FOREIGN_KEY_CHECKS=0;
41
DROP TABLE IF EXISTS t1,t2,t3;
42
SET FOREIGN_KEY_CHECKS=1;
43
create table t1 (b int primary key) engine = INNODB;
44
create table t2 (a int primary key, b int, foreign key (b) references t1(b))
46
insert into t1 set b=1;
47
insert into t2 set a=1, b=1;
48
set foreign_key_checks=0;
49
set @@session.binlog_format=row;
51
must sync w/o a problem (could not with the buggy code)
52
select count(*) from t1 /* must be zero */;