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

[Andy <jac...@Xg...>]

select *  from RDB$INDICES

work ok and shows RDB$SYSTEM_FLAG as either 1 or 0.

select distinct RDB$SYSTEM_FLAG from RDB$INDICES;

ok, and returns two records, 1 and 0.

but this returns nothing:

select *  from RDB$INDICES where RDB$SYSTEM_FLAG = 0;


in code I can:

select *  from RDB$INDICES

and

q.fieldByName('RDB$SYSTEM_FLAG').asInteger = 0 and see it ok

Not sure if its supposed to act like that or not.

-Andy