Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 20322 invoked from network); 12 Mar 2007 19:06:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 12 Mar 2007 19:06:32 -0000 Received: (qmail 84891 invoked by uid 500); 12 Mar 2007 19:06:39 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 84858 invoked by uid 500); 12 Mar 2007 19:06:39 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 84834 invoked by uid 99); 12 Mar 2007 19:06:39 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Mar 2007 12:06:39 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Mar 2007 12:06:29 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 9869B714070 for ; Mon, 12 Mar 2007 12:06:09 -0700 (PDT) Message-ID: <17524628.1173726369621.JavaMail.jira@brutus> Date: Mon, 12 Mar 2007 12:06:09 -0700 (PDT) From: "Knut Anders Hatlen (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Closed: (DERBY-2445) Function VARCHAR truncates the results at 15 characters In-Reply-To: <11248682.1173685509603.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ 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.