Informix - Problembeschreibung
Problem IC61719 | Status: Geschlossen |
DRDA: MONEY TYPES < 0.5 ARE SET TO 0 WHEN USED AS HOST VARIABLESFOR SELECT, UPDATE, DELETE | |
Produkt: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
Problembeschreibung: | |
The value of host variables assigned to MONEY types are set to 0 for SELECT, UPDATE and DELETE statements. It works for INSERT. Checking statement history shows that the type for money values < 0.5 is "money", the type for values >= 5 is "decimal". Example for c1=0.4 Database: mydb Statement text: update instab set c1=? where id=1 UPDATE using tables [ instab ] Iterator/Explain ================ ID Left Right Est Cost Est Rows Num Rows Partnum Type 1 0 0 2 1 1 2097219 Seq Scan Host Variables ============== 0 money $0.00 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users using money datatype through DRDA * **************************************************************** * PROBLEM DESCRIPTION: * * Money types are not converted properly during assignment of * * data to host variables through DRDA * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.10.xC4 when available or IDS 11.50.xC5 and * * above. * **************************************************************** | |
Local-Fix: | |
Lösung | |
The problem has been fixed in IDS 11.10.xC4 and IDS 11.50.xC5. Now the fractional parts will not be lost in DRDA with money datatypes. | |
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.10.xC4, 11.50.xC5 | |
Problem behoben lt. FixList in der Version | |
11.50.xC5 |