Yes, you are right. I am using an older SQLite version in Python: 3.8.6. I will update and check that.
Thanks. -----Ursprüngliche Nachricht----- Von: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Stephan Beal Gesendet: Donnerstag, 21. Juli 2016 10:57 An: SQLite mailing list Betreff: Re: [sqlite] [Spellfix] Inexplicable discrepancy concerning query results On Thu, Jul 21, 2016 at 10:54 AM, Adamek, Jochen (CQTN) < jochen.ada...@carmeq.com> wrote: > 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? > It sounds to me like your python and local sqlite shell are using different sqlite versions. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users