[Pljava-dev] Possible bug, when updating BigDecimal from trigger/function

From: pmichalek at click(dot)cz ( Petr Michálek )
To:
Subject: [Pljava-dev] Possible bug, when updating BigDecimal from trigger/function
Date: 2008-06-08 20:06:56
Message-ID: 484C3BE0.8010406@click.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Hello,

When PL/Java trigger/function is updating BigDecimal, scale of new
BigDecimal value is not checked. Because of this, is possible store in
database numeric value with greater precision than is in column definition.

In result of this behavior sql dump can contains values with greater
precision and subsequent import fails on affected tables.

Please can anybody confirm this behavior and is possible to fix this.

Best regards.

Petr Michalek

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Kris Jurka 2008-06-10 03:47:51 [Pljava-dev] Possible bug, when updating BigDecimal from trigger/function
Previous Message Kris Jurka 2008-06-08 18:02:38 [Pljava-dev] How to compile pljava in Solaris 10 5/08?