Bug #638 UNION erronously returns "table full" error message
Submitted: 11 Jun 2003 11:34 Modified: 3 Jul 2003 7:18
Reporter: SINISA MILIVOJEVIC Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0 and higher OS:Any (all)
Assigned to: CPU Architecture:Any

[11 Jun 2003 11:34] SINISA MILIVOJEVIC
Description:
Due to error in table conversion function call, dupplicated values caused
error to be returned insetad of ignoring those, when UNION ALL is not used.

How to repeat:

(SELECT SQL_CALC_FOUND_ROWS id,orgukr,address,area,phone,fax,email,name,birthdate,regdate,form,region,members,grants,privatedonations,membership,commercial,government,other,mission1,mission2,mission3,occupation1,occupation2,occupation3,mainoccupation,original_id,lang FROM DB_NGO WHERE mission1='') 

UNION 

(SELECT id,orgukr,address,area,phone,fax,email,name,birthdate,regdate,form,region,members,grants,privatedonations,membership,commercial,government,other,mission1,mission2,mission3,occupation1,occupation2,occupation3,mainoccupation,original_id,lang FROM DB_NGO WHERE mission2='') 

UNION 

(SELECT id,orgukr,address,area,phone,fax,email,name,birthdate,regdate,form,region,members,grants,privatedonations,membership,commercial,government,other,mission1,mission2,mission3,occupation1,occupation2,occupation3,mainoccupation,original_id,lang FROM DB_NGO WHERE mission3='')  

ORDER BY orgukr LIMIT 0, 500
[11 Jun 2003 11:34] MySQL Verification Team
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html
[3 Jul 2003 7:18] Michael Widenius
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html

Will be fixed in 4.0.14