Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
--source include/have_debug_sync.inc
|
--source include/have_innodb.inc
|
--connect (con2, localhost, root,,)
|
--connection default
|
set default_storage_engine= innodb; |
|
|
create table t1 (a int primary key, b int as (a), key(b)); |
insert into t1(a) values (1),(2),(3); |
create table t2 (a int, foreign key (a) references t1 (a) |
on delete cascade on update cascade); |
insert into t2(a) values (1),(2),(3); |
set debug_sync= "find_table_for_vc_table_valid SIGNAL found WAIT_FOR go"; |
UPDATE t1 set a = 11 where a = 1; |
--send
|
UPDATE t1 set a = 22 where a = 2; |
--connection con2
|
set debug_sync= "now WAIT_FOR found TIMEOUT 3"; |
UPDATE t1 set a= 33 where a = 3; |
set debug_sync= "now SIGNAL go"; |
|
--connection default
|
--reap
|
|
# Cleanup
|
drop table t1, t2; |
set debug_sync= reset; |
--connection default |
Attachments
Issue Links
- relates to
-
MDEV-29068 Cascade foreign key updates do not apply in online alter
- Closed
-
MDEV-29181 Potential corruption on Foreign key update on a table with vcol index
- Stalled