Debian Codegraph @

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

raw
1
2 #
3 # Bug#12661768 UPDATE IGNORE CRASHES SERVER IF TABLE IS INNODB AND IT IS
4 # PARENT FOR OTHER ONE
5 #
6
7 SET SESSION foreign_key_checks=0;
8
9 # only interested that the "UPDATE IGNORE" at the end does not crash the server
10
11 -- disable_query_log
12 -- disable_result_log
13
14 SET NAMES utf8;
15
16 -- let $t1_name = bug12661768_1ä1111111111111111111111111111111111111111111111111
17 # We would also like to test with a name like #mysql50#bug12661768_2ä (the
18 # expected result is that it should appear as #mysql50#bug12661768_2ä in the
19 # error message, but due to a bug it is reported as bug12661768_2ä. See
20 # Bug#11758916 51180: EXPLAIN_FILENAME CANNOT EXPLAIN #SQL TEMPORARY FILE NAMES
21 -- let $t2_name = bug12661768_2ä2222222222222222222222222222222222222222222
22 -- let $fk_name = ab_on_2_fkfkfäfkffkfkfkfkfkfkfkfkfkfkfkfkfkfkfkfkfkfkfkfkfkfkfk
23 -- let $key_str = 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
24
25 eval DROP TABLE IF EXISTS `$t2_name`, `$t1_name`;
26
27 eval CREATE TABLE `$t1_name` (
28 a INT,
29 b VARCHAR(512),
30 PRIMARY KEY (a, b)
31 ) ENGINE=INNODB charset latin1;
32
33 eval CREATE TABLE `$t2_name` (
34 id INT,
35 a INT,
36 b VARCHAR(512),
37 PRIMARY KEY (id),
38 UNIQUE KEY `$fk_name` (a, b),
39 FOREIGN KEY (a, b) REFERENCES `$t1_name` (a, b)
40 ON DELETE CASCADE ON UPDATE CASCADE
41 ) ENGINE=INNODB charset latin1;
42
43 eval INSERT INTO `$t1_name` VALUES (1, $key_str);
44 eval INSERT INTO `$t2_name` VALUES (100, 1, $key_str), (101, 3, $key_str);
45
46 SET SESSION foreign_key_checks=1;
47
48 -- enable_result_log
49
50 -- error ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO
51 eval UPDATE IGNORE `$t1_name` SET a = 3;
52
53 eval DROP TABLE `$t2_name`, `$t1_name`;