I did warn that this blog, might be used to remind myself of things: and this is one.
Inconsistent analysis is a problem with databases when an aggregate function is used on data that is being updated by another transaction eg
=SUM(accounts(4 .. 7))
account(1) = account(4) = account(4) + 10
By the final line is out of date (as account 4 has been updated but the SUM total has not).