$ 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;