Subject Re: [firebird-support] mon$statement_id is not consistent between snapshots?
Author Douglas Tosi
Thanks Sean, Dmitry.

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.

I would like to track the progress of time consuming statements.

So I started polling mon$statements and realized that the id changed.
Not only that, the same id is also reused for other statements.

The id is directly tied to the statement handle, then?

Douglas Tosi