#1275 [BUG] Raw SQL select truncates decimal values - DataMapper

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 »

#1275 unconfirmed

[BUG] Raw SQL select truncates decimal values

Reported by Xavier Shay | May 18th, 2010 @ 08:10 PM

Observe:

irb(main):003:0> repository.adapter.select("SELECT SUM(1.5) FROM DUAL")
=> [1]
irb(main):004:0> repository.adapter.select("SELECT 1.5 FROM DUAL")
=> [1]

I don't have a fix

Comments and changes to this ticket

Dan Kubb (dkubb) May 21st, 2010 @ 04:38 PM
- Assigned user set to “Dirkjan Bussink”
Assigning this to dbussink for now, until rsim accepts the invite I sent him for LH.

Should we add some specs to DO that ensures coercion for raw queries can be performed relatively consistently? I can understand if some DBs make it more difficult than others to identify what the return type is, but when it is possible to know, I think we should coerce.

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.