db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Saurabh Vyas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2445) Function VARCHAR truncates the results at 15 characters
Date Mon, 12 Mar 2007 09:18:09 GMT

    [ 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.


Mime
View raw message