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

Select from mon$table_stats doesn`t work on SC and CS [CORE4668] #4979

Closed
firebird-automations opened this issue Jan 17, 2015 · 5 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

DDL:

SQL> create database 'c:\temp\tmp20150117a.fdb';
SQL> recreate table t(id int, s varchar(36)); commit;
SQL> insert into t select rand()*1000000, uuid_to_char(gen_uuid()) from rdb$types,rdb$types rows 100000;
SQL> commit;
SQL> select count(*) from t;

            COUNT

=====================
100000

SQL> exit;

On SuperServer:

C:\1INSTALL\FIREBIRD\FB30SNAP>isql localhost/3333:c:\temp\tmp20150117a.fdb
Database: localhost/3333:c:\temp\tmp20150117a.fdb
SQL> commit; select * from mon$table_stats;

MON$STAT_ID MON$STAT_GROUP MON$TABLE_NAME MON$RECORD_STAT_ID
============ ============== =============================== ==================
2 1 RDB$PAGES 3
2 1 RDB$DATABASE 4
2 1 RDB$INDICES 5
2 1 RDB$RELATIONS 6
2 1 RDB$SECURITY_CLASSES 7
2 1 RDB$TRIGGERS 8
11 3 RDB$RELATIONS 12

SQL> out nul; select * from t; out;
SQL> commit; select * from mon$table_stats;

MON$STAT_ID MON$STAT_GROUP MON$TABLE_NAME MON$RECORD_STAT_ID
============ ============== =============================== ==================
2 1 RDB$PAGES 3
2 1 RDB$DATABASE 4
2 1 RDB$FIELDS 5
2 1 RDB$INDICES 6
2 1 RDB$RELATION_FIELDS 7
2 1 RDB$RELATIONS 8
2 1 RDB$FORMATS 9
2 1 RDB$SECURITY_CLASSES 10
2 1 RDB$TRIGGERS 11
2 1 T 12 ------------------------------------- OK, table 'T' must be here

On SuperClassic and Classic:

C:\1INSTALL\FIREBIRD\FB30SNAP>isql localhost/3333:c:\temp\tmp20150117a.fdb
Database: localhost/3333:c:\temp\tmp20150117a.fdb
SQL> commit; select * from mon$table_stats;

MON$STAT_ID MON$STAT_GROUP MON$TABLE_NAME MON$RECORD_STAT_ID
============ ============== =============================== ==================
5 3 RDB$RELATIONS 6

SQL> out nul; select * from t; out;
SQL> commit; select * from mon$table_stats;
SQL> -- NO rows!

Commits: 8adfd0a FirebirdSQL/fbt-repository@8be19e8

====== Test Details ======

Confirmed wrong result on WI-T3.0.0.31374: no output from mon$table_stats.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 3.0 Beta 1 [ 10332 ]

Component: Engine [ 10000 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 2 [ 10586 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully

Test Details: Confirmed wrong result on WI-T3.0.0.31374: no output from mon$table_stats.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

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

2 participants