Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FTS5 Query quoting for the "Match" parameter doesn't quote phrases correctly #33

Open
jackpal opened this issue Oct 27, 2024 · 0 comments

Comments

@jackpal
Copy link

jackpal commented Oct 27, 2024

The FTS5 search query Match syntax allows phrases to be searched for by, among other choices, using double quotes:

... MATCH '"one two three"'
... MATCH 'one + two + three'
... MATCH '"one two" + three'
... MATCH 'one.two.three'

If I turn on .debugPrintQueryParameterValues, I see that the string "Hi there" gets quoted as:

MATCH '""Hi" "there""'

I think it should be quoted as

MATCH '"Hi there"'

This is with the current main branch head version of Blackbird.

There is a workaround, which is to use one of the alternative syntaxes, such as Hi.there.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant