Re: strange parallel query behavior

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 30 Jun 1999 09:38:04 +0100
Message-ID: <930732349.13660.0.nnrp-13.9e984b29@news.demon.co.uk>

Which version of oracle are you running. You need to run at least 7.3.3.5 to avoid most of the serious bugs. Even so, there are some still left - e.g.

bug 722736, fixed in patchset 8.0.5.1

A join of two inputs where one is parallel and the other is not with functions in the join predicates can get wrong results (usually no results).
looks very like yours.

>and decode(a.fac_stu_cnt_curr, 0, 'N', 'Y') = d.has_students_ind

Try it with both tables parallel.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Eric Spear wrote in message <377977FB.C872010D_at_deans.umd.edu>...
>The text below shows the exact same query. However, the first one is
>run with one
>of the tables in "parallel" mode, while the second query has that table
>switched to "serial" mode. The first query gets the wrong answer; the
>second query is correct. Lesson: the parallel option seems a little
>buggy, yes?
Received on Wed Jun 30 1999 - 03:38:04 CDT