Opened 5 years ago

Closed 5 years ago

#31030 closed Cleanup/optimization (fixed)

register SQLite functions as deterministic on Python 3.8

Reported by: Sergey Fedoseev Owned by: Sergey Fedoseev
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords: sqlite
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

On Python 3.8 deterministic parameter was added to ​sqlite3.Connection.create_function() , it should be used when possible to allow SQLite to perform additional optimizations.

Change History (6)

comment:1 by Simon Charette, 5 years ago

Triage Stage: Unreviewed → Accepted

We'll want to makes to not do so for functions using global or connection state (e.g. timezone).

Last edited 5 years ago by Simon Charette (previous) (diff)

comment:2 by Sergey Fedoseev, 5 years ago

​PR

comment:3 by Sergey Fedoseev, 5 years ago

Has patch: set

comment:4 by Mariusz Felisiak, 5 years ago

Needs documentation: set
Owner: changed from nobody to Sergey Fedoseev
Status: new → assigned

comment:5 by Mariusz Felisiak, 5 years ago

Needs documentation: unset

​PR

comment:6 by Mariusz Felisiak <felisiak.mariusz@…>, 5 years ago

Resolution: → fixed
Status: assigned → closed

In 026719cf:

Fixed #31030 -- Registered SQLite functions as deterministic on Python 3.8+.

Note: See TracTickets for help on using tickets.
Back to Top