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

Mamta A. Satoor commented on DERBY-4256:
----------------------------------------

Eranda, I quickly went through your patch and it looks good to me. Would it be 
possible to try to create smaller blob/clob columns, increase their size and 
then insert data which is bigger than the original size but smaller than the 
new size to see if we are able to store and retrieve bigger data. Once we know 
this works fine on a standalone case, we should add a junit test to put it into 
our regression suite for this change.

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