Informix - Problembeschreibung
Problem IC61720 | Status: Geschlossen |
DRDA: WRONG DECIMAL VALUE INSERTED WHEN HOST VARIABLE IS USED AND STATEMENT CACHE IS ON | |
Produkt: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
Problembeschreibung: | |
A prepared statement inserting a DECIMAL value omits the digits after the decimal point when statement cache is on and the statement is executed the second time. This reproduces for DRDA clients only (Data Server Driver for JDBC or .NET). Example using Data Server Driver for JDBC PreparedStatement pstmt2=conn.prepareStatement("insert into instab1 values(?,?)"); int vid = 1; BigDecimal vc1 = new BigDecimal(88.88); pstmt2.setInt(1,vid); pstmt2.setBigDecimal(2,vc1); pstmt2.executeUpdate(); With STMT_CACHE_HITS 0 After first execution; Select from instab id = 1 c1 = 88.88 After subsequent executions: Select from instab id = 1 c1 = 88.00 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DRDA clients with decimal data types * **************************************************************** * PROBLEM DESCRIPTION: * * A prepared statement inserting a DECIMAL value omits the * * digits after the decimal point when statement cache is on * * and the statement is executed the second time. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC5 and above. * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem first fixed in IDS 11.50.xC5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.06.2009 22.01.2010 22.01.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
11.50.xC5 | |
Problem behoben lt. FixList in der Version | |
11.50.xC5 |