Martijn,

> >IMO you can run IB against the test suite for weeks and it
> wont make the
> >slightest difference. The test suite is flawed for many reasons. For
> >one, it only tests what it knows about. If there is no test to verify
> >the order of constraint/trigger firing then there is no way the suite
> >can 'fail'.
>
> But still, for example Craig Stunz is boosting about this being the
> major difference between the open source version of IB or Firebird
> and the certified version.

There is! Unfortunately for Craig, the difference favours Firebird!

> btw, this case _can_ be tested by simply creating a table and a
> check constraint and a trigger, and it can be added to the basic
> test.

I don't think Paul was trying to say that a test case couldn't be
created, just that the testing suite requires that a test be created, in
advance, to test for a condition, in order for the test suite to detect
the condition (a chicken and egg problem).


Sean