| Subject | Re: Firebird ignores primary Key definition |
|---|---|
| Author | Alexander V.Nevsky |
| Post date | 2003-10-09T16:35:57Z |
--- In firebird-support@yahoogroups.com, "Max Wolfring"
<mwolfring@y...> wrote:
Max, this can occure as a result of general database corruption
because of power failure etc - broken index on which constraint is
based. I can say too there is at least 2 bugs in all IB versions
including 7 and FB1 which can break integrity using normal SQL
statements - one breaks PK/Unique, another FK. Both are fixed in
FB1.5. Both show themselves in very seldon used constructions. Can't
you trace how this duplicates appeared in your database? Reports on so
critical bugs are highly welcome.
Best regards,
Alexander.
<mwolfring@y...> wrote:
> We are using Firebird 1.0.0.3 SS i386 Linux, on RedHat 8.0, and wehava some
> tables with primary key definition, unfortunately firebird allow tworows
> with same value on column defined as primary key, same indexescreated as
> UNIQUE" allow duplicate values too, and we really don´t know whatshappen.
Max, this can occure as a result of general database corruption
because of power failure etc - broken index on which constraint is
based. I can say too there is at least 2 bugs in all IB versions
including 7 and FB1 which can break integrity using normal SQL
statements - one breaks PK/Unique, another FK. Both are fixed in
FB1.5. Both show themselves in very seldon used constructions. Can't
you trace how this duplicates appeared in your database? Reports on so
critical bugs are highly welcome.
Best regards,
Alexander.