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

Reply via email to