Informix - Problembeschreibung
Problem IT08810 | Status: Geschlossen |
NEED DOCUMENTATION THAT STATES THE SUPPORTED WAY OF CREATING BSON INDEXES | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Informix 12.10 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See Problem Conclusion * **************************************************************** | |
Local-Fix: | |
Lösung | |
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. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.05.2015 30.12.2015 30.12.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
12.10.xC6 |