diff options
| author | unknown <evgen@moonbone.local> | 2005-12-13 23:26:35 +0300 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-12-13 23:26:35 +0300 |
| commit | 27970ee72e939f92bd32c057d9f580f50ca527e4 (patch) | |
| tree | da3b1604e4764fed522798e3e16b05b5ec842a67 /mysql-test/r | |
| parent | 11b6afd3b3c7460ef5b9d058aa630e77a5140346 (diff) | |
| parent | cb06e0c1250074337293289e4914f01911e68ec5 (diff) | |
| download | mariadb-git-27970ee72e939f92bd32c057d9f580f50ca527e4.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0
into moonbone.local:/work/15268-bug-5.0-mysql
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/select.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 598ea2b10d1..e2c4609d902 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -3337,3 +3337,11 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE t3 const PRIMARY PRIMARY 8 const,const 1 DROP TABLE t1,t2,t3; +create table t1(f1 char, f2 char not null); +insert into t1 values(null,'a'); +create table t2 (f2 char not null); +insert into t2 values('b'); +select * from t1 left join t2 on f1=t2.f2 where t1.f2='a'; +f1 f2 f2 +NULL a NULL +drop table t1,t2; |