rspec & table type MyISAM

rubyonrails-talk
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

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

2

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