mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
deff3f7572
ignore FK-prelocked tables when looking for write-prelocked tables with auto-increment to complain about "Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column"
26 lines
733 B
Text
26 lines
733 B
Text
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;
|