MySQL Bugs: #1531: convert function is not working properly

Bug #1531	convert function is not working properly
Submitted:	11 Oct 2003 5:27	Modified:	11 Oct 2003 9:23
Reporter:	Manish Runwal	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	3.23.57	OS:	Windows (window98)
Assigned to:		CPU Architecture:	Any

Description:
I created one "table1" table contain one "col1" column as varchar(20)
but having data as int.
when I m use following query its not working.

select convert(Column_name,unsigned) from table_Name;

err is as follows:

ERROR 1064: You have an error in your SQL syntax near '(col1,unsigned) from tabl
e1' at line 1

From
Manish Runwal
m_runwal@sancharnet.in

How to repeat:
even when I use cast function its not working.
I think there is not syntax error in tht.

Suggested fix:
Can't say !

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

according to the manual:

`CAST()' and `CONVERT()' are available as of MySQL 4.0.2.  The `CHAR'
conversion type is available as of 4.0.6.  The `USING' form of
`CONVERT()' is available as of 4.1.0.