Debian Codegraph @

mysql-test/suite/innodb/t/lob_update.test

raw
1
2 --echo #
3 --echo # Bug #30288139 MARK_NOT_PARTIALLY_UPDATABLE ASSERTION FAILURE:
4 --echo # BUF0BUF.CC:4189:PAGE_SIZE.EQUALS
5 --echo #
6
7 --source include/have_innodb_max_16k.inc
8
9 CREATE TABLE tb
10 (id INT PRIMARY KEY,
11 t1 LONGBLOB,
12 t2 LONGBLOB,
13 v1 CHAR(2) AS (SUBSTR(t1,2,2)) VIRTUAL,
14 INDEX(id,v1)) ROW_FORMAT=COMPRESSED;
15
16 INSERT INTO tb (id,t1,t2) VALUES (1,REPEAT("x",100000),REPEAT("y",100000));
17 UPDATE tb SET t1=REPEAT("y",100000),t2=REPEAT("x",100000) WHERE id=1;
18 UPDATE tb SET t1="a" WHERE id=1;
19
20 DROP TABLE tb;