Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bug12661768.test

raw
1 #
2 # Bug#12661768 UPDATE IGNORE CRASHES SERVER IF TABLE IS INNODB AND IT IS
3 # PARENT FOR OTHER ONE
4 #
5
6 -- source include/have_innodb.inc
7
8 SET SESSION foreign_key_checks=0;
9
10 # only interested that the "UPDATE IGNORE" at the end does not crash the server
11
12 -- disable_query_log
13 -- disable_result_log
14
15 SET NAMES utf8;
16
17 -- let $t1_name = bug12661768_1
18 -- let $t2_name = bug12661768_2
19 -- let $fk_name = ab_on_2
20 -- let $key_str = 'bbb'
21
22 eval DROP TABLE IF EXISTS `$t2_name`, `$t1_name`;
23
24 eval CREATE TABLE `$t1_name` (
25 a INT,
26 b VARCHAR(512),
27 PRIMARY KEY (a, b)
28 ) ENGINE=INNODB;
29
30 eval CREATE TABLE `$t2_name` (
31 id INT,
32 a INT,
33 b VARCHAR(512),
34 PRIMARY KEY (id),
35 UNIQUE KEY `$fk_name` (a, b),
36 FOREIGN KEY (a, b) REFERENCES `$t1_name` (a, b)
37 ON DELETE CASCADE ON UPDATE CASCADE
38 ) ENGINE=INNODB;
39
40 eval INSERT INTO `$t1_name` VALUES (1, $key_str);
41 eval INSERT INTO `$t2_name` VALUES (100, 1, $key_str), (101, 3, $key_str);
42
43 SET SESSION foreign_key_checks=1;
44
45 -- enable_result_log
46
47 -- error ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO
48 eval UPDATE IGNORE `$t1_name` SET a = 3;
49
50 eval DROP TABLE `$t2_name`, `$t1_name`;