Hello, using the spellfix<https://www.sqlite.org/spellfix1.html>-functionality in SQLite, I realized, that in Python, the following query leads to different results compared to the direct execution with SQLite.
Code fragment in Python: .... qS = "select * from pf where word MATCH 'ro:|z@nStr|?a|s@' and scope=8 and rank=14"; cS = connection.execute(qS) .... This leads to: ro:|z=n|StY|k6|ve:k raI|C=n|StaI|n6|ho:f ro:|z=n|Stra:|s@ When I execute the same query directly with SQLite, I get the following result: ro:|z=n|Stra:|s@ re:|z=n|Stra:|s@ rOY|z=n|Stra:|s@ The first 4 rows have a different score and a different distance. This discrepancy occurs with most example queries. But changing the scope value of the query in my Python code, it changes the result, so it is not the case, that SQLite does not process the scope operation via the Python-SQLite interface. Any idea? Kind regards Jochen Adamek _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
