I've tried Google with either the wrong terms or no help: I've got a query I'm running. However, it /alternates/ the result set it gives back. One time it'll (properly) give back 1 row: othertimes it (incorrectly) returns about 54 rows.
Normally it does the right thing (give back 1 row), however it sometimes falls into this state of the alternating results.
The query is on a table, where a NUMBER column is greater than an INTEGER column.
Does anyone know of anything that can cause this behavior, or other methods to try to debug it?