Puzzler of the day - 5.0 Windows Setup

[Kenneth Brody]

On 5/3/2011 5:15 PM, Kenneth Brody wrote:
[...]
> How about having your sort/select processing log each record number
> processed, along with "selected"/"not selected", and see what you get?  How
> does computer B compare to the ones that work?

Note that, since you have turned index scan off, and you are not using 
lookup-dash in sort/select processing, the records will be in record-number 
order.

Also, you should probably include the account number in the log, as well as 
anything else you might find useful, to help see what's going on.

Of course, given the same selection criteria on the same database, all 
computers _should_ give identical logs.  The question is "what is different 
in computer B's logs, and why".

-- 
Kenneth Brody