MySQL says " Incorrect column specifier for column 'x' "

By: Johnathon Wright on: June 28, 2010

My rails app uses a database of dubious origin, so I wasn't shocked when I had issues. Because I imported the database from sql, I first noticed the issue when running tests. Tests start with

rake db:test:clone

which starts by regenerating db/schema.rb using

rake db:schema:dump

My db/schema.rb then contained columns like this:

table.float :somefloat :limit => 255

I'm pretty sure you can't have a limit without a precision and scale... in my case, I created this migration:

alter_column :table, :field, :decimal

and everything was golden.


Just checking that you are human. What would be the result of this code?

a = 3*(4/2); b = 1; a+b