• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1015
  • Last Modified:

SharePoint 2010 full-text search - is there a minimum word length?

Hi,

 

On SharePoint 2010, when doing a full-text search with a predicate like CONTAINS('"apple re*"') we get an exception saying that "the query was too complex to be executed" (HRESULT=0x80041606).

 

Searching for "apple*" returns results, so we're wondering if the problem occurs because the second word ("re") is too small. This problem, though, does not occur in every SP installation (it seems to occur only when the quantity of data is very large).

 

Is there a minimum word length for full-text searches in SharePoint? Apparently other engines (like MySQL) do have a configurable minimum word length (3 characters by default).

 

Could this limit be related to the quantity of data in the installation somehow? Or any other setting?
0
Netcompany
Asked:
Netcompany
  • 3
1 Solution
 
Justin SmithSr. System EngineerCommented:
Wild card searches only work when used with a query property.  For example, AUTHOR=Jon D*

0
 
Justin SmithSr. System EngineerCommented:
Sorry, it seems that 2010 has improved that capability, and you can now do wildcard searches without specifiying a property or keyword.  

I haven't heard of a minimum amount of characters.  If you remove the CONTAINS and search for "apple re*", do you recieve the same error?
0
 
Justin SmithSr. System EngineerCommented:
Take a look here.  CONTAINS isn't a supported statement.

http://msdn.microsoft.com/en-us/library/ms494614.aspx
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now