IT29092: BSON_OBJECT_TO_JSON - ERROR=-1263 FOR DATETIMES BEFORE 1969

APAR status

• Closed as program error.

Error 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
  

Local fix

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:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 12.10.xC14.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels