IT39101: UNLIKE ON BSON::JSON:LVARCHAR CAST RETURNS 788 UNKNOWN OPERATOR/TYPE IF CLIENT_LOCALE OR DB_LOCALE IS SET TO EN_US.UTF8

APAR status

• Closed as program error.

Error description

• When either the env variable CLIENT_LOCALE or DB_LOCALE are set
  to en_us.utf8 and you create a database
  with a table that has a bson column like
  
      export CLIENT_LOCALE=en_us.utf8
      export DB_LOCALE=en_us.utf8
  
      create database testdb with log;
      create table test(col1 char(36) not null, col2 char(36) not
  null, col3 bson);
  
  then a query like the following after loading a couple rows
  
      select col3::json::lvarchar(256) from test where
  col3::json::lvarchar(256) not like "%xConfiguration%";
  
  will return the following error regardless of the bson data
  
  788: Unknown operator/type
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC16 and 14.10.xC8.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC16 (if available) or      *
  * 14.10.xC8.                                                   *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC16 and 14.10.xC8.
  

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