I'm not 100% sure. I've found the faulty behavior with 2 keys on both DEFAULT NULL columns.
This bug has (had) a lot of different effects and is fixed (as already mentioned) in 5.1.53 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/706988 Title: Major Bug in MySQL 5.1.49 up to 5.1.52 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs