[All]
Bug 8445: ALTER TABLE . . . DROP (column) fails when it should succeed
Abstract: 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;
