[ http://issues.apache.org/jira/browse/DERBY-1289?page=comments#action_12449045 ] Christian d'Heureuse commented on DERBY-1289: ---------------------------------------------
A comment in org.apache.derby.impl.sql.compile.BaseTypeCompiler.numberConvertible() reads: // Numbers can only be converted to other numbers, // and CHAR, (not VARCHARS or LONGVARCHAR). // Only with the CHAR() or VARCHAR()function can they be converted. The last sentence is not correct, because the VARCHAR function currently does not allow numeric values: VALUES VARCHAR(123); produces: Cannot convert types 'INTEGER' to 'VARCHAR'. > Allow the VARCHAR function to convert numeric values > ---------------------------------------------------- > > Key: DERBY-1289 > URL: http://issues.apache.org/jira/browse/DERBY-1289 > Project: Derby > Issue Type: Improvement > Components: SQL > Affects Versions: 10.1.3.1 > Reporter: Thomas Dudziak > Priority: Minor > > It would be good if the VARCHAR function > (http://db.apache.org/derby/docs/dev/ref/rrefbuiltvarchar.html) could convert > integer and floating point values to strings just as the CHAR function > (http://db.apache.org/derby/docs/dev/ref/rrefbuiltchar.html) can do (though > without the size limit). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
