Debian Codegraph @

mysql-test/suite/innodb/r/lob_update.result

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