|Subject||Re: [firebird-support] Odd problem - inconsistent result set|
> Is it possible that transaction(s) which created that missed rows (invoiceI had it in mind also. I need to check but i think very probably not.
> items) was not committed when transaction which generated packing list
> was started ?
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 packingThe indices weren't rebuild. If an index is broken can it regenerate
> list generation time and rebuilt later ?
automatically under some circunstance?