diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2013-12-30 20:30:29 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2013-12-30 20:30:29 +0400 |
| commit | f8c7e3477f17488f546ab5d20c4fad6aa0577d01 (patch) | |
| tree | a5d4b8a3fbe8377a1949da06782016174e046f99 /mysql-test/t/subselect_sj.test | |
| parent | 50808b30d26b02837dbd7d0a9c9efbc89f2ff6eb (diff) | |
| download | mariadb-git-f8c7e3477f17488f546ab5d20c4fad6aa0577d01.tar.gz | |
MDEV-5349: Test main.subselect_sj_jcl6 fails sporadically due to insufficient ordering
- Add --sorted_result to the query
Diffstat (limited to 'mysql-test/t/subselect_sj.test')
| -rw-r--r-- | mysql-test/t/subselect_sj.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj.test b/mysql-test/t/subselect_sj.test index 536606175bb..a6ce3f25617 100644 --- a/mysql-test/t/subselect_sj.test +++ b/mysql-test/t/subselect_sj.test @@ -2634,6 +2634,7 @@ INSERT INTO t2 VALUES ('x'); CREATE TABLE t3 (c3 VARCHAR(1)) ENGINE=MyISAM; INSERT INTO t3 VALUES ('x'),('d'); +--sorted_result SELECT * FROM t1, t2 WHERE pk IN ( SELECT pk FROM t1 LEFT JOIN t3 ON (c1 = c3 ) ) ORDER BY c2, c1; --echo # This should show that "t1 left join t3" is still in the semi-join nest: |