For some reason the following two queries return different results Where there is only one activity record and price is 3.63 and quantity is 16.19, the following codes return results of different rounding.
sum("CEIL(`activities`.quantity/60) * 60 / 3600 * `activities`.price").to_s "58.81" sum("CEIL(`activities`.quantity/60) * 60 / 3600 * `activities`.price * 1"). to_s "58.806" # this is the correct one I have checked the raw sql and both return 58.806. I believe this is a bug for the sum method. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/66038b1a-1306-4ef7-9e37-5ca6c89565cd%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.