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

[Andy-83]

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

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Frank Schlottmann-Goedde-2]

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

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Andy-87]

Frank Schlottmann-Gödde wrote:

> 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
>
>

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

Sorry 'bout that, and thanks for the help.

-Andy

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test