firebird-test

[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

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

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