Oracle blows goat nads today. Here I am, doing a mildly complex query – something along the lines of :
select a.id, a.title, b.someinfo from a, b where a.id in (3,1,7) and a.id = b.id(+)
So the result order *SHOULD* be 3,1,7.
Nooooo. Every time, the query returns 1,3,7. So that’s today’s head-bang-wall exersize – figuring out where this darn auto-sort is happening when no sort should be taking place.
Screw it, I’m gonna go get some lunch.