It's not a bug but documented behavior.

>Why would it not be considered a bug in VFP if this is the case? Like I said, when I run the query a second, sequential time in code or from the command line, the results are correct?
>
>It seems to me that what we are doing is just a workaround for a VFP bug. The workaround isn't really cludgy, so I am rather OK with it, but it does bother me that it is one of those unnoticable things.
>
>David