Debian Codegraph @

mysql-test/suite/galera/r/galera_fk_truncate.result

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