On 26-2-2019 17:29, Robert Tulloch tultalk@... [firebird-support]
wrote:

> IB 6
>
> Interesting:
>
> If I run
>
> select cast (RDB$RELATION_NAME as varchar(32)) AS TABLE_NAME, cast
> (RDB$INDEX_NAME as varchar(32)) AS INDEX_NAME, RDB$STATISTICS from
> rdb$indices where 0 = 0 AND RDB$SYSTEM_FLAG = 1 order by RDB$STATISTICS DESC
>
> The result set is all the system tables. Running RDB$SYSTEM_FLAG = 0
> returns zilch.
>
> Makes NO sense.
>
> I checked the RDB$SYSTEM_FLAG parameter and it is correct for the two
> different kinds of tables.

It is possible it has NULL instead of 0. So try `RDB$SYSTEM_FLAG = 0 OR
RDB$SYSTEM_FLAG IS NULL`

Or, just query without the condition and check what the actual value of
RDB$SYSTEM_FLAG is.

Mark
--
Mark Rotteveel