Gstat output of tables does not include schema name

[mrotteveel]

The gstat output of tables does not include schema name.

For example:

create database 'schemaexp.fdb' user sysdba;
create schema SCHEMA1;
create schema SCHEMA2;
create table SCHEMA1.TABLE1 (id integer);
create table SCHEMA1.TABLE2 (id integer);
create table SCHEMA2.TABLE2 (id integer);
exit;

Followed by

gstat -user sysdba -a schemaexp.fdb

Outputs:

Gstat execution time Mon Oct 13 12:39:20 2025

Database header page information:
        Flags                   0
        Generation              10
        System Change Number    0
        Page size               8192
        ODS version             14.0
        Oldest transaction      1
        Oldest active           2
        Oldest snapshot         2
        Next transaction        7
        Next attachment ID      3
        Implementation          HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
        Shadow count            0
        Page buffers            0
        Database dialect        3
        Database GUID:  {E0337DFD-A78A-4337-B39A-0973992CA582}
        Creation date           Oct 13, 2025 10:39:09
        Attributes              force write

    Variable header data:
        *END*

Analyzing database pages ...
TABLE1 (128)
    Primary pointer page: 282, Index root page: 283
    Pointer pages: 1, data page slots: 0
    Data pages: 0, average fill: 0%
    Primary pages: 0, secondary pages: 0, swept pages: 0
    Empty pages: 0, full pages: 0
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

TABLE2 (130)
    Primary pointer page: 289, Index root page: 290
    Pointer pages: 1, data page slots: 0
    Data pages: 0, average fill: 0%
    Primary pages: 0, secondary pages: 0, swept pages: 0
    Empty pages: 0, full pages: 0
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

TABLE2 (129)
    Primary pointer page: 286, Index root page: 287
    Pointer pages: 1, data page slots: 0
    Data pages: 0, average fill: 0%
    Primary pages: 0, secondary pages: 0, swept pages: 0
    Empty pages: 0, full pages: 0
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

Gstat completion time Mon Oct 13 12:39:20 2025

In other words, the tables are not qualified

[asfernandes]

@pavel-zotov I cannot reproduce these problems in Linux.
Can you save the commands in a bat file and run and check if the results are the same as the commands typed in the console? Or did you already ran it as such?

[mrotteveel]

@pavel-zotov This ticket is not about the character set issues of gstat (and other tools). Please create a new ticket for those problems, and remove all comments that are not directly related to the issue originally reported in this ticket.

[pavel-zotov]

create a new ticket for those problems, and remove all comments that are not directly related to the issue originally reported in this ticket.

#8789

[mrotteveel]

@pavel-zotov Most of the comments you posted are still about the character set handling of gstat, and not about this ticket itself.

[pavel-zotov]

Most of the comments you posted are still about the character set handling of gstat, and not about this ticket itself.

Removed all of them.