# Rake vs Ruby for running tests (error discrepency)

**URL:** <https://discuss.rubyonrails.org/t/rake-vs-ruby-for-running-tests-error-discrepency/38208>\
**Category:** rubyonrails-talk\
**Created:** [January 12, 2009, 12:32am UTC](https://discuss.rubyonrails.org/t/rake-vs-ruby-for-running-tests-error-discrepency/38208 "2009-01-12T00:32:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [January 12, 2009, 12:32am UTC](https://discuss.rubyonrails.org/t/rake-vs-ruby-for-running-tests-error-discrepency/38208/1 "2009-01-12T00:32:56Z")

</div>

The thread is old, however we got similar error recently with rails 2 and mysql 5.1. It was related to missing fixtures, however the problem with mysql

our installation is mysql 5.1.22 on CentOS 5 and 5.1.30 on Debian we were able to reproduce the error with simple seqence of sql commands

select version();

DROP TABLE IF EXISTS test\_inc; CREATE TABLE `test_inc` ( `id` int(11) NOT NULL AUTO\_INCREMENT, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

select 'insert explicit 9. must become 10'; insert into test\_inc ( id, account\_id) values (9,1); select \* from test\_inc; show create table test\_inc \G select 'delete all. stays 10'; delete from test\_inc; select \* from test\_inc; show create table test\_inc \G

select 'insert autoincrement. must become 11'; insert into test\_inc ( account\_id) values (1) ; select \* from test\_inc ; show create table test\_inc \G select 'delete all. stays 11'; delete from test\_inc ; select \* from test\_inc ; show create table test\_inc \G

select 'insert explicit 11. must become 12, but stays 11'; insert into test\_inc ( id, account\_id) values (11,1); select \* from test\_inc; show create table test\_inc \G

/\* select 'insert explicit 12. must become 13'; insert into test\_inc ( id, account\_id) values (12,1); select \* from test\_inc; show create table test\_inc \G \*/

select \* from test\_inc; show create table test\_inc \G select 'insert auto-increment'; insert into test\_inc ( account\_id) values (1); select \* from test\_inc; show create table test\_inc \G

I've opened a bug with mysql, however they 'closed' it as unable to reproduce

[http://ep.blogware.com/blog/\_archives/2009/1/9/4051185.html](http://ep.blogware.com/blog/_archives/2009/1/9/4051185.html)

[http://bugs.mysql.com/bug.php?id=41984](http://bugs.mysql.com/bug.php?id=41984)