db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: drop column functionality
Date Sat, 19 Aug 2006 16:51:16 GMT
> But it looks like there is no ALTER TABLE DROP COLUMN ... functionality. 
> Is there an expectation for resolution?

Hi Tim,

Thanks for considering Derby; I think you will find it is very powerful.

You are correct that ALTER TABLE DROP COLUMN is not currently present.

However, as you've observed, there is an active issue for it and that
issue has a patch available.

Can you try building Derby with the patch attached to that JIRA issue,
and let us know if the feature appears to be working properly for you?

Getting some additional testing would definitely accelerate the process
of integrating this feature into the codeline.

There are two open problems regarding that patch that I am still studying:
  - DROP COLUMN may not work properly if there are GRANTs on that column
  - DROP COLUMN may not work properly if there are VIEWs on that column

Other than that, I believe that the feature is working properly, so it
would be wonderful to get some additional experience about how it works
"in real life".

If you need assistance building Derby with the patch, please ask on the
developers list (derby-dev@db.apache.org) and we'll be glad to help.



View raw message