SQL> show version;
ISQL Version: WI-T6.0.0.2092 Firebird 6.0 6417667
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T6.0.0.2092 Firebird 6.0 6417667"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T6.0.0.2092 Firebird 6.0 6417667/tcp (DESKTOP-NO2H8I1)/P20:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T6.0.0.2092 Firebird 6.0 6417667/tcp (DESKTOP-NO2H8I1)/P20:C"
on disk structure version 14.0
set per_tab on;
set term !;
execute block
returns (
id bigint
)
as
declare temporary table X_T (
id bigint
);
begin
insert into x_t (id)
values (1);
-- select count(*) from rdb$database into id;
for
select id
from x_t
into id
do
suspend;
end! ID
=====================
1
Per table statistics:
--------------------------------+---------+---------+---------+---------+---------+---------+---------+---------+
Table name | Natural | Index | Insert | Update | Delete | Backout | Purge | Expunge |
--------------------------------+---------+---------+---------+---------+---------+---------+---------+---------+
63488 | | | | | | | | | 1 1
--------------------------------+---------+---------+---------+---------+---------+---------+---------+---------+
The counters themselves are displayed, but not where they should be. However, if you add a regular table to EB, the display becomes correct.
execute block
returns (
id bigint
)
as
declare temporary table X_T (
id bigint
);
begin
insert into x_t (id)
values (1);
select count(*) from rdb$database into id;
for
select id
from x_t
into id
do
suspend;
end! ID
=====================
1
Per table statistics:
--------------------------------+---------+---------+---------+---------+---------+---------+---------+---------+
Table name | Natural | Index | Insert | Update | Delete | Backout | Purge | Expunge |
--------------------------------+---------+---------+---------+---------+---------+---------+---------+---------+
SYSTEM.RDB$DATABASE | 1| | | | | | | |
63488 | 1| | 1| | | | | |
--------------------------------+---------+---------+---------+---------+---------+---------+---------+---------+
The counters themselves are displayed, but not where they should be. However, if you add a regular table to EB, the display becomes correct.