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?
NetcompanyAsked:
Who is Participating?
 
Justin SmithConnect With a Mentor Sr. 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.