diff options
| author | Igor Babaev <igor@askmonty.org> | 2014-06-10 10:34:58 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2014-06-10 10:34:58 -0700 |
| commit | d42e6d3a9966803336a3edbb356d344647b31b98 (patch) | |
| tree | 74728dba9f9d41d5f02e9ada395dff534d962777 /mysql-test/t/subselect_sj.test | |
| parent | 216fbe2af3c8dc81f492af79dee61d6a3d333678 (diff) | |
| download | mariadb-git-d42e6d3a9966803336a3edbb356d344647b31b98.tar.gz | |
Fixed bug mdev-6071.
The method JOIN_CACHE::init may fail (return 1) if some conditions on the
used join buffer is not satisfied. For example it fails if join_buffer_size
is greater than join_buffer_space_limit. The conditions should be checked
when running the EXPLAIN command for the query. That's why the method
JOIN_CACHE::init has to be called for EXPLAIN commands as well.
Diffstat (limited to 'mysql-test/t/subselect_sj.test')
| -rw-r--r-- | mysql-test/t/subselect_sj.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj.test b/mysql-test/t/subselect_sj.test index 4003b9c5ff8..2c60e5645c3 100644 --- a/mysql-test/t/subselect_sj.test +++ b/mysql-test/t/subselect_sj.test @@ -79,6 +79,8 @@ select * from t1 left join (t2 A, t2 B) on ( A.a= t1.a and B.a in (select pk fro explain extended select * from t1 left join t2 on (t2.a= t1.a and t2.a in (select pk from t10)); +set join_buffer_size=8*1024; + --echo we shouldn't flatten if we're going to get a join of > MAX_TABLES. explain select * from t1 s00, t1 s01, t1 s02, t1 s03, t1 s04,t1 s05,t1 s06,t1 s07,t1 s08,t1 s09, @@ -97,6 +99,8 @@ select * from t1 left join t2 on (t2.a= t1.a and t2.a in (select pk from t10)) where t1.a < 5; +set join_buffer_size=default; + # # Prepared statements # |