Hi,

Thanks a lot for your code.

> TEST.BAT is the one that fails. Run it first. TEST.BAT will always
> fail, no matter how many times you run it.
>
> TEST2.BAT is the one that works. After running TEST2, the constraint
> will have been added, and the database will be useless for any
> further testing. Restore it from the extra copy provided.
>
> I hope somebody can find the pattern.

I have run your code with logging in our driver switched on. I see
that your test.bat has two connections open, one executing the
statement and another doing nothing. However, test2.bat has only one
connection open. However I managed to make your test.bat example close
one connection before it opens another. And I did this by using most
recent version of our driver from the CVS. So, seems to be something
related to David's fix with connections.

I will continue tomorrow. I plan to run it under debugger and see what
DPB and TPB are set for each connection to check if the conflict
occurs because isc_tpb_consistency is used.

Anyway, it is clear that issue will be gone in RC2 (or if you just
take current version from CVS).

Best regards,
Roman Rokytskyy