Originally posted by jmodic
Most obvous answer. However: how come the same SQL executes fine without PARALLEL hint, as the original poster indicates (if this is actualy true)? It smells more as a bug to me, if what original poster states is true....
Or it could be something like.. the order in which the tabs are accessed & joins and so.
What i mean is something like..
Case I ( Without parallel hint ) :
lets assume the table haaif is the driving table (& in exec plan too)and is driven by some other condition & not 'attribute3' (or even 'attribute3' also as we dont know what the other conditions are).. and all the values returned for 'attribute3' is only Numerals..
Case II ( With parallel hint )
lets assume here plan is slightly diff from above one.. & haaif is not the driving table.. we will assume papfa is the driving table & for some person id there is a value in haaif where attribute3 is non numeral.. so for that Val, it suerly errors.
So not necessarly a bug .. 
PS jurij, you can blast if i have some where mistaken in concepts 
Abhay.
Last edited by abhaysk; 04-07-2004 at 10:53 AM.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Reply With Quote