summaryrefslogtreecommitdiff
path: root/mysql-test/r/join_outer.result
diff options
context:
space:
mode:
authorSergey Petrunya <psergey@askmonty.org>2010-03-21 23:06:04 +0300
committerSergey Petrunya <psergey@askmonty.org>2010-03-21 23:06:04 +0300
commit3be133eb4deaaa7479179dd6813b85d080c8c5ca (patch)
tree81d56b5eb1d6f46d3ba43b691b186207b2fe6914 /mysql-test/r/join_outer.result
parent6777a11b2451f512321f057e43d80f88c1c6e116 (diff)
downloadmariadb-git-3be133eb4deaaa7479179dd6813b85d080c8c5ca.tar.gz
Make test result stable (had different result orderings, on some platforms, both
of which satisfied the ORDER BY clause).
Diffstat (limited to 'mysql-test/r/join_outer.result')
-rw-r--r--mysql-test/r/join_outer.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result
index 0efed3b6c3a..9dca5ace31f 100644
--- a/mysql-test/r/join_outer.result
+++ b/mysql-test/r/join_outer.result
@@ -416,10 +416,10 @@ n m o n m o
select t1.*, t2.* from t1 left join t2 on t1.n = t2.n and
t1.m = t2.m where t1.n = 1 order by t1.o;
n m o n m o
+1 2 11 1 2 3
1 2 7 1 2 3
1 2 9 1 2 3
1 3 9 NULL NULL NULL
-1 2 11 1 2 3
drop table t1,t2;
CREATE TABLE t1 (id1 INT NOT NULL PRIMARY KEY, dat1 CHAR(1), id2 INT);
INSERT INTO t1 VALUES (1,'a',1);