Issue Details (XML | Word | Printable)

Key: CORE-4668
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

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

Select from mon$table_stats doesn`t work on SC and CS

Created: 17/Jan/15 10:58 AM   Updated: 01/Jun/15 05:54 PM
Component/s: Engine
Affects Version/s: 3.0 Beta 1
Fix Version/s: 3.0 Beta 2

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


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


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.