kaykay-dv / pocketsearch

A simple full-text search library for Python using SQLite and its FTS5 extension
https://pocketsearch.readthedocs.io/en/latest/
MIT License
1 stars 0 forks source link

Combining queries using | operator results in SQL error #26

Closed kaykay-dv closed 1 year ago

kaykay-dv commented 1 year ago

The following query will result in an SQL error:

q1 = self.pocket_search.search(text="paris") | self.pocket_search.search(text="england")
for item in q1.values("id","text"):
    print(item)

Result:

sqlite3.OperationalError: SELECTs to the left and right of UNION ALL do not have the same number of result columns
kaykay-dv commented 1 year ago

This is feature is deprecated from 0.9.0 onwards.