MySQL Bugs: #5568: UNION truncates some results

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

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.