Subject | mon$record_inserts and rolled-back transactions |
---|---|
Author | Douglas Tosi |
Post date | 2008-08-21T16:39:11Z |
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
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