community.borland.com

Article #25117: Bug 8445: ALTER TABLE . . . DROP (column) fails when it should succeed

Problem:
This is a problem with the implementation of views.



Solution:
- Create a database using the script below.
- Issue one of the two commands below:

    ALTER TABLE ULDS DROP FLIGHT_NO;
    ALTER TABLE ULDS DROP FLIGHT_ID;


A -607 error will be generated with the text:

unsuccessful metadata update
-cannot delete
-COLUMN FLIGHT_NO
-there are 1 dependencies

- Eliminate either view and the two ALTER TABLE commands will execute fine.

Note:  This bug is fixed in version v5.0

--------------------------------------------------
/* Extract Database d:temp15511ib_orig1.gdb */
CREATE DATABASE "ib_orig1.gdb" PAGE_SIZE 4096 
USER "SYSDBA" PASSWORD "masterkey"
;


/* Table: FLIGHT, Owner: SYSDBA */
CREATE TABLE FLIGHT (FLIGHT_ID INTEGER NOT NULL,
        FLIGHT_NO CHAR(8) NOT NULL);

/* Table: ULDS, Owner: SYSDBA */
CREATE TABLE ULDS (ULD_NO CHAR(10) NOT NULL,
        FLIGHT_ID INTEGER NOT NULL,
        FLIGHT_NO CHAR(8));



/* View: FLIGHT_V1, Owner: SYSDBA */
CREATE VIEW FLIGHT_V1 (FLIGHT_ID, FLIGHT_NO) AS

select flight.flight_id, flight.flight_no
from flight;

/* View: ULDS_V1, Owner: SYSDBA */
CREATE VIEW ULDS_V1 (ULD_NO) AS

select ulds.uld_no
from ulds;

Last Modified: 27-SEP-00