[SERVER-12226] Cannot create compound index with text and descending Created: 31/Dec/13  Updated: 11/Jul/16  Resolved: 10/Feb/14

Status: Closed
Project: Core Server
Component/s: Text Search
Affects Version/s: 2.5.4
Fix Version/s: 2.6.0-rc0

Type: Bug Priority: Major - P3
Reporter: Sridhar Nanjundeswaran Assignee: J Rassi
Resolution: Done Votes: 0
Labels: 26qa
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

mongodb nightly from 12/30 on Windows 7 x64


Issue Links:
Related
related to DOCS-2689 pending Text Search features Closed
Operating System: ALL
Participants:

 Description   

Compound index with text and ascending succeed whereas descending fails.
db.coll1.ensureIndex(

{f1:"text",f2:1}

) succeeds

> db.coll2.ensureIndex(

{f1:"text",f2:-1}

)
{
"err" : "compound text index key suffix fields must have value 1",
"code" : 17290,
"n" : 0,
"connectionId" : 3,
"ok" : 1
}



 Comments   
Comment by Githook User [ 10/Feb/14 ]

Author:

{u'username': u'jrassi', u'name': u'Jason Rassi', u'email': u'rassi@10gen.com'}

Message: SERVER-12226 FTSSpec::fixSpec() text index suffix allow

{a:-1}

keys

Previously, only ascending keys were allowed in the key pattern
suffix for text indexes. Descending keys now allowed.
Branch: master
https://github.com/mongodb/mongo/commit/9f847a1a91a7f1861733ce6fe1617da89dd945c0

Generated at Thu Feb 08 03:27:57 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.