MySQL most definitely allows AUTO_INCREMENT in composite keys! That is the reason I came here years ago! And it not allows it, as it enforces it when using partitioned tables.