Bug #5568 UNION truncates some results
Submitted: 14 Sep 2004 11:05 Modified: 14 Sep 2004 11:40
Reporter: Luca Accomazzi Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.20 OS:Bug found under Linux and OS X
Assigned to: CPU Architecture:Any

[14 Sep 2004 11:05] Luca Accomazzi
Description:
mysql> (select 'bug') union (select 'outstanding');
+-----+
| bug |
+-----+
| bug |
| out |
+-----+
2 rows in set (0.07 sec)

Of course the second row should read "outstanding".

How to repeat:
See above
[14 Sep 2004 11:40] Victoria Reznichenko
Hi,

Thank you for the report, but this is known limitation of the UNION.
Before version 4.1.1 only values from the first SELECT list are used to determine column length.