You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2007/03/12 20:06:09 UTC
[jira] Closed: (DERBY-2445) Function VARCHAR truncates the results
at 15 characters
[ https://issues.apache.org/jira/browse/DERBY-2445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen closed DERBY-2445.
-------------------------------------
Resolution: Duplicate
Closing the issue as a duplicate of DERBY-1132.
> Function VARCHAR truncates the results at 15 characters
> -------------------------------------------------------
>
> Key: DERBY-2445
> URL: https://issues.apache.org/jira/browse/DERBY-2445
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.1.2.1, 10.2.2.0
> Environment: Windows XP.
> Reporter: Ephemeris Lappis
>
> The VARCHAR function truncates its argument, or result, at 15 characters.
> For example, with the statement :
> UPDATE PERSON SET LAST_NAME = VARCHAR(PERSON.LAST_NAME);
> An original column value with '123456789-123456789-' is truncated and the result is '123456789-12345'.
> NB : Such a statement seems a bit stupid, but i've detected the problem using Top-Link that uses the VARCHAR function to translate the JPA CONCAT function. And as I can't change what Top Link does...
> Thanks for your help.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.