diff options
| author | Dmitry Shulga <dmitry.shulga@mariadb.com> | 2021-05-18 08:50:57 +0700 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2021-06-17 19:30:24 +0200 |
| commit | b33111ba93a6bc279a51b512033e42e702cf5ed7 (patch) | |
| tree | e2766341617a3ae23352bcc36857a1c0ef6d855a /mysql-test/main/join_cache.test | |
| parent | 129098b70ce4a30bad600ea4dc2703e4edadfe88 (diff) | |
| download | mariadb-git-b33111ba93a6bc279a51b512033e42e702cf5ed7.tar.gz | |
MDEV-16708: Fixed the failed test main.join_cache
Diffstat (limited to 'mysql-test/main/join_cache.test')
| -rw-r--r-- | mysql-test/main/join_cache.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/join_cache.test b/mysql-test/main/join_cache.test index b4271f648e3..4b659345db4 100644 --- a/mysql-test/main/join_cache.test +++ b/mysql-test/main/join_cache.test @@ -3998,12 +3998,12 @@ insert into t1 values (1), (2); insert into t2 values (1), (2); insert into t3 values (2); +set @counter=0; + explain select count(*) from t1 straight_join t2 where c1 = c2-0 and c2 <= (select max(c3) from t3 where c3 = 2 and @counter:=@counter+1); -set @counter=0; - select count(*) from t1 straight_join t2 where c1 = c2-0 and c2 <= (select max(c3) from t3 where c3 = 2 and @counter:=@counter+1); |