Search

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

Resolved
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)
0
User(s) can reproduce this bug
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 (expand)

Product Language

English

Version

SQL Server 2012 - Developer Edition

Category

SQL Engine

Operating System

Windows 7 Professional

Operating System Language

US English

Steps to Reproduce

Attached semantic search DB. Added full-text index to file_stream and name column of the filetables. file_Stream has the statistical semantics selected, when I run the query:

SELECT Title, keyphrase, score
FROM SEMANTICKEYPHRASETABLE(Table Name, *)AS SKP
WHERE SKP.keyphrase = 'Keyword'

ORDER BY score DESC

I receive the error

Actual Results

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

Expected Results

Semantic stats results for a search for a keyword.

Platform

 

Virtualization

 
File Attachments
0 attachments
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.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement