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-issue-importer opened this issue Jan 17, 2015 · 5 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 17, 2015

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 17, 2015

Modified by: @dyemanov

Version: 3.0 Beta 1 [ 10332 ]

Component: Engine [ 10000 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 17, 2015

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 2 [ 10586 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 30, 2015

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 1, 2015

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