Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.6
-
None
Description
--source include/have_innodb.inc
|
|
create table t1 (pk int primary key) engine=InnoDB; |
insert into t1 values (1),(2),(3); |
|
set global innodb_read_only_compressed= off; |
create table t2 (a int, foreign key (a) references t1(pk) on update cascade on delete cascade) engine=InnoDB row_format=compressed; |
insert into t2 values (1),(2),(3); |
set global innodb_read_only_compressed= on; |
|
update t1 set pk = 10 where pk = 1; |
delete from t1 where pk = 2; |
|
select * from t2; |
|
# Cleanup
|
drop table t2, t1; |
10.6 d317350a |
update t1 set pk = 10 where pk = 1; |
delete from t1 where pk = 2; |
select * from t2; |
a
|
3
|
10
|
Attachments
Issue Links
- is caused by
-
MDEV-23497 make ROW_FORMAT=COMPRESSED read-only by default
- Closed