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:
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
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] MySQL Verification Team

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.