QUERY CACHE IS ON
Problem:
In case a session state exists do not cache the SELECT stmt. If we
cache SELECT statment when session state information exists, then
the result sets of this SELECT are cached which contains changed
session information. Next time when same query is executed when there
is no change in session state, then result sets are picked from cache
which is wrong as the result sets picked from cache have changed
state information.
Fix:
Fix is to not cache the SELECT query when there exists a session state.