MySQL column defaults ActiveRecord::SchemaDumper February 26, 2008Posted by John Dewey in ActiveRecord, Database, MySQL, Rails.
ActiveRecord::SchemaDumper will use empty strings as the default value for a column marked as NOT NULL, in MySQL versions < 5.0.51. This behavior recently changed; defaulting to null (nil). This caused our specs to fail for various reasons. Something to keep in mind when upgrading. We had been coding to a MySQL bug.