[MDEV-41589] ALTER INPLACE results in Assertion `data_size < srv_sort_buf_size' failed. - Jira

XML

Word

Printable

ALTER INPLACE which requires table rebuild hits debug assertion. Assertion `data_size < srv_sort_buf_size' failed.

In release build it can result in data loss

 CREATE TABLE t2(id INT PRIMARY KEY, c1 INT) ENGINE=InnoDB;

  INSERT INTO t2 VALUES(1,100),(2,200);

  ALTER TABLE t2 DROP PRIMARY KEY, ADD PRIMARY KEY(c1),

    ADD COLUMN c3 LONGBLOB DEFAULT (REPEAT('a',2000000)), ALGORITHM=INPLACE;

  SELECT COUNT(*) FROM t2;

Discovered during review of MDEV-37467

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.