Description:
Incorrect results are returned from executing a batch statement multiple times with the
query cache turned on.
How to repeat:
1. Enable the query cache
2. Use a connector that allows you to connect and issue batch type statements (meaning
the connector sends the entire SQL statement in one shot)
3. Issue a batch select statement such as "select id from test where id < 50; select id
from test where id > 50".
4. Issue this statement again.
5. note that only one resultset is returned and that is the results from the first
select even though the AnotherQuery flag is set to true indicating that another resultset
should be sent, however it never is.