Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Bug
ID: 765775
Opened: 10/2/2012 11:44:48 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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
FROM SEMANTICKEYPHRASETABLE(Table Name, *)AS SKP
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.

Details
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
Michael
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,
Crystal
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
FROM SEMANTICKEYPHRASETABLE(Document_Files, *)AS SKP
WHERE SKP.keyphrase = 'Logo'

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

Thank you,
Crystal
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
Michael
Sign in to post a workaround.