Re: auto_increment weirdness

2010-02-19 Thread Ananda Kumar
ebruary 17, 2010 6:05 PM > To: mysql@lists.mysql.com > Subject: auto_increment weirdness > > Hi, for some reason, I have an auto_increment field that's magically > bumped up to the next biggest power of 2 after a big INSERT...SELECT > that inserts a bunch of tuples (into an

RE: auto_increment weirdness

2010-02-18 Thread Gavin Towey
Reproduced in 5.1.43. Could not reproduce it in 5.0.66 -Original Message- From: Yang Zhang [mailto:yanghates...@gmail.com] Sent: Wednesday, February 17, 2010 6:05 PM To: mysql@lists.mysql.com Subject: auto_increment weirdness Hi, for some reason, I have an auto_increment field that&#

auto_increment weirdness

2010-02-17 Thread Yang Zhang
Hi, for some reason, I have an auto_increment field that's magically bumped up to the next biggest power of 2 after a big INSERT...SELECT that inserts a bunch of tuples (into an empty table). Is this expected behavior? I couldn't find any mention of this from the docs (using the MySQL 5.4.3 beta).