Home » SQL & PL/SQL » SQL & PL/SQL » WIn XP, Oracle 10g (Parallel Hint : Different results)
WIn XP, Oracle 10g [message #388753] Thu, 26 February 2009 01:36 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
Hi all..

I came across some wiered scenario this morning...
My query result set got changed only using Parallel hint...no other hints and changes..

Is it ever possible?

from,
Freakabhi

Re: WIn XP, Oracle 10g [message #388755 is a reply to message #388753] Thu, 26 February 2009 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without more precision not even an Oracle version the only we can say is: search on Metalink if there is any bug for you.

Regards
Michel
Re: WIn XP, Oracle 10g [message #388762 is a reply to message #388753] Thu, 26 February 2009 02:21 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If your result set changes reproducibly when you add a hint, then it's almost certainly a bug.

If it's not reproducible, then have you considered that the data you are looking at might have changed?
Previous Topic: Base64 String to Image
Next Topic: Trigger for enforcing referential integrity
Goto Forum:
  


Current Time: Fri Dec 02 18:57:44 CST 2016

Total time taken to generate the page: 0.34558 seconds