Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
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
- blocks
-
MDEV-35896 Merge applicable changes from InnoDB 8.0.41
-
- Closed
-
- 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
-
- links to