2
# Bug#12661768 UPDATE IGNORE CRASHES SERVER IF TABLE IS INNODB AND IT IS
6
-- source include/have_innodb.inc
8
SET SESSION foreign_key_checks=0;
10
# only interested that the "UPDATE IGNORE" at the end does not crash the server
17
-- let $t1_name = bug12661768_1
18
-- let $t2_name = bug12661768_2
19
-- let $fk_name = ab_on_2
20
-- let $key_str = 'bbb'
22
eval DROP TABLE IF EXISTS `$t2_name`, `$t1_name`;
24
eval CREATE TABLE `$t1_name` (
30
eval CREATE TABLE `$t2_name` (
35
UNIQUE KEY `$fk_name` (a, b),
36
FOREIGN KEY (a, b) REFERENCES `$t1_name` (a, b)
37
ON DELETE CASCADE ON UPDATE CASCADE
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);
43
SET SESSION foreign_key_checks=1;
47
-- error ER_FOREIGN_DUPLICATE_KEY
48
eval UPDATE IGNORE `$t1_name` SET a = 3;
50
eval DROP TABLE `$t2_name`, `$t1_name`;