Subject Re: [firebird-support] mon$statement_id is not consistent between snapshots?
Author Douglas Tosi
On Sat, Jun 14, 2008 at 5:13 PM, Douglas Tosi <douglasht@...> wrote:
> On Sat, Jun 14, 2008 at 3:18 PM, Dmitry Yemanov
> <dimitr@...> wrote:
>> Douglas Tosi wrote:
>> > Playing with the monitoring tables I just noticed that the same statement
>> > can have different ids on different snapshots. Why is that?
>> This is by design. While perhaps it could be possible to make those ID
>> globally unique, it would be interesting to know why would you need that.
> So I started polling mon$statements and realized that the id changed.
> Not only that, the same id is also reused for other statements.

btw, does the same behavior apply to transactions and attachments?

Douglas