Hi!
If you can reproduce this problem, then the best
way is to turn to support.
This one is from Oracle 9.2.0.4 on Tru64 patchset
readme:
Hash Join Bugs
The following table lists the hash join bugs addressed in this patch set:
| Fixed in Release | Bug Number | Description |
|---|---|---|
| 9202 | 2296247 | Incorrect results / memory corruption / dump from UPDATE using HASH JOIN with correlated SUBQUERY |
| 9203 | 2514869 | Dump (qerhjWalkHashBucket to kpofcr) from HASH JOIN OUTER with BINDs |
| 9203 | 2533766 | Wrong results from HASH JOIN over DBLINK between multibyte databases |
| 9204 | 2726276 | Wrong SCORE() for plans with Text index below a HASH JOIN |
| 9204 | 2727212 | Wrong results from HASH join between CHAR column and VIEW column based on a BIND variable |
Check if you hit any of these.
Tanel.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
Sent: Monday, September 08, 2003 10:39
PM
Subject: Incorrect results - 9.2 and hash
joins
> Good day to everyone
>
> Oracle 9.2.0.3 returns different (wrong!) results when hash joins are enabled.
>
> After (at session level) disabling hash joins, query returns correct results.
> The very same query, with exactly same data, returns valid values on 8.1.7
> database.
>
> Has someone else seen this? This may leed to disastrous logical corruption of
> database.
>
> Any input, explanation, patches, stories or workarround tips, beside disabling
> hash joins?
>
> Thanks,
> Vladimir
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
