db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian d'Heureuse (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-1289) Allow the VARCHAR function to convert numeric values
Date Sat, 11 Nov 2006 22:54:38 GMT
    [ 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
  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:
>            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


View raw message