Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

show proper info in rdb$index_segments.rdb$statistics for GTT (from index root page) [CORE3590] #3944

Open
firebird-automations opened this issue Aug 30, 2011 · 1 comment

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Currently the field rdb$index_segments.rdb$statistics for any GTT contains the value that is result of LATEST issued set statistics command.
If this command was issued from ANOTHER connect we can see wrong values for OUR records of GTT.
The worst thing is that execution plan in OUR connect could not be explained since some moment when old ("good") values were overwritten by someone.

So it is better to show such values as result of quering of index root page rather than rdb$-table.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

I'm not sure I like the idea. System tables are persistent and their access rules are straightforward. Offering some kind of "virtual" fields that would show different values for different connections/transactions does not fit the concept of the RDB$ tables, IMHO. I'd rather think about some other solution.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant