summaryrefslogtreecommitdiff
path: root/mysql-test/t/delete_use_source.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2017-08-17 17:04:31 +0200
committerSergei Golubchik <serg@mariadb.org>2017-08-20 20:21:23 +0200
commit1b7a2e4ca2a774da23eac0a8b839f2e273cf5cd2 (patch)
treea0560834455265f514d7077e6f67257a2f029155 /mysql-test/t/delete_use_source.test
parent935c6f502f283f87f2124879801cf64af9ff4df3 (diff)
downloadmariadb-git-1b7a2e4ca2a774da23eac0a8b839f2e273cf5cd2.tar.gz
MDEV-13510 main.delete_use_source fails in buildbot and outside with wrong plan
Diffstat (limited to 'mysql-test/t/delete_use_source.test')
-rw-r--r--mysql-test/t/delete_use_source.test11
1 files changed, 6 insertions, 5 deletions
diff --git a/mysql-test/t/delete_use_source.test b/mysql-test/t/delete_use_source.test
index a54d12c3d65..93065c6fe23 100644
--- a/mysql-test/t/delete_use_source.test
+++ b/mysql-test/t/delete_use_source.test
@@ -4,9 +4,10 @@ create table t1(c1 integer not null,c2 integer not null, key (c1)) engine=InnoDb
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_50;
-insert t1 select 2,seq from seq_1_to_20;
+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;
--echo #
--echo # Delete with limit (quick select - range acces)
@@ -43,7 +44,7 @@ select count(*) from v1 where c1=2;
rollback;
--echo #
---echo # Delete throw a view with limit (range access)
+--echo # Delete through a view with limit (range access)
--echo #
start transaction;
@@ -56,7 +57,7 @@ select count(*) from v1 where c1=0;
rollback;
--echo #
---echo # Delete throw a view (ALL access)
+--echo # Delete through a view (ALL access)
--echo #
start transaction;
@@ -97,7 +98,7 @@ rollback;
drop trigger trg;
--echo #
---echo # Delete throw a view with returning
+--echo # Delete through a view with returning
--echo #
start transaction;