636
636
drop table t1, t2, t3;
638
# Bug#49534: multitable IGNORE update with sql_safe_updates error
639
# causes debug assertion
641
CREATE TABLE t1( a INT, KEY( a ) );
642
INSERT INTO t1 VALUES (1), (2), (3);
643
SET SESSION sql_safe_updates = 1;
644
# Must not cause failed assertion
645
UPDATE IGNORE t1, t1 t1a SET t1.a = 1 WHERE t1a.a = 1;
646
ERROR HY000: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column