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