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] Commented: (DERBY-4256) allow alter table to increase the maximum size of a blob and a clob.
Date Wed, 03 Jun 2009 20:34:07 GMT

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

Bryan Pendleton commented on DERBY-4256:
----------------------------------------

I'm cautiously optimistic that no additional changes will be needed. I'm eager to see what
results you find by simply modifying ModifyColumnNode.java.

The relevant portion of the grammar is around line 12740 in the columnAlterClause()
method of impl/sql/compile/sqlgrammar.jj

The relevant execution code is the modifyColumnType() method in
o.a.d.impl.sql.execute.AlterTableConstantAction

I took a quick peek at both places and it *seemed* like they should not require changes
for the extension to blob/clob. But it was a very quick peek...


> 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: New Feature
>    Affects Versions: 10.5.1.1
>            Reporter: Mike Matrigali
>            Assignee: Eranda Sooriyabandara
>            Priority: Minor
>
> 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