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