Details
Description
10.4 f5dceafd |
$ perl ./mtr main.delete_use_source --view-protocol |
|
main.delete_use_source 'innodb' [ fail ] timeout after 900 seconds |
|
create table t1(c1 integer not null,c2 integer not null, key (c1)) |
ENGINE=InnoDB STATS_PERSISTENT=1;
|
create view v1 as select * from t1 where c1 in (0,1); |
insert t1 select 0,seq from seq_1_to_500; |
insert t1 select 1,seq from seq_1_to_100; |
insert t1 select 2,seq from seq_1_to_50; |
insert t1 select 3,seq from seq_1_to_20; |
analyze table t1; |
Table Op Msg_type Msg_text |
test.t1 analyze status OK
|
#
|
# Delete with limit (quick select - range acces) |
#
|
start transaction; |
delete from t1 where (select count(*) from t1 b where b.c1=t1.c1) = 500 limit 1; |
affected rows: 1 |
delete from t1 where (select count(*) from t1 b where b.c1=t1.c1) = 500 limit 1; |
affected rows: 0 |
select count(*) from v1 where c1=0; |
Attachments
Issue Links
- relates to
-
MDEV-31455 main.events_stress or events.events_stress fails with view-protocol
- Closed
-
MDEV-31465 main.sum_distinct-big and main.merge-big fail with timeout with view-protocol
- Closed