db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4256) allow alter table to increase the maximum size of a blob and a clob.
Date Wed, 29 Jul 2009 16:48:14 GMT

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


Mime
View raw message