I’ve recently begun writing tests in rails and I’ve run into a problem.
After recreating my test-database and running my few tests ONCE the auto
increment ID setting for some of the tables in the test-database is set
to a very high number, as in:
… ) ENGINE=InnoDB AUTO_INCREMENT=841549529 DEFAULT CHARSET=utf8 …"
when running SHOW CREATE TABLE table_name.
The problem is that I’ve set some of my column data types to be
MEDIUMINT (as opposed to rails’ standard INT in mysql) to save memory
consumption on our db-server. When running a test these column is being
“maxed out” and hence the tests produce unusable results.
Should I just accept this fact and change my mediumint columns to int or
is there a better way?
If I have not explained myself clear enough, please say so.
And on a side-note: why DOES rails “use” so many ids when running very
spare and simple anyway?
Thanks in advance.