CREATE TABLE t (f CHAR(8) DEFAULT '0', vf INT GENERATED ALWAYS AS (f) STORED);

INSERT INTO t (f) VALUES ('1');

--connect (con1,localhost,root,,)

--send

  ALTER TABLE t ADD COLUMN a INT, ALGORITHM=COPY, LOCK=NONE;

--connection default

--sleep 0.001

INSERT IGNORE INTO t (f) VALUES ('');

--connection con1

--error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD

--reap

--error 0,1

--exec grep 'Slave SQL' $MYSQLTEST_VARDIR/log/mysqld.1.err

--let $err= $sys_errno

# Cleanup

DROP TABLE t;

--disconnect con1

if ($err == 0)

{

  --die # Found Slave SQL errors in the log

}

2023-04-16 14:33:29 5 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table test.t; Incorrect integer value: '' for column `test`.`t`.`vf` at row 2, Error_code: 1366; Got error 1 "Operation not permitted" from storage engine MyISAM, Error_code: 1030; handler error No Error!; the event's master log FIRST, end_log_pos 39, Internal MariaDB error code: 1366

2023-04-16 14:34:02 5 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table test.t; Incorrect integer value: '' for column `test`.`t`.`vf` at row 2, Error_code: 1366; Got error 1 "Operation not permitted" from storage engine Aria, Error_code: 1030; handler error No Error!; the event's master log FIRST, end_log_pos 39, Internal MariaDB error code: 1366

2023-04-16 14:34:27 5 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table test.t; Incorrect integer value: '' for column `test`.`t`.`vf` at row 2, Error_code: 1366; Got error 1 "Operation not permitted" from storage engine InnoDB, Error_code: 1030; handler error No Error!; the event's master log FIRST, end_log_pos 39, Internal MariaDB error code: 1366