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] Created: (DERBY-2072) Implement CAST from INTEGER (and other numeric types) to VARCHAR
Date Sat, 11 Nov 2006 23:24:37 GMT
Implement CAST from INTEGER (and other numeric types) to VARCHAR

                 Key: DERBY-2072
                 URL: http://issues.apache.org/jira/browse/DERBY-2072
             Project: Derby
          Issue Type: Improvement
          Components: SQL
            Reporter: Christian d'Heureuse

While CASTs from DATE/TIME to VARCHAR and from INTEGER to CHAR are allowed, the conversion
from INTEGER to VARCHAR is not supported.

The statement
produces the error
  Cannot convert types 'INTEGER' to 'VARCHAR'.

The function org.apache.derby.impl.sql.compile.BaseTypeCompiler.numberConvertible() returns
false for a conversion from INTEGER to VARCHAR. This is documented within a comment in the
source code, but it's not documented why.this is so.

(Another documented rule in numberConvertible() is that floating point types can only be converted
to CHAR by the CHAR() function and not with a CAST. There is also no indication of why this
is so.)

See also DERBY-1289, DERBY-1306 and DERBY-1804.

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