Issue Details (XML | Word | Printable)

Key: CORE-3590
Type: Task Task
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

show proper info in rdb$index_segments.rdb$statistics for GTT (from index root page)

Created: 30/Aug/11 02:42 PM   Updated: 30/Aug/11 03:18 PM
Component/s: None
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
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.



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 30/Aug/11 03:18 PM
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.