db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: renaming a referenced table
Date Tue, 29 Jul 2014 21:53:31 GMT
Hi Rick,

I looked through the original functional spec and see a mention of this
limitation but the reason is not explained. I unfortunately do not have old
emails anymore where they may have been discussions about it. Talked to
Mike on this briefly and his guess was that may be at that time in
Cloudscape's life cycle, we were more focused on getting easy functionality
out quick or may be there were catalogs referencing things by name rather
than uuid and thus making the complete implementation harder.

So, not really sure why this restriction was put in place.


On Tue, Jul 29, 2014 at 8:06 AM, Rick Hillegas <rick.hillegas@oracle.com>

> I am working on a patch (DERBY-6672) which lifts the following limitation
> in Derby: you can't RENAME a table referenced by a foreign key. The
> limitation seems to go back at least as far as Cloudscape 5.1 but not as
> far back as Cloudscape 3.5 (which doesn't have a RENAME TABLE command). I
> don't have access to the code archaeology for this limitation. Could
> someone with access to the code archaeology help me understand the
> motivation for this limitation? I don't want to remove this limitation if
> it is going to cause some known edge-case to fail.
> Thanks,
> -Rick

View raw message