search

hideaki-t / sqlite-fts-python

A Python binding of SQLite Full Text Search Tokenizer
MIT License
45 stars 11 forks source link

Query with double quotes and OR operator #36

Closed Doxtur closed 8 months ago

Doxtur commented 9 months ago

Hello! A query with the OR operator does not work if double quotes are used. test_base.py:

r = c.execute(
    "SELECT * FROM docs WHERE docs MATCH '\"binding\" OR \"あいうえお\"'"
).fetchall()
assert len(r) == 2
r = c.execute(
    "SELECT * FROM docs WHERE docs MATCH '\"provides binding\" OR あいうえお'"
).fetchall()
assert len(r) == 2
hideaki-t commented 9 months ago

THank you for the report. I will take a look.