Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 75740 invoked from network); 10 Jun 2009 16:02:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Jun 2009 16:02:21 -0000 Received: (qmail 32190 invoked by uid 500); 10 Jun 2009 16:02:32 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 32131 invoked by uid 500); 10 Jun 2009 16:02:32 -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 32123 invoked by uid 99); 10 Jun 2009 16:02:32 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jun 2009 16:02:32 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jun 2009 16:02:29 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 682D1234C004 for ; Wed, 10 Jun 2009 09:02:07 -0700 (PDT) Message-ID: <1969138556.1244649727411.JavaMail.jira@brutus> Date: Wed, 10 Jun 2009 09:02:07 -0700 (PDT) From: "Kristian Waagan (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-4245) Sorting a table containing a CLOB fails after upgrade to 10.5 In-Reply-To: <689739462.1243184026337.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-4245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kristian Waagan updated DERBY-4245: ----------------------------------- Attachment: derby-4245-2a-sqlclob_fix.diff derby-4245-1b-test.diff It makes sense, as it makes the code cleaner. Is patch 1b along the lines you were thinking of? I also attached patch 2a, which fixes the problems in SQLClob. When applying it, the bug should no longer reproduce with a clean database. The bug will still occur with upgraded databases. Patch 2a passes the regression tests. Patches ready for review. > Sorting a table containing a CLOB fails after upgrade to 10.5 > ------------------------------------------------------------- > > Key: DERBY-4245 > URL: https://issues.apache.org/jira/browse/DERBY-4245 > Project: Derby > Issue Type: Bug > Components: Store > Affects Versions: 10.5.1.1 > Reporter: Knut Anders Hatlen > Assignee: Kristian Waagan > Fix For: 10.5.1.2 > > Attachments: derby-4245-0a-preview.diff, derby-4245-1a-test.diff, derby-4245-1b-test.diff, derby-4245-2a-sqlclob_fix.diff, MixedVersionClob.java > > > When sorting a table containing a CLOB column in a database that has been soft-upgraded from 10.4.2.0 to 10.5.1.1, the query fails with a NullPointerException. > Reported on derby-user: http://mail-archives.apache.org/mod_mbox/db-derby-user/200905.mbox/%3ckk5ivy.tcwvy@email.bg%3e -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.