[Firebird-devel] [ firebird-Bugs-525906 ] Faulty 0..many relationships

[<no...@so...>]

Bugs item #525906, was opened at 2002-03-05 11:21
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=525906&group_id=9028

Category: Core Engine
Group: Initial Bug
Status: Open
Resolution: None
Priority: 5
Submitted By: Peter Morris (cubud)
Assigned to: Nobody/Anonymous (nobody)
Summary: Faulty 0..many relationships

Initial Comment:
CREATE TABLE "AIRCRAFT"
(
  "OID"	INTEGER NOT NULL,
  "REGISTRATION"	VARCHAR(8) NOT NULL,
CONSTRAINT "PK_AIRCRAFT" PRIMARY KEY ("OID")
);

CREATE TABLE "CHILDTABLE"
(
  "OID"	INTEGER NOT NULL,
  "AIRCRAFTID"	INTEGER,
CONSTRAINT "PK_CHILDTABLE" PRIMARY KEY ("OID")
);
ALTER TABLE "CHILDTABLE" ADD 
CONSTRAINT "FK_CTAIRCRAFTID" FOREIGN KEY ("OID") 
REFERENCES AIRCRAFT ("OID");

the following commands do not work
INSERT INTO "CHILDTABLE" VALUES (1, NULL);
INSERT INTO "CHILDTABLE" (OID) VALUES (2);

FB complains that NULL does not exist on AIRCRAFT.
Once records have been entered in AIRCRAFT it allows 
the insert statements.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=525906&group_id=9028