MySQL decimal Datatype Requires Migration With ":precision => ..." to Avoid "No integer type has byte size " Error

[technoweenie]

MySQL decimal Datatype Requires Migration With ":precision => ..." to Avoid "No integer type has byte size " Error

[cure]

I also ran into this. Here's my workaround:

--- acts_as_versioned.rb.bu 2011-06-18 22:19:17.965242002 -0400
+++ acts_as_versioned.rb    2011-06-18 22:18:36.061242003 -0400
@@ -425,8 +425,13 @@
             end

             self.versioned_columns.each do |col|
+              limit = col.limit
+              if col.limit == 10 and col.type == :integer
+                   # Avoid 'No integer type has byte size 10' under MySQL
+                   limit = 8
+              end
               self.connection.add_column versioned_table_name, col.name, col.type,
-                                         :limit     => col.limit,
+                                         :limit     => limit,
                                          :default   => col.default,
                                          :scale     => col.scale,
                                          :precision => col.precision