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/row.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/row.test')
| -rw-r--r-- | mysql-test/t/row.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/row.test b/mysql-test/t/row.test index 1c1d1b00910..80c61c414bf 100644 --- a/mysql-test/t/row.test +++ b/mysql-test/t/row.test @@ -187,6 +187,7 @@ SELECT * FROM t1,t2 WHERE (t1.a,t1.b)=(t2.a,t2.b); EXPLAIN SELECT * FROM t1,t2 WHERE t1.a=t2.a AND t1.b=2; EXPLAIN SELECT * FROM t1,t2 WHERE (t1.a,t1.b)=(t2.a,2); +--sorted_result SELECT * FROM t1,t2 WHERE t1.a=1 and t1.b=t2.b; SELECT * FROM t1,t2 WHERE (t1.a,t1.b)=(t2.a,2); @@ -194,6 +195,7 @@ EXPLAIN EXTENDED SELECT * FROM t1,t2 WHERE (t1.a,t1.b)=(t2.a,t2.b+1); SELECT * FROM t1,t2 WHERE (t1.a,t1.b)=(t2.a,t2.b+1); EXPLAIN EXTENDED SELECT * FROM t1,t2 WHERE (t1.a-1,t1.b)=(t2.a-1,t2.b+1); +--sorted_result SELECT * FROM t1,t2 WHERE (t1.a-1,t1.b)=(t2.a-1,t2.b+1); EXPLAIN SELECT * FROM t2 WHERE a=3 AND b=2; |