Semantickeyphrasetable(filetable, *) returns error "Incorrect syntax near '*'" - by Koolaidbomber

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 765775 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/2/2012 11:44:48 AM
Access Restriction Public


I added a Semantic index to SQL Server 2012 Filestable and when I reun the fully query I recieved an error.

SELECT Title, keyphrase, score
 WHERE SKP.keyphrase = 'Keyword'

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '*'.

This error occurs on all the Filestable I have and there are indexed with semantic checked off. 

Sign in to post a comment.
Posted by Microsoft on 4/23/2013 at 8:24 PM
Hi Crystal,

We have seen one more other report of this error message. Unfortunately, we cannot reproduce it in our environment and the other report had two versions of the same database running without any differences.

After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product.

Best regards
Posted by Koolaidbomber on 10/25/2012 at 10:35 AM
Oh and yes, I do have a space between the " )AS ".

Any input would be helpful.

Thank you,
Posted by Koolaidbomber on 10/22/2012 at 9:23 PM
Hi Michael,

I used the term Table Name to keeps things generic, but I see it didn’t convey what the actual query was.

The actual query is:

SELECT Title, keyphrase, score
WHERE SKP.keyphrase = 'Logo'

And I am still receiving the same error, regardless using other tables.

Thank you,
Posted by Microsoft on 10/15/2012 at 4:25 PM
Hi Koolaidbomber

The error message you are seeing is a parse error which indicates that your statement is not correctly written. If I look at your statement, I see you use Table Name as the name of the table which would not parse correctly (although I think for that value it would give a different parse error).

Can you please check your statement again for the correct syntax and if you cannot see what may be wrong, feel free to add the exact statement you are seeing a problem with.

Please let me know if that works for you.

Best regards