Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Not a Bug
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
This test suite crashes:
create table t1 (a int, b int);
insert into t1 values (1,1),(2,2);
create table t2 (a int, b int);
insert into t2 values (1,1),(2,2);
select t1.b, t2.b from t1 left join t2 on (t2.a=t1.a) where t2.a > 5;
drop table t1, t2;
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: left join lead to crash (in case of converting it to inner join)
It looks the tree I tested it on was broken.
Launchpad bug id: 965950
Re: left join lead to crash (in case of converting it to inner join)
repeatable on 5.2