[
https://issues.apache.org/jira/browse/DERBY-2445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12480021
]
Saurabh Vyas commented on DERBY-2445:
-------------------------------------
Hi Ephemeris,
Well Derby-1132 which addresses truncation problem is fixed in the development
trunk. So either you have to wait for the next release (10.3) of Derby, or if
possible try building the sources from development trunk
(http://db.apache.org/derby/dev/derby_source.html) and try out your example on
this.
> 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.
