Title: Re: [Firebird-devel] ODP: ODP: ODP: Inserts and FKs
If you had understood the case, you would have noticed that the transaction in isql-1 doesn't matter. Either readcommited or snapshot will show the same result. That's why I didn't mind about running set transaction in my step-by-step ins
Inconsistent behavior regarding visibility of master record on detail inserts
-
Key: CORE-6138
URL: http://tracker.firebirdsql.org/browse/CORE-6138
Project: Firebird Core
You have right, there is a bug and the big one!
I suppose that index of Foreign Key is not validated by existence of value in
the record itself and its (the record version) transaction numer is not
compared to snapshot number.
Please report a bug to the tracker.
regards,
Karol Bieniaszewski
Fi
> On Sep 7, 2019, at 8:58 AM, Karol Bieniaszewski
> wrote:
>
> You have right, there is a bug and the big one!
> I suppose that index of Foreign Key is not validated by existence of value in
> the record itself and its (the record version) transaction numer is not
> compared to snapshot numbe