Comment 1 for bug 1412955

To answer the last question: "Notice in my second scenario here, an ESP is started. Why?????"

The query being issued is:
prepare cmd from select [first 10]* from tbl500;

This is not a unique or oltp query and will be scanning the table without any key or scan predicates.
Parallel execution using esps may be chosen.

An explain will show what the plan looks like.

Not yet clear on why the other error 8609 is being returned since this is a non-transactional query.
Could be that a transaction state is leftover from a previous query. We have seen some issues with
transaction state not being handled correctly in ESPs. Selva has looked at it.
Maybe he can comment.