diff options
| author | Monty <monty@mariadb.org> | 2021-05-26 14:53:26 +0300 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2021-05-26 14:53:26 +0300 |
| commit | 1e5ebf3762abdb8108620b46e76d4ebdde8472f7 (patch) | |
| tree | ab4d8a3471d02271fb8b6e4f0df154a55377b731 | |
| parent | aa284e02374c2abdb9ae660c232c076276d2ce98 (diff) | |
| download | mariadb-git-1e5ebf3762abdb8108620b46e76d4ebdde8472f7.tar.gz | |
Fixed results for main.delete_use_source to make it repeatable
| -rw-r--r-- | mysql-test/main/delete_use_source.result | 4 | ||||
| -rw-r--r-- | mysql-test/main/delete_use_source.test | 1 |
2 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/main/delete_use_source.result b/mysql-test/main/delete_use_source.result index ae2f7b93208..3e2feb46cc9 100644 --- a/mysql-test/main/delete_use_source.result +++ b/mysql-test/main/delete_use_source.result @@ -64,8 +64,8 @@ rollback; start transaction; explain delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500; id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL c1 NULL NULL NULL 670 Using where -2 DEPENDENT SUBQUERY b ref c1 c1 4 test.t1.c1 83 Using index +1 PRIMARY t1 ALL c1 NULL NULL NULL # Using where +2 DEPENDENT SUBQUERY b ref c1 c1 4 test.t1.c1 # Using index delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 ; affected rows: 500 select count(*) from v1 where c1=0; diff --git a/mysql-test/main/delete_use_source.test b/mysql-test/main/delete_use_source.test index ed4c62b090c..4aed00da375 100644 --- a/mysql-test/main/delete_use_source.test +++ b/mysql-test/main/delete_use_source.test @@ -64,6 +64,7 @@ rollback; --echo # start transaction; +--replace_column 9 # explain delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500; --enable_info ONCE delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 ; |