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
VALUES CAST(123 as VARCHAR(10))
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
