Rspec & table type MyISAM

Rails
1

i’m using a table, that uses fulltext search and therefore the table
type MyISAM
everything works fine in production mode, but tests fail with

ActiveRecord::StatementInvalid: Mysql::Error: The used table type
doesn’t support FULLTEXT indexes

when looking in the test db it’s clear, that it’s using InnoDB, but even
manually changing the table type does not help, since it’s created new
for every test run

(we use rspec, but it’s the same for normal test)

migration:

create_table :pages, :options => “engine=MyISAM” do |t|
…
end

should work that way and does in development mode…

2

On 13 Feb 2008, at 13:09, Thorsten M. wrote:

manually changing the table type does not help, since it’s created new
for every test run

(we use rspec, but it’s the same for normal test)

migration:

create_table :pages, :options => “engine=MyISAM” do |t|
…
end

Are you using the ruby schema dumped? it doesn’t support options like
that IIRC (you can turn this on/off in environment.rb)

3

Are you using the ruby schema dumped? it doesn’t support options like
that IIRC (you can turn this on/off in environment.rb)

yep, that was it!

thanks a lot