diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2014-09-12 16:51:41 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2014-09-12 16:51:41 +0200 |
| commit | c799d65bafe16eeef9eeaddc90a94e2a7fab1724 (patch) | |
| tree | 711ef7f707616408000d82c29d2a2994783bc6ad /mysql-test/r/join_outer_jcl6.result | |
| parent | 32360bb7289a5758a6abe12a84e9fd0ecc3d6ce4 (diff) | |
| parent | 5023bb899dfaf78d85be2e6c08ec22cadcbcf82a (diff) | |
| download | mariadb-git-c799d65bafe16eeef9eeaddc90a94e2a7fab1724.tar.gz | |
5.3 merge
Diffstat (limited to 'mysql-test/r/join_outer_jcl6.result')
| -rw-r--r-- | mysql-test/r/join_outer_jcl6.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/join_outer_jcl6.result b/mysql-test/r/join_outer_jcl6.result index 88f2fd7c630..beea0daa1fa 100644 --- a/mysql-test/r/join_outer_jcl6.result +++ b/mysql-test/r/join_outer_jcl6.result @@ -696,9 +696,9 @@ insert into t2 values (1,3), (2,3); insert into t3 values (2,4), (3,4); select * from t1 left join t2 on b1 = a1 left join t3 on c1 = a1 and b1 is null; a1 a2 b1 b2 c1 c2 +3 2 NULL NULL 3 4 1 2 1 3 NULL NULL 2 2 2 3 NULL NULL -3 2 NULL NULL 3 4 explain select * from t1 left join t2 on b1 = a1 left join t3 on c1 = a1 and b1 is null; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 |