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/r/subselect_sj.result | |
| 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/r/subselect_sj.result')
| -rw-r--r-- | mysql-test/r/subselect_sj.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/subselect_sj.result b/mysql-test/r/subselect_sj.result index 0e9d8240843..0e028cc7f51 100644 --- a/mysql-test/r/subselect_sj.result +++ b/mysql-test/r/subselect_sj.result @@ -2931,10 +2931,10 @@ CREATE TABLE t3 (c3 VARCHAR(1)) ENGINE=MyISAM; INSERT INTO t3 VALUES ('x'),('d'); SELECT * FROM t1, t2 WHERE pk IN ( SELECT pk FROM t1 LEFT JOIN t3 ON (c1 = c3 ) ) ORDER BY c2, c1; pk c1 c2 -4 NULL x -3 c x 1 v x 2 v x +3 c x +4 NULL x 5 x x # This should show that "t1 left join t3" is still in the semi-join nest: EXPLAIN EXTENDED |