INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Index was created using below syntax to resolve performance 
issue. 
 
create index "informix".guias_id_nr_lote_id_nr_guiaprestador 
    on "ifxjson".guias 
("informix".bson_value_lvarchar(data,'identificador.numeroLote' 
    ) 
,"informix".bson_value_lvarchar(data,'identificador.numeroGuiaPr 
estador' 
    ) ) using btree  in datadbs extent size 51200 
     next size 51200  collection '{ "ns" : { "name" 
:"orizon.guias" } , "idx" : { "ns" : "orizon.guias" , "key" : { 
"identificador.numeroLote" : [ 1.0 ,"$string" ], 
"identificador.numeroGuiaPrestador" : [ 1.0 , "$string" ] 
},"name" :"orizon.guias" , "v" : 1 , "index" 
:"id_nr_lote_id_nr_guiaprestador" }}' 
    ; 
 
However, then the noSQL application started returning 
NullExceptions when one would query elements that were not in 
the collection: 
 
Dropping the above index, and then creating the index via 
jsonListener resolves the issue: 
"db.guias.ensureIndex({ "identificador.numeroLote" : [ 1 , 
"$string" ], "identificador.numeroGuiaPrestador" : [ 1 , 
"$string" ] }) " 
 
Need a supported way of bson index creation documented

**************************************************************** 
* USERS AFFECTED:                                              * 
* Informix 12.10                                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See Problem Conclusion                                       * 
****************************************************************

If you plan to query JSON and BSON data through the wire 
listener, you must create your database objects, such as 
collections and indexes, through the wire listener. You can use 
SQL statements to query JSON and BSON data whether you created 
your database objects through the wire listener or with SQL 
statements.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.05.2015
30.12.2015
30.12.2015