Subject Re: [firebird-support] Odd problem - inconsistent result set
Author Fabiano Bonin
> Is it possible that transaction(s) which created that missed rows (invoice
> items) was not committed when transaction which generated packing list
> was started ?

I had it in mind also. I need to check but i think very probably not.
The invoices are generated some hours before the packing list, and the
missing items wasn't the last invoice items, so it would not be
expected to have some items in the middle of the invoice uncommited
while the last items are.

> Is it possible that index used to filter invoice items was broken at packing
> list generation time and rebuilt later ?

The indices weren't rebuild. If an index is broken can it regenerate
automatically under some circunstance?

Regards,

Fabiano