diff options
| author | Michael Widenius <monty@askmonty.org> | 2012-03-26 15:05:50 +0300 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2012-03-26 15:05:50 +0300 |
| commit | 4e96c579aef84d3b417045403425606ad9f061fd (patch) | |
| tree | c9adba5968411a2f684c26bb137920b85c19bea4 /mysql-test/t/subselect_sj2.test | |
| parent | 9ef537ac61d222f18af78c6cda9100f924c3ca2f (diff) | |
| download | mariadb-git-4e96c579aef84d3b417045403425606ad9f061fd.tar.gz | |
Sorted some test results that can be different on different machines
mysql-test/t/subselect_sj2.test:
Added --sorted_result
Diffstat (limited to 'mysql-test/t/subselect_sj2.test')
| -rw-r--r-- | mysql-test/t/subselect_sj2.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj2.test b/mysql-test/t/subselect_sj2.test index 3dd75cc1819..acd0a1efce3 100644 --- a/mysql-test/t/subselect_sj2.test +++ b/mysql-test/t/subselect_sj2.test @@ -1145,6 +1145,7 @@ INSERT INTO t1 VALUES CREATE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t1; --echo # This query returned 6 rows instead of 19 +--sorted_result SELECT * FROM v1 WHERE ( a, a ) IN ( SELECT alias2.b, alias2.a @@ -1164,6 +1165,7 @@ SELECT * FROM t2 alias2.b = alias1.a AND (alias1.b >= alias1.a OR alias2.b = 'z')); +--sorted_result SELECT * FROM t2 WHERE (a, a) IN (SELECT alias2.b, alias2.a FROM t1 AS alias1, t1 AS alias2 WHERE |