Bug #29796 Correlated subquery return zero rows when Group By included in the outer query
Submitted: 13 Jul 2007 20:39 Modified: 13 Aug 2007 21:49
Reporter: Nigel Brownlow Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.41 OS:Windows (XP Professional 5.1.2600)
Assigned to: CPU Architecture:Any
Tags: Aggregate Function, Correlated Subquery, GROUP BY

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[13 Jul 2007 22:45] Nigel Brownlow
Create Statements for Tables needed to debug error

Attachment: Creates.sql (application/octet-stream, text), 1.30 KiB.

[13 Jul 2007 22:45] Nigel Brownlow
Insert Statements for data needed to debug error

Attachment: Inserts.sql (application/octet-stream, text), 1.66 KiB.