Unable to create TextScoreIndex

[tikiram]

Hi, I was setting up some collections and I'm able to create a UniqueIndex, but when I use TextScoreIndex, I get this error

MongoClient.MongoGenericErrorReply(ok: 0, errorMessage: Optional("Error in specification { name: \"email_search\", key: { email: { $meta: \"textScore\" } } } :: caused by :: Values in v:2 index key pattern cannot be of type object. Only numbers > 0, numbers < 0, and strings are allowed."), code: Optional(67), codeName: Optional("CannotCreateIndex"))

I'm using mongodb-community 8.0.8, is this a bug or something that has to be fixed?

[Joannis]

This is most likely an existing Document in your database that doesn't match the requirements needed to create the index

[tikiram]

I noticed MongoKitten uses { myField: { $meta: "textScore" } } to create the text index but I didn't find MongoDB docs about using this expression on index creation (although it is used on aggregation and find operations), instead I found this createIndex({ myField: "text" });

https://www.mongodb.com/docs/manual/core/indexes/index-types/index-text/create-text-index/

This workaround works

SortedIndex(named: "email_search", field: "email", order: .custom("text"))

One limitation of Mongo is that a collection can have at most one text index, but it can have multiple fields defined in a single text index (up to 32 fields) maybe I can help with this in the future

Let me know your thoughts