diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-08-17 17:04:31 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-08-20 20:21:23 +0200 |
| commit | 1b7a2e4ca2a774da23eac0a8b839f2e273cf5cd2 (patch) | |
| tree | a0560834455265f514d7077e6f67257a2f029155 /mysql-test/t/delete_use_source.test | |
| parent | 935c6f502f283f87f2124879801cf64af9ff4df3 (diff) | |
| download | mariadb-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.test | 11 |
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; |
