Issue Details (XML | Word | Printable)

Key: CORE-2307
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: prenosil
Votes: 0
Watchers: 0
Operations

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

Incomplete API information values

Created: 05/Feb/09 10:23 PM   Updated: 29/Jun/11 01:13 PM
Component/s: API / Client Library, Engine
Affects Version/s: 2.0.0, 1.5.4, 2.0.1, 2.0.2, 2.0.3, 1.5.5, 2.1.0, 2.0.4, 2.5 Alpha 1, 2.1.1, 2.0.5, 2.1.2
Fix Version/s: 2.5 Beta 1

Time Tracking:
Not Specified

Environment: WinXP
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
The API call isc_database_info() with isc_info_xxx_count requests
(isc_info_read_seq_count, isc_info_insert_count, isc_info_update_count etc.)
returns very limited result buffer. It contains informations about
approximately 50 tables, including system ones. (Or, the result is just
couple of hundreds bytes long, even if the result bufer is much longer).
The result also does not indicate in any way that many informations are missing
(i.e. no isc_info_truncated value).

How to reproduce - connect into database with lots of tables and execute this

EXECUTE BLOCK AS
DECLARE VARIABLE N VARCHAR(31);
DECLARE VARIABLE I INTEGER;
BEGIN
  FOR SELECT RDB$RELATION_NAME
    FROM RDB$RELATIONS
    WHERE RDB$RELATION_TYPE=0 AND RDB$SYSTEM_FLAG=0
    INTO :N
    DO
    BEGIN
      EXECUTE statement 'SELECT FIRST 1 1 FROM ' || :N INTO :I;
    END
END

and you will see that statistincs are not complete and many tables are missing
(Either look at Performance Analysis of IBExpert, or in FSQL use SET STATS ON ALL SYSTEM;)


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 29/Jun/11 01:13 PM
QA test added.