summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/t/innodb-update-insert.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb/t/innodb-update-insert.test')
-rw-r--r--mysql-test/suite/innodb/t/innodb-update-insert.test3
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/suite/innodb/t/innodb-update-insert.test b/mysql-test/suite/innodb/t/innodb-update-insert.test
index 95387e0564e..d7a706611c9 100644
--- a/mysql-test/suite/innodb/t/innodb-update-insert.test
+++ b/mysql-test/suite/innodb/t/innodb-update-insert.test
@@ -27,12 +27,13 @@ drop table t1;
create table t1 (f1 char(1), f2 longblob, f3 blob, primary key(f1))
charset=utf8 engine=innodb;
+set statement sql_mode = '' for
replace into t1 set f1=0xa3;
select f1 from t1;
update t1 set f1=0x6a;
update t1 set f3=repeat(0xb1,8103);
update t1 set f1=0x4a;
-update t1 set f1=0x82;
+update ignore t1 set f1=0x82;
select f1 from t1;
drop table t1;