Informix - Problembeschreibung
Problem IT29092 | Status: Geschlossen |
BSON_OBJECT_TO_JSON - ERROR=-1263 FOR DATETIMES BEFORE 1969 | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
select --'1968-12-31 13:00:00.00000' -- causing bson_object_to_json - error=-1263 in below ::json cast '1968-12-31 23:59:59.00000' -- causing bson_object_to_json - error=-1263 in below ::json cast --'1969-01-01 00:00:00.00000' -- working from here on --'1969-12-31 23:59:59.00000' --'1969-12-31 23:59:59.99999' --'1970-01-01 00:00:00.00000' ::DATETIME YEAR TO FRACTION(5) as dtyf5 from sysmaster:sysdual into dtyf_tab; 1 row(s) retrieved into table. select genbson(dtyf_tab,0,0) as data from dtyf_tab into bson_tab; 1 row(s) retrieved into table. select data::json from bson_tab; (U0001) - json_output: bson_object_to_json - error=-1263 Error in line 12 Near character position 31 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 12.10.xC13 and older versions. * **************************************************************** * PROBLEM DESCRIPTION: * * bson_object_to_json - error=-1263 for datetimes before 1969 * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.05.2019 20.09.2019 19.02.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC14 | |
Problem behoben lt. FixList in der Version |