Incomplete API information values [CORE2307]

[firebird-automations]

Submitted by: prenosil (prenosil)

Is related to QA385

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;)

Commits: f68301b

[firebird-automations]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-automations]

Modified by: @dyemanov

Version: 2.0.5 [ 10222 ]

Version: 2.0.4 [ 10211 ]

Version: 2.1.0 [ 10041 ]

Version: 1.5.5 [ 10220 ]

Version: 2.0.3 [ 10200 ]

Version: 2.0.2 [ 10130 ]

Version: 2.0.1 [ 10090 ]

Version: 1.5.4 [ 10100 ]

Version: 2.0.0 [ 10091 ]

Version: 2.1.2 [ 10270 ]

[firebird-automations]

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA385 [ QA385 ]

[firebird-automations]

Commented by: @pcisar

QA test added.

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully