From: Mark Nyon <mark@...>
Date: 2007-03-29T01:05:59+09:00
Subject: functional testing strangeness with rake

Hi,

I have a Rails 1.2.3 app that's running under cruisecontrol.rb (thanks
Thoughtworks). I recently added a test to a search controller that makes
a fulltext query to a MySQL table. The create_table statement in the
migration clearly indicates that the engine should be MyISAM:


 create_table "events", :options => 'TYPE=MyISAM', :force => true do |t|
      t.column "url_hash", :string, :limit => 30
      t.column "user_id", :integer
      t.column "active", :boolean, :default => true, :null => false
      t.column "featured", :boolean
      t.column "start_time", :datetime
      t.column "end_time", :datetime
 ...

 end

Whenever I blow the database away and run rake db:migrate in the
development environment, the tables are created with the MyISAM engine.
However, whenever I run rake db:migrate in the test environment, all
tables in that db are InnoDB, except schema_info.  Does anyone have any
clues on why this behavior would be different? Thanks.

-- 
Posted via http://www.ruby-forum.com/.