Re: Queries give impossible results

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: Thu, 14 Nov 2002 13:41:02 GMT
Message-ID: <3dd3a985$0$46600$e4fe514c@news.xs4all.nl>

Jake S wrote:

>I'm having strange problems with Oracle (8.1.7). Queries give results that
>are not possible. I added a simple example below. First two count values are
>correct, third is not possible, as you can see. Have you ever seen anything
>like this?
>

Seems strange indeed. I would say that the 3rd and the 4th result seem to conflict with each other. Is ci_customer a plain table? You might suffer from bugs. Go to metalink, go to bug database searchm search with the keywords 'wrong result' and expect to find dozens...

Check the execution plan, and if any indexes are used for a query, try specifying a full hint, in order to force a full table scan.

Kind Regards,

Herman de Boer
IT Consultancy Group bv. Received on Thu Nov 14 2002 - 07:41:02 CST