db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4256) allow alter table to increase the maximum size of a blob and a clob.
Date Sat, 08 Aug 2009 15:49:14 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740903#action_12740903

Bryan Pendleton commented on DERBY-4256:

Hi Eranda,

This code seems like a good approach.

Clob.java reproduces the bug for me, and I also confirmed that if I apply your change to ModifyColumnNode.java,
Clob.java then works correctly (it can insert the 20K clob into the column which has been
altered from 10K).

This is good progress, thanks for working on the test program.

I think that we could avoid the need for a separate text file by constructing a string in
memory , 
and then constructing an input stream from the string by using ByteArrayInputStream and String.getBytes.

That might make the test program easier to integrate into one of our existing classes

For example, here's a simple method to construct a string in memory of an arbitrary length:

    private static  String  makeString( int count )
        char[]  raw = new char[ count ];
        Arrays.fill( raw, 'a' );
        return new String( raw );

> 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:
>            Reporter: Mike Matrigali
>            Assignee: Eranda Sooriyabandara
>            Priority: Minor
>         Attachments: A.txt, Clob.java, 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

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message