[DOCS-9901] Add restriction to Compound Index: text fields must be adjacent Created: 16/Feb/17  Updated: 30/Oct/23  Resolved: 03/Nov/17

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: Server_Docs_20231030

Type: Task Priority: Minor - P4
Reporter: Andrew Ryder (Inactive) Assignee: Stennie Steneker (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

https://docs.mongodb.com/manual/core/index-text/#compound-index


Issue Links:
Related
related to CSHARP-1917 MongoMembershipProvider throwing 'Com... Closed
Participants:
Days since reply: 6 years, 14 weeks, 6 days ago
Story Points: 0.1

 Description   

RE: https://docs.mongodb.com/manual/core/index-text/#compound-index

Additional restriction should appear under "compound index":

  • When creating a compound index, all "text" fields must be adjacent.

Example of the error one gets otherwise:

>db.text.createIndex({a:"text",b:1,c:"text"})
{
        "ok" : 0,
        "errmsg" : "'text' fields in index must all be adjacent",
        "code" : 67,
        "codeName" : "CannotCreateIndex"
}

Also, there is a self-link in this sentence:

See also Text Index and Sort for additional limitations.



 Comments   
Comment by Githook User [ 03/Nov/17 ]

Author:

{'name': 'Stephen Steneker', 'username': 'stennie', 'email': 'stennie@cpan.org'}

Message: DOCS-9901: Add restriction to Compound Index: text fields must be adjacent
Branch: v3.4
https://github.com/mongodb/docs/commit/eeb1ab81db508be2c05745f32a0abdf940d13835

Comment by Githook User [ 03/Nov/17 ]

Author:

{'name': 'Stephen Steneker', 'username': 'stennie', 'email': 'stennie@cpan.org'}

Message: DOCS-9901: Add restriction to Compound Index: text fields must be adjacent
Branch: master
https://github.com/mongodb/docs/commit/9a64879601c0f8a1e14b4f8e7bbee87029b789ae

Generated at Thu Feb 08 07:59:24 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.