source include/have_innodb.inc; source include/have_binlog_format_statement.inc; # # MDEV-18466 Unsafe to log updates on tables referenced by foreign keys with triggers in statement format # create table categories( cat_id int not null primary key, cat_name varchar(255) not null, cat_description text ) engine=innodb; create table products( prd_id int not null auto_increment primary key, prd_name varchar(355) not null, prd_price decimal, cat_id int not null, foreign key fk_cat(cat_id) references categories(cat_id) on update cascade ) engine=innodb; insert into categories values (1, 'drinks', 'drinks'); update categories set cat_description=2 where cat_id=1; drop table products, categories;