create table EMP(Eid int primary key)

insert into EMP values(11e3)

--self referencing

alter table EMP 
add constraint fk_EMP_Eid 
foreign key (Eid) references EMP(Eid)

--now insert

insert into EMP values(12e2)

But, this insert should fail, because there is no previous value of Eid=1200 in the EMP table, so when the foreign key will reference this column , then it would not find the value, hence should fail the insert .

but why does it succeeds?

Edit
Report