Re: Queries give impossible results

From: Matthias Rogel <rogel_at_web.de>
Date: Fri, 15 Nov 2002 11:31:25 +0100
Message-ID: <ar2idt$dsudm$1@ID-86071.news.dfncis.de>

Jake S wrote:
> "Matthias Rogel" <rogel_at_web.de> wrote in message
> news:ar07ji$drh0v$1_at_ID-86071.news.dfncis.de...
>

>>please try
>>analyze table ci_customer validate structure cascade online;
>>is this performed without exception ?
>>

>
>
> No problems:
>
> SQL> ANALYZE TABLE ci_customer VALIDATE STRUCTURE CASCADE;
>
> Table analyzed.
>
> - Jake -
>
>

ok,
a simple select with no optimizer hint gives the wrong result 4, a select with /*+RULE */ gives the right result.

IMHO, the following is clear:
a. either software (oracle) is buggy or index is corrupt b. if index were corrupt (my first conjecture), an

    analyze table ...
    would have thrown an exception
    (in which case i would have suggested, drop index and recreate it) c. since it didn't throw an exception, still index can be corrupt

    but then there is a bug in
    analyze ..

Conclusion:
- in either case, software (oracle engine) is proved to be buggy

since mike liu posted
'...
The wrong result might be related to a bug in "bitmap conversion". Can ...'

I am quite sure he is right.

(mike: are U a programmer for oracle ?)

matthias Received on Fri Nov 15 2002 - 04:31:25 CST