[
https://issues.apache.org/jira/browse/DERBY-4256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eranda Sooriyabandara updated DERBY-4256:
-----------------------------------------
Attachment: derby4256.diff
Hi Bryan,
I created updated the AlterTableTest according to the new issue and add the
method testJira4256().
I think this will be fine as a test.(It takes my full day).What you think
about the test?
And the exception give as "Only columns of type VARCHAR may have their
length altered".So we must add CLOB and BLOB as data types that can alter
its length.
Thanks
Eranda
> 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: A.txt, Clob.java, derby4256.diff, 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.
