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 NOT NULL,
11 `f3` blob,
12 PRIMARY KEY (`f1`)
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
27 create table t1 (f1 char(1), f2 longblob, f3 blob, primary key(f1))
28 charset=utf8 engine=innodb;
29 Warnings:
30 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
31 replace into t1 set f1=0xa3;
32 Warnings:
33 Warning 1366 Incorrect string value: '\xA3' for column 'f1' at row 1
34 select f1 from t1;
35 f1
36
37 update t1 set f1=0x6a;
38 update t1 set f3=repeat(0xb1,8103);
39 update t1 set f1=0x4a;
40 update t1 set f1=0x82;
41 Warnings:
42 Warning 1366 Incorrect string value: '\x82' for column 'f1' at row 1
43 select f1 from t1;
44 f1
45
46 drop table t1;
47 SET sql_mode = default;