|
Problem IT11350
|
Status: Closed |
VARIOUS FAILURES CAN OCCUR WHEN SELECT USING BSON_GET CAUSES CORRUPTION WHEN ROW NOT FOUND
|
| product: |
INFORMIX SERVER / 5725A3900 / B50 - IDS 11.50 |
| Problem description: |
A query like:
SELECT SKIP 0 LIMIT 1 data FROM sslprofiles WHERE
( bson_get(data, 'orgId') =
'{orgID":"55dde48ae4b0f78e35094af7"}'::json::bson ) AND
( ( bson_value_lvarchar(data, '_id') =
"55e495afe4b0f78e3509e00c" ) OR
( bson_get(data, 'name') =
'{"name":"55e495afe4b0f78e3509e00c"}'::json::bson ) );
can cause multitudes of assertion failures as the data
{"name":"55e495afe4b0f78e3509e00c"} seems to overwrite random
locations in shared memory causing all sorts of unpredictable
havoc depending on what it overwrote.
Often you will see the string data in registers that were used
at the time of the failures. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users have BSON data type and using Index on BSON data keys *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.09.2015
30.12.2015
30.12.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC6
|
| Problem solved according to the fixlist(s) of the following version(s) |
