db-derby-dev mailing list archives

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

    [ https://issues.apache.org/jira/browse/DERBY-2445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12480031
] 

John H. Embretsen commented on DERBY-2445:
------------------------------------------

Expanding on what Suarabh suggested in the previous comment: If you don't want to build Derby
yourself for testing a fix, there are Derby jars based on the development trunk available
from http://dbtg.thresher.com/derby/bits/trunk/. Mind the warnings that those jars should
only be used for testing, though.

> 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