Subject mon$record_inserts and rolled-back transactions
Author Douglas Tosi
Hello!

I just noticed the following behavior:

Connection A inserts 1 record e does not commit.
Connection B "selects mon$record_inserts from mon$record_stats where
mon$stat_group = 1". The result is 1.
Should B see that A inserted before A commits?

Now A rolls back.
Again B "selects mon$record_inserts from mon$record_stats where
mon$stat_group = 1". The result is still 1.
Shouldn't the result be zero?

Is this expected behavior?

thanks,
[]s
--
Douglas Tosi
www.sinatica.com