SQL Server: error with spaces doing full-text search #2913

Closed
ebruchez opened this Issue Sep 1, 2016 · 4 comments

Projects

None yet

2 participants

@ebruchez
Collaborator
ebruchez commented Sep 1, 2016

If you enter a string such as "abc def ghi", you will get this error:

Syntax error near 'def' in the full-text search condition 'abc def ghi'

It seems that with SQL server, we must process the search string by adding quotes. See this SO question.

+1 from customer

@ebruchez ebruchez added the Form Runner label Sep 1, 2016
@avernet avernet was assigned by ebruchez Sep 1, 2016
@avernet
Collaborator
avernet commented Sep 1, 2016

Was this with 2016.2? With SQL Server, from what I see in the code, we're now doing contains(xml, ?) with the ? replaced by the string the user typed using a PreparedStatement.

@ebruchez
Collaborator
ebruchez commented Sep 1, 2016

Issue reported with 4.8.2. Did we change the code since then?

@avernet
Collaborator
avernet commented Sep 1, 2016

Search was moved from XPL to Scala in 2016.2, but the SQL itself shouldn't have changed substantially, and I'm able to reproduce this with 2016.2.

@avernet avernet added this to the 2016.2.1 milestone Sep 1, 2016
@avernet
Collaborator
avernet commented Sep 1, 2016
@avernet avernet closed this Sep 1, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment