Re: [Firebird-test] FB2 rc4: RDB$INDICES acting strange

[<fs...@us...>]

Andy schrieb:
> select *  from RDB$INDICES
> 
> work ok and shows RDB$SYSTEM_FLAG as either 1 or 0.

I think its 1 or null.
> 
> select distinct RDB$SYSTEM_FLAG from RDB$INDICES;
> 
> ok, and returns two records, 1 and 0.

In fact it usually returns 1 and *NULL*

> but this returns nothing:
> 
> select *  from RDB$INDICES where RDB$SYSTEM_FLAG = 0;

should be
select *  from RDB$INDICES where RDB$SYSTEM_FLAG is null;

> 
> in code I can:
> 
> select *  from RDB$INDICES
> 
> and
> 
> q.fieldByName('RDB$SYSTEM_FLAG').asInteger = 0 and see it ok

Your components seem to translate null to 0;




hth
Frank


-- 
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
   their tears have healing powers and they make highly faithful pets."
       - J.K. Rowling