diff options
| author | monty@mashka.mysql.fi <> | 2003-04-26 20:43:28 +0300 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2003-04-26 20:43:28 +0300 |
| commit | bf6cfd2948f4cbab120a76aaf16d7ca0739cf2f4 (patch) | |
| tree | d337933bf02d06131497e3097c839528e9938a07 /mysql-test/r/join_outer.result | |
| parent | ba5b57c642fccfdbac0a4b82de919dbcc2bca058 (diff) | |
| download | mariadb-git-bf6cfd2948f4cbab120a76aaf16d7ca0739cf2f4.tar.gz | |
Fix for -fbranch-probabilites (bug 268)
Fix for LEFT/RIGHT/MID with multi-byte-character sets (bug 314)
Fix for new bison 1.875
max_insert_delayed_threads and delayed_insert_timeout now works as documented (bug 211)
Don't show port in SHOW PROCESSLIST for system threads
Fix problem with ORDER BY being discarded for some DISTINCT queries (bug 275)
Fixed bug with NATURAL LEFT JOIN, NATURAL RIGHT JOIN and RIGHT JOIN when
using many joined tables (Bug 212)
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 98f8882aa10..e64cc07e344 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -351,12 +351,7 @@ select t1.name, t2.name, t2.id,t3.id from t1 right join t2 on (t1.id = t2.owner) name name id id Antonio Paz El Gato 1 1 Antonio Paz Perrito 2 1 -NULL Happy 3 1 -NULL El Gato 1 2 -NULL Perrito 2 2 -NULL Happy 3 2 -NULL El Gato 1 3 -NULL Perrito 2 3 +NULL NULL NULL 2 Thimble Smith Happy 3 3 select t1.name, t2.name, t2.id, t2.owner, t3.id from t1 left join t2 on (t1.id = t2.owner) right join t1 as t3 on t3.id=t2.owner; name name id owner id |