Debian Codegraph @

mysql-test/suite/galera/t/galera_fk_truncate.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Make sure earlier test has no effect to this one
6 #
7 --connection node_1
8 set global auto_increment_offset=1;
9 set global auto_increment_increment=2;
10 --connection node_2
11 set global auto_increment_offset=2;
12 set global auto_increment_increment=2;
13
14 --connection node_1
15 CREATE TABLE author (
16 id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
17 name VARCHAR(100) NOT NULL
18 ) ENGINE = InnoDB;
19
20 CREATE TABLE book (
21 id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
22 title VARCHAR(200) NOT NULL,
23 author_id SMALLINT UNSIGNED NOT NULL,
24 CONSTRAINT `fk_book_author`
25 FOREIGN KEY (author_id) REFERENCES author (id)
26 ON DELETE CASCADE
27 ON UPDATE RESTRICT
28 ) ENGINE = InnoDB;
29
30 INSERT INTO author (name) VALUES ('Abdul Alhazred');
31 INSERT INTO book (title, author_id) VALUES ('Necronomicon', LAST_INSERT_ID());
32
33 TRUNCATE TABLE book;
34 SELECT * FROM author;
35 SELECT * FROM book;
36
37 --connection node_2
38 SELECT * FROM author;
39 SELECT * FROM book;
40 INSERT INTO author (name) VALUES ('Abdul Alhazred');
41 INSERT INTO book (title, author_id) VALUES ('Necronomicon', LAST_INSERT_ID());
42 TRUNCATE TABLE book;
43 SELECT * FROM author;
44 SELECT * FROM book;
45
46 --connection node_1
47 TRUNCATE TABLE book;
48 SELECT * FROM author;
49 SELECT * FROM book;
50
51 DROP TABLE book, author;
52 set global auto_increment_increment=2;
53 --connection node_2
54 set global auto_increment_offset=2;
55
56