MySQL Bugs: #5965: ELT truncates to the length of the shortest string

Bug #5965	ELT truncates to the length of the shortest string
Submitted:	7 Oct 2004 21:08	Modified:	7 Oct 2004 21:48
Reporter:	Cecil Westerhof	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	3.23.58	OS:	Linux (Linux 2.4.20)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
There is a bug in the ELT function. It selects a string not longer as the shortest 
string. 
 

How to repeat:
ELT(2, 'No', 'Yes ') gives "Ye" 
 
It can be solved by using  
 
ELT(2, 'No ', 'Yes ') 
 
but that is not very satisfactory.

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

This has been fixed in 4.0.18