Here it is: OPENJPA-1224
-----Original Message----- From: David Beer [mailto:[email protected]] Sent: Tuesday, 4 August 2009 6:34 AM To: [email protected] Subject: Re: MySQL ignoring BigDecimal precision. Hi Can you post JRIRA Number once submitted please. Thanks David On Mon, 3 Aug 2009 13:11:24 -0700 (PDT) ljnelson <[email protected]> wrote: > > For what it's worth this is also reproducible on the H2 platform. > > On Mon, Aug 3, 2009 at 4:10 PM, crispyoz (via Nabble) < > [email protected]<ml-user%[email protected]. com> > > wrote: > > > OK sure will do > > > > -----Original Message----- > > From: [hidden > > email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=3380141&i=0>[m ailto:[hidden > > email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=3380141&i=1>] > > > > Sent: Tuesday, 4 August 2009 6:02 AM > > To: [hidden > > email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=3380141&i=2> > > Subject: Re: MySQL ignoring BigDecimal precision. > > > > Hi Chris, > > > > Can you please file a JIRA with a reproducible test case? > > > > Thanks, > > > > Craig > > > > On Aug 3, 2009, at 12:29 PM, C N Davies wrote: > > > > > I'm using MySQL and I find that when Open JPA generates the > > > tables it defaults any BigDecimal columns to Decimal(10,0) > > > ignoring my annotation that > > > says I want 10,6. I'm using: > > > > > > > > > > > > @Column(name="chargerate", precision=10,scale=6, > > > nullable=false) > > > > > > > > > > > > The manual says there is an issue with Floats and Doubles but > > > doesn't mention BigDecimals: > > > > > > > > > > > > "Floats and doubles may lose precision when stored in some > > > datastores." > > > > > > > > > > > > I'm using InnoDB tables on MySQL 5.1.32 > > > > > > > > > > > > Thanks > > > > > > > > > > > > Chris > > > > > > > > > > > > > > > > > > > Craig L Russell > > Architect, Sun Java Enterprise System http://db.apache.org/jdo > > 408 276-5638 mailto:[hidden > > email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=3380141&i=3> > > P.S. A good JDO? O, Gasp! > > > > > > > > > > ------------------------------ > > View message @ > > http://n2.nabble.com/MySQL-ignoring-BigDecimal-precision.-tp3379935p3380141. html > > To start a new topic under OpenJPA Users, email > > [email protected]<ml-node%[email protected]. com> > > To unsubscribe from OpenJPA Users, click here< (link removed) =>. > > > > > > > -- Best Regards David Beer http://www.thebeerfamily.com
