# # Bug #30288139 MARK_NOT_PARTIALLY_UPDATABLE ASSERTION FAILURE: # BUF0BUF.CC:4189:PAGE_SIZE.EQUALS # CREATE TABLE tb (id INT PRIMARY KEY, t1 LONGBLOB, t2 LONGBLOB, v1 CHAR(2) AS (SUBSTR(t1,2,2)) VIRTUAL, INDEX(id,v1)) ROW_FORMAT=COMPRESSED; INSERT INTO tb (id,t1,t2) VALUES (1,REPEAT("x",100000),REPEAT("y",100000)); UPDATE tb SET t1=REPEAT("y",100000),t2=REPEAT("x",100000) WHERE id=1; UPDATE tb SET t1="a" WHERE id=1; DROP TABLE tb;