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 08:00:14 GMT

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

Saurabh Vyas commented on DERBY-2445:
-------------------------------------

Hi Ephemeris,

Can you please provide more details about which version of derby you are using. Probably the
output of sysinfo command ($ java org.apache.derby.tools.sysinfo).
A simmilar problem was addressed in DERBY-1132 (https://issues.apache.org/jira/browse/DERBY-1132)

Hope this helps!!!

Saurabh

> 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