Lines Matching refs:left

13 # This file implements tests for left outer joins containing WHERE
14 # clauses that restrict the scope of the left term of the join.
35       select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
52       select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
58     select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
66     select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
71     select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
76     select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
81     select * from t1 left outer join t2 on t1.a=t2.x and t2.z>='ok'
87       select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
92       select * from t1 left outer join t2 on t1.a=t2.x and t2.z IN ('ok')