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] Updated: (DERBY-4256) allow alter table to increase the maximum size of a blob and a clob.
Date Fri, 04 Dec 2009 17:40:20 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Bryan Pendleton updated DERBY-4256:
-----------------------------------

    Attachment: ten_5_codeOnly.diff

Hi Evan,

I think that the code changes are straightforward, and should apply to 10.5 without trouble.

The test changes are trickier, because the relevant test (AlterTableTest.java) doesn't exist
in 10.5.

Attached is 10_5_codeOnly.diff, which is a patch that you should be able to
apply to the 10.5 branch in your environment. I created this patch by running

   svn merge -r 802984:802985 https://svn.apache.org/repos/asf/db/derby/code/trunk/

and then reverting modifyColumn.out. (I didn't need to revert modifyColumn.out, but since
the test portion of the patch was mostly in AlterTableTest, I thought it would be
clearer if this diff *only* contained code changes, not any partial test changes)

Depending on what your needs are, hopefully the attached patch is useful to
you (e.g., if you want to build your own modified version of 10.5 and use it
to alter the column definitions in your database).


> 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
>             Fix For: 10.6.0.0
>
>         Attachments: A.txt, Clob.java, derby4256.diff, derby4256.diff, derby4256.diff,
derby4256.diff, ten_5_codeOnly.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