Hi. please use "INSERT INTO forms (total_amount, vat, id) VALUES (1E+2, 1E+3, ?)", and 1E+3 is out of precision range defined by "t.column :vat, :decimal, :precision => 4, :scale => 2" , precision => 5 should work.
2008/5/19 <[EMAIL PROTECTED]>: > Bugs item #20233, was opened at 2008-05-19 10:47 > You can respond by visiting: > http://rubyforge.org/tracker/?func=detail&atid=7857&aid=20233&group_id=2014 > > Category: AR-JDBC > Group: None > Status: Open > Resolution: None > Priority: 3 > Submitted By: Gaetano Gallo (locomotyphus) > Assigned to: Nobody (None) > Summary: Special Float values for Oracle > > Initial Comment: > Rails generated the following sql which gets rejected by Oracle: > > ActiveRecord::ActiveRecordError: ORA-00917: Komma fehlt > : INSERT INTO forms (total_amount, vat, id) VALUES (1E+2.0, 1E+3.0, ?) > > This is the definition of our migration: > > create_table :forms do |t| > t.column :total_amount, :decimal, :precision => 8, :scale => 2 > t.column :vat, :decimal, :precision => 4, :scale => 2 > end > > And here is the test which causes the insertion of a new record to fail: > > def test_create_form_with_special_decimal_values > form= Form.new do |f| > f.total_amount= 100.00 > f.vat= 1000.00 > end > form.save! > end > > For other values like 12.34 or 99.0 this problem does not occure, because > they get translated in strings recognized by oracle. I think the correct > translation should happen in the activerecord-jdbc-adapter implementation. > > We use a Oracle 10.2.0.1. > > Best regards, > Gaetano > > ---------------------------------------------------------------------- > > You can respond by visiting: > http://rubyforge.org/tracker/?func=detail&atid=7857&aid=20233&group_id=2014 > _______________________________________________ > Jruby-extras-devel mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/jruby-extras-devel > -- Cheers, Jesse
_______________________________________________ Jruby-extras-devel mailing list [email protected] http://rubyforge.org/mailman/listinfo/jruby-extras-devel
