|
Problem IT29092
|
Status: Closed |
BSON_OBJECT_TO_JSON - ERROR=-1263 FOR DATETIMES BEFORE 1969
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.05.2019
20.09.2019
19.02.2020 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC14
|
| Problem solved according to the fixlist(s) of the following version(s) |
