Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 34351 invoked from network); 4 Dec 2009 16:26:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 4 Dec 2009 16:26:44 -0000 Received: (qmail 37815 invoked by uid 500); 4 Dec 2009 16:26:44 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 37794 invoked by uid 500); 4 Dec 2009 16:26:44 -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 37786 invoked by uid 99); 4 Dec 2009 16:26:44 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 04 Dec 2009 16:26:44 +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; Fri, 04 Dec 2009 16:26:42 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 03576234C045 for ; Fri, 4 Dec 2009 08:26:21 -0800 (PST) Message-ID: <1945422428.1259943981008.JavaMail.jira@brutus> Date: Fri, 4 Dec 2009 16:26:21 +0000 (UTC) From: "Evan Leonard (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-4256) allow alter table to increase the maximum size of a blob and a clob. In-Reply-To: <522629521.1244048647465.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-4256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12785987#action_12785987 ] Evan Leonard commented on DERBY-4256: ------------------------------------- Any chance this could be merged to 10.5? I'd quite like to make use of this fix, but am not excited about having to wait for 10.6 next year. From this attached diffs, it looks like it is a small localized fix that could safely be applied to 10.5. > allow alter table to increase the maximum size of a blob and a clob. > -------------------------------------------------------------------- > > Key: DERBY-4256 > URL: https://issues.apache.org/jira/browse/DERBY-4256 > Project: Derby > Issue Type: Improvement > Components: SQL > Affects Versions: 10.5.1.1 > Reporter: Mike Matrigali > Assignee: Eranda Sooriyabandara > Priority: Minor > Fix For: 10.6.0.0 > > Attachments: A.txt, Clob.java, derby4256.diff, derby4256.diff, derby4256.diff, derby4256.diff > > > Allow new syntax that allows user to alter the maximum length of a blob and/or clob column: > ALTER TABLE binarydata ALTER COLUMN data SET DATA TYPE blob(128M) > The syntax should match up with the existing functionality to increase the size of varchar fields. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.