[jira] Commented: (DERBY-1289) Allow the VARCHAR function to convert numeric values

["Christian d'Heureuse (JIRA)" <ji...@apache.org>]

    [ 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