I cannot reproduce your test case on the latest version of mysql, in Gutsy.
Can you specify which version you're using ?
I cannot reproduce your test case on the latest version of mysql, in Gutsy.
Can you specify which version you're using ?