Bug #616: Alter table add foreign key

Dirk Jacobs (dirk.jacobs@tuple.be) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Alter table add foreign key

Long Description
I tried to execute following SQL alter table PRICEGROUP add FOREIGN KEY  ("PARENT") REFERENCES "PRICEGROUP" ON DELETE
CASCADE

this gives an error ALTER TABLE: column "PARENT" referenced in foreign key constraint does not exist (7) while I'm sure
thatthe column exists and is Non null. I'm using version 7.2 on linux redhat 7.2
 


Sample Code


No file was uploaded with this report