1# 2# Copyright (c) 2014 Oracle and/or its affiliates. All rights reserved. 3# 4 5# This file contains test cases for checking the functionality "update by 6# delete + insert". 7 8--source include/have_innodb.inc 9 10--echo # 11--echo # Bug#14668683 ASSERT REC_GET_DELETED_FLAG(REC, PAGE_IS_COMP(PAGE)) 12--echo # 13 14create table t1(f1 char(1) primary key, f2 int not null, f3 blob) 15engine=innodb; 16show create table t1; 17 18insert into t1 values ('a', 0, repeat('b',8102)); 19select f1 from t1; 20update t1 set f1='A'; 21select f1 from t1; 22drop table t1; 23 24--echo # 25--echo # Another test case 26--echo # 27create table t1 (f1 char(1), f2 longblob, f3 blob, primary key(f1)) 28charset=utf8 engine=innodb; 29 30set statement sql_mode = '' for 31replace into t1 set f1=0xa3; 32select f1 from t1; 33update t1 set f1=0x6a; 34update t1 set f3=repeat(0xb1,8103); 35update t1 set f1=0x4a; 36update ignore t1 set f1=0x82; 37select f1 from t1; 38 39drop table t1; 40