[ 
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: 10.5.1.1
>            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 fields.

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

Reply via email to