| Subject | Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results |
|---|---|
| Author | Robert Tulloch |
| Post date | 2019-02-26T17:04:01Z |
Thanks.
I checked the value and it is indeed 0
I assume I can't attach a screen shot otherwise I would.
Did you try running the query on your system to see if it works?
Best
Robert
On 2/26/2019 11:41 AM, Mark Rotteveel mark@... [firebird-support] wrote:
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