Skip to content

bpo-44958: Only reset sqlite3 statements when needed #27844

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
pablogsal merged 16 commits into from
Sep 21, 2021
Merged

bpo-44958: Only reset sqlite3 statements when needed #27844

Changes from 1 commit
Commits
Show all changes
16 commits
Select commit Hold shift + click to select a range
99adc05
bpo-44958: Only reset sqlite3 statements when needed
Aug 19, 2021
2f8cb23
We don't use the return value of pysqlite_statement_reset
Aug 20, 2021
e6e4973
If possible, avoid resetting unused statements
Aug 20, 2021
df769c3
SQLITE_STMTSTATUS_RUN is available from 3.20.0 and onwards
Aug 20, 2021
cbcd640
Use sqlite3_stmt pointer iso. deref'ing self when calling sqlite3_reset
Aug 20, 2021
fe0fd6f
Merge branch 'main' into sqlite-optimise-resets
Aug 22, 2021
0633095
Sync with 'main' bco. GH-27884
Aug 25, 2021
06e242c
pysqlite_statement_reset result() is never used => return void
Aug 25, 2021
747000c
Sync with `main` bco. GH-27942
Aug 25, 2021
4ad7e99
Make sure we reset statements both at cursor dealloc and when the
Sep 6, 2021
1bbb31f
Harden test_type_map_usage()
Sep 6, 2021
73e1ddb
Add regression tests for stmt exit from cursor
Sep 6, 2021
9684593
Merge branch 'main' into sqlite-optimise-resets
Sep 6, 2021
41410e0
Merge branch 'main' into sqlite-optimise-resets
Sep 14, 2021
ebebdb7
Merge branch 'main' into sqlite-optimise-resets
Sep 20, 2021
c84311e
Test that datamodifying select queries are marked readonly
Sep 20, 2021
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Test that datamodifying select queries are marked readonly 
#27844 (comment)
  • Loading branch information
Erlend E. Aasland committed Sep 20, 2021
commit c84311e8a3655b4037459db2925c2f03861f074a
14 changes: 14 additions & 0 deletions Lib/sqlite3/test/test_regression.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -456,6 +456,20 @@ def test_table_lock_cursor_dealloc(self):
con.execute("drop table t")
con.commit()

def test_table_lock_cursor_non_readonly_select(self):
con = sqlite.connect(":memory:")
con.execute("create table t(t)")
con.executemany("insert into t values(?)", ((v,) for v in range(5)))
con.commit()
def dup(v):
con.execute("insert into t values(?)", (v,))
return
con.create_function("dup", 1, dup)
cur = con.execute("select dup(t) from t")
del cur
con.execute("drop table t")
con.commit()


if __name__ == "__main__":
unittest.main()