Re: AUTO_INCREMENT value increases by powers of two after INSERT ... SELECT

[Ben Hunter]

I'm also getting the correct auto increment values.

I'd be curious to see which auto_increment values are being set for you. For tbl2, after inserting 4 rows, do the values go from 4 to 7, or do they go 1,3,5,7? My initial thought was maybe your auto_increment_increment or auto_incremenet_offset variables were not the default 1, but it doesn't make sense why they would be correct for tbl1 but not tbl2 as those affect all inserts. But...I suppose it's worth the short time it takes to check their values. Or maybe try it with a different engine and see if you are getting the same results.

Good luck!