diff options
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 8160c5a2f3d..5c0616f9e54 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2559,3 +2559,14 @@ WHERE COUNT(*) 4 drop table t1,t2,t3; +create table t1 (f1 int); +insert into t1 values (1),(NULL); +create table t2 (f2 int, f3 int, f4 int); +create index idx1 on t2 (f4); +insert into t2 values (1,2,3),(2,4,6); +select A.f2 from t1 left join t2 A on A.f2 = f1 where A.f3=(select min(f3) +from t2 C where A.f4 = C.f4) or A.f3 IS NULL; +f2 +1 +NULL +drop table t1,t2; |