#238 problem with decimal columns - Plugins

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

#238 new

problem with decimal columns

Reported by Deleted User | July 23rd, 2008 @ 03:00 AM

I have the following in schema.rb:

t.decimal "balance", :precision => 8, :scale => 2, :default => 0.0

Strangely auto_migrations created the column in mysql as decimal(10,0).

Also, whenever I type rake db:auto:migrate auto migrations reports: "change_column("accounts", :balance, :decimal)" even though I have not changed schema.rb.

BTW I think auto_migrations is my favorite plugin ever... it's saved me tremendous amounts of time.

I'm using ubuntu hardy and mysql 5.1.

Comments and changes to this ticket

You flagged this item as spam.
mileszs November 14th, 2008 @ 06:22 AM
I can confirm this issue. I am using SQLite3 (on Ubuntu Hardy, also, actually).

It appears that line 121 in lib/auto_migrations.rb is always evaluating to true on decimal fields for the attributes 'precision' and 'scale'. The expression 'fields_in_db[field].send(att)' is nil for precision and scale, every time.

I'm sorry to take it this far and then drop the ball. I will try to dig in further as soon as I can.

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.