Bug #2168 left outer join sub query error
Submitted: 18 Dec 2003 22:47 Modified: 19 Jan 2004 8:14
Reporter: Shuming Wang Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Websites: lists.mysql.com Severity:S3 (Non-critical)
Version: OS:Windows (win98/2000/ Red Hat Linx 9.1)
Assigned to: CPU Architecture:Any

[18 Dec 2003 22:47] Shuming Wang
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
[19 Dec 2003 8:14] MySQL Verification Team
I was not able to repeat a problem with 4.1.2.

Can you upload yuur table (gzipped) or it's dump (again gzipped) ??

Also let us know exact query that you ran as the one you have sent had to
be modified due to syntax error.

Thanks in advance.
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".