diff options
| author | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2010-04-27 00:46:52 +0400 |
|---|---|---|
| committer | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2010-04-27 00:46:52 +0400 |
| commit | e67c60094f79056f51b0b95f19bdf5c5a6e52a9d (patch) | |
| tree | cfd558dc8056adc6c7a9c2f6fd2976d9dc973bcc /mysql-test/r/join.result | |
| parent | 6595861f5802dad8997fcaa6466d0ca1130d4df7 (diff) | |
| parent | 6d43510a421cd450d8c43224f38a17b4a59ec556 (diff) | |
| download | mariadb-git-e67c60094f79056f51b0b95f19bdf5c5a6e52a9d.tar.gz | |
Null merge.
Diffstat (limited to 'mysql-test/r/join.result')
| -rw-r--r-- | mysql-test/r/join.result | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/r/join.result b/mysql-test/r/join.result index 940b3b4102e..c60c6bfb3c8 100644 --- a/mysql-test/r/join.result +++ b/mysql-test/r/join.result @@ -1146,6 +1146,16 @@ ROW(t1.b, 1111.11) <=> ROW('',''); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables DROP TABLE t1; +# +# Bug #50335: Assertion `!(order->used & map)' in eq_ref_table +# +CREATE TABLE t1 (a INT NOT NULL, b INT NOT NULL, PRIMARY KEY (a,b)); +INSERT INTO t1 VALUES (0,0), (1,1); +SELECT * FROM t1 STRAIGHT_JOIN t1 t2 ON t1.a=t2.a AND t1.a=t2.b ORDER BY t2.a, t1.a; +a b a b +0 0 0 0 +1 1 1 1 +DROP TABLE t1; End of 5.0 tests. CREATE TABLE t1 (f1 int); CREATE TABLE t2 (f1 int); @@ -1174,14 +1184,4 @@ NULL NULL 1 DROP TABLE t1, t2, mm1; -# -# Bug #50335: Assertion `!(order->used & map)' in eq_ref_table -# -CREATE TABLE t1 (a INT NOT NULL, b INT NOT NULL, PRIMARY KEY (a,b)); -INSERT INTO t1 VALUES (0,0), (1,1); -SELECT * FROM t1 STRAIGHT_JOIN t1 t2 ON t1.a=t2.a AND t1.a=t2.b ORDER BY t2.a, t1.a; -a b a b -0 0 0 0 -1 1 1 1 -DROP TABLE t1; End of 5.1 tests |