>> The error is strange, but what is the structure of MyTable_tmp?
>It's because MyTable_tmp contains two columns of 'text' type?
Yes, I would guess so. May be you need to list all fields you want to insert explicitly.
If it's not broken, fix it until it is.
My Blog 
