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/r/subselect_no_semijoin.result | |
| 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/r/subselect_no_semijoin.result')
| -rw-r--r-- | mysql-test/r/subselect_no_semijoin.result | 52 |
1 files changed, 26 insertions, 26 deletions
diff --git a/mysql-test/r/subselect_no_semijoin.result b/mysql-test/r/subselect_no_semijoin.result index 7efb5127d2b..3440ecbc6c1 100644 --- a/mysql-test/r/subselect_no_semijoin.result +++ b/mysql-test/r/subselect_no_semijoin.result @@ -6005,26 +6005,26 @@ 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); f1 f1_key -v j +s c +s d +s d +s d s j -v v +s m +s s +s t s v +s y v c -s c -v m -s m v d -s d v d -s d -v y -s y -v t -s t v d -s d +v j +v m v s -s s +v t +v v +v y DROP TABLE t1,t2; # # LP bug 919427: EXPLAIN for a query over a single-row table @@ -6353,26 +6353,26 @@ SELECT DISTINCT f1_key FROM t2 WHERE f1_key != table2.f1_key AND f1_key >= table1.f1 ); f1 f1_key -v j +s c +s d +s d +s d s j -v v +s m +s s +s t s v +s y v c -s c -v m -s m v d -s d v d -s d -v y -s y -v t -s t v d -s d +v j +v m v s -s s +v t +v v +v y explain SELECT table1.f1, table2.f1_key FROM t1 AS table1, t2 AS table2 WHERE EXISTS |