MySQL Bugs: #88025: cast() and convert() target data type limitations

Bug #88025	cast() and convert() target data type limitations
Submitted:	9 Oct 2017 8:24	Modified:	8 Dec 2021 14:08
Reporter:	Zoltán Szalai	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Data Types	Severity:	S4 (Feature request)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	cast, convert, varchar

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Cast should accept varchar as the target type.  There are other shortcomings as well.  See also Bug #16904 and Bug #34564. I place here a new feature request, since those above are triaged.

How to repeat:
SELECT CAST(123 AS varchar);

Suggested fix:
Include all supported data types in CAST/CONVERT.

Hello Zoltán Szalai,

Thank you for the feature request!

regards,
Umesh