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

[Andy <an...@ca...>]

Frank Schlottmann-G=F6dde wrote:
> Andy schrieb:
>> select *  from RDB$INDICES
>>
>> work ok and shows RDB$SYSTEM_FLAG as either 1 or 0.
>=20
> I think its 1 or null.
>> select distinct RDB$SYSTEM_FLAG from RDB$INDICES;
>>
>> ok, and returns two records, 1 and 0.
>=20
> In fact it usually returns 1 and *NULL*
>=20
>> but this returns nothing:
>>
>> select *  from RDB$INDICES where RDB$SYSTEM_FLAG =3D 0;
>=20
> should be
> select *  from RDB$INDICES where RDB$SYSTEM_FLAG is null;
>=20
>> in code I can:
>>
>> select *  from RDB$INDICES
>>
>> and
>>
>> q.fieldByName('RDB$SYSTEM_FLAG').asInteger =3D 0 and see it ok
>=20
> Your components seem to translate null to 0;
>=20
>=20
>=20
>=20
> hth
> Frank
>=20
>=20

Oh!  Crap!  You're correct.  I can't believe I made that mistake.  And=20
yes, asInteger will return null's as zero (which is probably what I was=20
displaying too)

Sorry 'bout that, and thanks for the help.

-Andy