--source include/have_innodb.inc

CREATE TABLE t0 (pk integer primary key) WITH SYSTEM VERSIONING ENGINE=innodb ;

CREATE TABLE t1 (pk integer primary key REFERENCES t0(pk) 

                          ON DELETE RESTRICT ON UPDATE CASCADE)  ENGINE=innodb ;

CREATE TABLE t2 (pk integer)  ENGINE=innodb ;

INSERT INTO t0 (pk) VALUES (1) ;

INSERT INTO t1 (pk) VALUES (1) ;

INSERT INTO t2 (pk) VALUES (1) ;

# ALTER TABLE t1 ADD FOREIGN KEY (pk)  ;

# FLUSH TABLES;

--error ER_ROW_IS_REFERENCED_2

DELETE FROM t0;

--echo # Succeeds!

REPLACE t0 values (1);

SELECT * FROM t0 INTO OUTFILE 'load_table1_innodb_int_autoinc';

--echo # Also succeeds!

LOAD DATA INFILE 'load_table1_innodb_int_autoinc' REPLACE INTO TABLE t0;

DELETE t0, t2 FROM t0 join t2;

select pk as `empty!` from t0;

DROP TABLE t1, t0, t2;