db-derby-dev mailing list archives

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