Some test code would be appreciated.

Can you reproduce the "weird" behaviour in a few lines of code?

Moreover, does the same thing happen if you type your SQL in MySQL command line monitor?