logo       

[Rails] Rake db Fixtures MySql autoincrement problem?: msg#03317

RubyonRailsTalk

Subject: [Rails] Rake db Fixtures MySql autoincrement problem?


I'm trying to load some Rake Fixtures (rake db:fixtures:load) into a
MySql database and I'm seeing some weird behaviour with AutoIncrement
values. Normally this goes up by 1 for each insert which allows me to
define/create tests. (BTW - normal create/insert from script works
correctly).

However when I load from fixtures the id field is assigned a large
random number and the autoinc value on the table is also a large
number (1054583385) after the load. Has anyone else seen this?

FWIW this is on Windows XP with MySql 5.0 (I also tested with MySql
5.1, found the problem and rolled back to 5.0).

Anybody else seen this - Is this a known bug/issue?

TIA
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@xxxxxxxxxxxxxxxx
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@xxxxxxxxxxxxxxxx
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | Mail Home | sitemap | FAQ | advertise