dr_bentonquest wrote:

>> Two things...
>>
>>> I'm really sorry to post this here, but I made a mistake. I used FB
>>> beta 1 on a production system and everything went fine, but when I
>>> upgraded to beta 2, I got erratic behavior on select statements, so I
>>> need to go back to beta 1. Problem is I can't find it on SF.
>> 1) What errors? You might want to list them here, perhaps it's
>> a known thing or perhaps there's a workaround.
>
> SELECT ID,STATUS FROM TRACKING WHERE CASE='123'
>
> Results:
> ID,STATUS
> ---------
> 12,20
> 13,30
> 14,40
>
> So far so good. But when I try this:
>
> SELECT ID,STATUS FROM TRACKING WHERE CASE='123' AND STATUS<50
>
> nothing is returned. I've recomputed indexes but no luck.
>
>> 2) using a beta in production? And then another beta???
>
> Yes. Beta 1 was working fine for me.

Please give us more detailed informations: platform,Tracking table
structure , indexes,plan etc...

Why you use CASE as table column name ?
Isn't it a reserved word ?

maybe :
SELECT ID,STATUS FROM TRACKING WHERE TRACKING."CASE" ='123' AND
TRACKING.STATUS<50




Regards
Boguslaw brandys