Changeset 8969 for trunk/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb

Timestamp:

03/02/08 04:42:10 (5 months ago)

Author:

nzkoz

Message:

Make the mysql schema dumper roundtrip the limits of text/blob columns. Closes #7424 [will.bryant]

Files:

• trunk/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb (modified) (1 diff)

trunk/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb

@@ -111 +111 @@
-          return :string  if field_type =~ /enum/i
-          super
+        end
+
+        def extract_limit(sql_type)
+          if sql_type =~ /blob|text/i
+            case sql_type
+            when /tiny/i
+              255
+            when /medium/i
+              16777215
+            when /long/i
+              2147483647 # mysql only allows 2^31-1, not 2^32-1, somewhat inconsistently with the tiny/medium/normal cases
+            else
+              super # we could return 65535 here, but we leave it undecorated by default
+            end
+          else
+            super
+          end
-        end
-