Debian Codegraph @

mysql-test/suite/innodb/r/innodb-update-insert.result

raw
1 #
2 # Bug#14668683 ASSERT REC_GET_DELETED_FLAG(REC, PAGE_IS_COMP(PAGE))
3 #
4 create table t1(f1 char(1) primary key, f2 int not null, f3 blob)
5 engine=innodb;
6 show create table t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `f1` char(1) NOT NULL,
10 `f2` int(11) NOT NULL,
11 `f3` blob DEFAULT NULL,
12 PRIMARY KEY (`f1`)
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
14 insert into t1 values ('a', 0, repeat('b',8102));
15 select f1 from t1;
16 f1
17 a
18 update t1 set f1='A';
19 select f1 from t1;
20 f1
21 A
22 drop table t1;
23 #
24 # Another test case
25 #
26 create table t1 (f1 char(1), f2 longblob, f3 blob, primary key(f1))
27 charset=utf8 engine=innodb;
28 set statement sql_mode = '' for
29 replace into t1 set f1=0xa3;
30 Warnings:
31 Warning 1366 Incorrect string value: '\xA3' for column `test`.`t1`.`f1` at row 1
32 select f1 from t1;
33 f1
34 ?
35 update t1 set f1=0x6a;
36 update t1 set f3=repeat(0xb1,8103);
37 update t1 set f1=0x4a;
38 update ignore t1 set f1=0x82;
39 Warnings:
40 Warning 1366 Incorrect string value: '\x82' for column `test`.`t1`.`f1` at row 1
41 select f1 from t1;
42 f1
43 ?
44 drop table t1;