diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-02-05 13:00:12 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-02-13 18:12:05 +0100 |
| commit | 01dd355635d00f80d6960f319591bb568f4cf628 (patch) | |
| tree | 74e19a15820132934ff52a00295d1863a596ab43 /mysql-test/t/subselect.test | |
| parent | cff144a8ea47be2db8aace52cc282f4d2e0d7aaa (diff) | |
| download | mariadb-git-01dd355635d00f80d6960f319591bb568f4cf628.tar.gz | |
cleanup: make a couple of tests more robust
with --sorted_result
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 44a400dca20..f2e0adf9d53 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -5031,6 +5031,7 @@ EXPLAIN SELECT table1.f1, table2.f1_key FROM t1 AS table1, t2 AS table2 WHERE EXISTS (SELECT DISTINCT f1_key FROM t2 WHERE f1_key != table2.f1_key AND f1_key >= table1.f1); +--sorted_result SELECT table1.f1, table2.f1_key FROM t1 AS table1, t2 AS table2 WHERE EXISTS (SELECT DISTINCT f1_key FROM t2 WHERE f1_key != table2.f1_key AND f1_key >= table1.f1); @@ -5330,6 +5331,7 @@ SELECT DISTINCT f1_key FROM t2 WHERE f1_key != table2.f1_key AND f1_key >= table1.f1 ); +--sorted_result eval $query; eval explain $query; |