Hi
Using jooq 1.6.5 or 1.6.2 on Hsqldb 2.2.5
Im having a problem with scale when inserting into table a bigdecimal
when using dsl statement.
example:
table z (
d decimal(12,2)
)
create.insertInto(Z.Z,Z.D).values(new BigDecimal("5.19")).execute()
The value on the database is 5.00
Aparentely it scales before inserting into the database.
if i do
create.query("Insert into z values("+new BigDecimal("5.19+")")
works fine, database returned 5.19 as it should.With createStatement
it works fine to.
Tanks
Andre Bastos