MySQL Bugs: #2169: left outer join sub query error

Bug #2169	left outer join sub query error
Submitted:	18 Dec 2003 22:56	Modified:	19 Dec 2003 4:09
Reporter:	Shuming Wang	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:		OS:	Windows (win98/2000/ Red Hat Linx 9.1)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Hi,
 Mysql 4.1.1 cause left outer join a sub query error:
 select  goods2.itemid itemid,ifnull(a1.qty,0) qty 
 from goods2
 left outer join (select itemid,qty from pikou where pikou.date>'2003-12-12') a  on a.itemid=goods2.itemid
  
 The server always hang up, or app shows 'lost connection', while 4.1.0 runs well.
Regards
Shuming Wang

How to repeat:
select  goods2.itemid itemid,ifnull(a1.qty,0) qty 
 from goods2
 left outer join (select itemid,qty from pikou where pikou.date>'2003-12-12') a  on a.itemid=goods2.itemid

Duplicate of bug #2168.