[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

miss-islington added the comment: New changeset 8fcc1474ef5d819c144309e048e71e6013544063 by Miss Islington (bot) in branch '3.9': bpo-40784: Fix sqlite3 deterministic test (GH-20448) https://github.com/python/cpython/commit/8fcc1474ef5d819c144309e048e71e6013544063 -- __

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

miss-islington added the comment: New changeset 00a240bf7f95bbd220f1cfbf9eb58484a5f9681a by Miss Islington (bot) in branch '3.8': bpo-40784: Fix sqlite3 deterministic test (GH-20448) https://github.com/python/cpython/commit/00a240bf7f95bbd220f1cfbf9eb58484a5f9681a -- __

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

STINNER Victor added the comment: Python 3.8 and Python 3.9 are also affected, I created backports. Python 3.7 is not affected: deterministic parameter was added to Python 3.8. https://docs.python.org/dev/library/sqlite3.html#sqlite3.Connection.create_function -- versions: +Python 3.8

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

Change by miss-islington : -- pull_requests: +19757 pull_request: https://github.com/python/cpython/pull/20513 ___ Python tracker ___ __

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

Change by miss-islington : -- nosy: +miss-islington nosy_count: 6.0 -> 7.0 pull_requests: +19756 pull_request: https://github.com/python/cpython/pull/20512 ___ Python tracker _

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

Change by Berker Peksag : -- resolution: -> fixed stage: patch review -> resolved status: open -> closed type: -> behavior ___ Python tracker ___

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

Berker Peksag added the comment: New changeset c610d970f5373b143bf5f5900d4645e6a90fb460 by Erlend Egeberg Aasland in branch 'master': bpo-40784: Fix sqlite3 deterministic test (GH-20448) https://github.com/python/cpython/commit/c610d970f5373b143bf5f5900d4645e6a90fb460 -- nosy: +berk

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

Change by Erlend Egeberg Aasland : -- keywords: +patch pull_requests: +19702 stage: -> patch review pull_request: https://github.com/python/cpython/pull/20448 ___ Python tracker _

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

Erlend Egeberg Aasland added the comment: Hi, folks. I took the liberty to create a PR for this; hope you don't mind. I've used partial indices to test deterministic behaviour. https://www.sqlite.org/partialindex.html -- ___ Python tracker

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

Change by Erlend Egeberg Aasland : -- nosy: +erlendaasland ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: ht

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

Petr Viktorin added the comment: Indeed. The SQLite documentation talks about the limitations that non-deterministic functions have, not about deterministic functions being memoized: https://www.sqlite.org/deterministic.html The flag would be better tested e.g. with a CHECK constraint: http

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

Benjamin Peterson added the comment: This seems like it's testing an implementation detail. -- nosy: +benjamin.peterson ___ Python tracker ___

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

STINNER Victor added the comment: Oh, I also tried with a function taking one argument and then call it twice by running "SELECT deterministic(1)" query twice: again, the mock is also called twice. -- ___ Python tracker

[issue40784] test_sqlite: CheckFuncDeterministic() fails with SQLite 3.32

New submission from STINNER Victor : With SQLite 3.32, test_sqlite fails with: FAIL: CheckFuncDeterministic (sqlite3.test.userfunctions.FunctionTests) -- Traceback (most recent call last): File "/builddir/build/BUILD/Python-