We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Submitted by: @pavel-zotov
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;
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
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.
The text was updated successfully, but these errors were encountered:
assignee: Dmitry Yemanov [ dimitr ]
Sorry, something went wrong.
Version: 3.0 Beta 1 [ 10332 ]
Component: Engine [ 10000 ]
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
Fix Version: 3.0 Beta 2 [ 10586 ]
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.
status: Resolved [ 5 ] => Closed [ 6 ]
dyemanov
No branches or pull requests
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;
=====================
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.
The text was updated successfully, but these errors were encountered: