Informix - Problem description
Problem IT39101 | Status: Closed |
UNLIKE ON BSON::JSON:LVARCHAR CAST RETURNS 788 UNKNOWN OPERATOR/TYPE IF CLIENT_LOCALE OR DB_LOCALE IS SET TO EN_US.UTF8 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem 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 | |
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. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * 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. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC16 and 14.10.xC8. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.11.2021 30.09.2022 13.06.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |