microsoft / microsoft/sql-server-samples
Can not search on single letter and 2 letter words in FULL TEXT SEARCH
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
My data contains a column as "description" and I have a value in that particular column as "B B I C QUICK BLND FF VAN YGRT 3 GL".
I have created a full-text search index on the particular column description.
When I tried to make a search query using 'CONTAINS' with 'C', 'I', 'GL', and 'FF', it doesn't give me any search results.
My query syntax is like, ---where CONTAINS(description, "C")---.
Secondly, what is the latest version of mssql-fts ?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the reported CONTAINS(description, "C") query against the described full-text index and values. Check the SQL Server full-text search behavior for single- and two-letter terms, then determine how the question about the latest mssql-fts version should be addressed. Done means the behavior and supported version are documented or the issue is clearly resolved.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, search
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100