Re: Query using new schema but prepared statement using old schema

[No No]

Isotopp on the MySQL IRC channel answered the question for me.

The prepared statement maintains a reference to the table it was prepared for, i.e. the table in the schema at the time of preparation. So even if the session schema is changed, the prepared statement will still reference the schema it was prepared against.

I need to rewrite my code to either explicitly reference the schema or not use prepared statements.