Informix - Problembeschreibung
| Problem IT09625 | Status: Geschlossen | 
GENBSON INCORRECTLY CONVERTING NON-ZERO FRACTION PART OF DATETIME  | |
| Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10  | |
| Problembeschreibung: | |
select genbson(row('2002-12-31 23:59:59.999'::datetime year to 
fraction(3)), 0, 1)::json from sysdual; 
 
(expression)  {"":ISODate("2003-01-12T13:29:59.000Z")} 
 
 
select genbson(row('2002-12-31 23:59:59.99999'::datetime year to 
fraction(5)), 0, 1)::json from sysdual; 
 
(expression)  {"":ISODate("2003-01-12T13:46:29.000Z")} 
 
 
select genbson(row('2002-01-01 00:00:00.001'::datetime year to 
fraction(3)), 0, 1)::json from sysdual; 
 
(expression)  {"":ISODate("2002-01-01T00:16:40.000Z")} 
 
 
select genbson(row('2002-01-01 00:00:00.00001'::datetime year to 
fraction(5)), 0, 1)::json from sysdual; 
 
(expression)  {"":ISODate("2002-01-01T00:00:10.000Z")} | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * only those using genbson() functionality of NoSql * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * ****************************************************************  | |
| Local-Fix: | |
| Lösung | |
Problem Fixed In IBM Informix Server 12.10.xC6  | |
| Workaround | |
keiner bekannt / siehe Local-Fix  | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung:  | 23.06.2015 30.12.2015 30.12.2015  | 
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC6  | |
| Problem behoben lt. FixList in der Version | |
| 12.10.xC6 | 
 |