[DERBY-3920] Allow altering size limits for blob and clob columns

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.4.1.3
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Trejkaz
• Created: 23/Oct/08 02:21
• Updated: 25/May/10 13:17
• Resolved: 17/Aug/09 14:14

Description

I would like to increase the size limit of some CLOB columns (actually, I'd like to remove the limit.)

So I tried this:
ALTER TABLE t ALTER c SET DATA TYPE CLOB

But of course it's not supported.

I figure this can't be any harder than it was to do the same thing for VARCHAR, although I don't actually know.

Issue Links

• is duplicated by: DERBY-4256 allow alter table to increase the maximum size of a blob and a clob.