[MDEV-3508] LP:965950 - left join lead to crash (in case of converting it to inner join) Created: 2012-03-27  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Oleksandr Byelkin Assignee: Igor Babaev
Resolution: Not a Bug Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug965950.xml    

 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;

 Comments   
Comment by Oleksandr Byelkin [ 2012-03-27 ]

Re: left join lead to crash (in case of converting it to inner join)
repeatable on 5.2

Comment by Oleksandr Byelkin [ 2012-03-27 ]

Re: left join lead to crash (in case of converting it to inner join)
It looks the tree I tested it on was broken.

Comment by Rasmus Johansson (Inactive) [ 2012-03-27 ]

Launchpad bug id: 965950

Generated at Thu Feb 08 06:49:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.