Opened 11 months ago

Closed 7 months 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: master
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 Changed 11 months ago by Simon Charette

Triage Stage: UnreviewedAccepted

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

Last edited 11 months ago by Simon Charette (previous) (diff)

comment:2 Changed 11 months ago by Sergey Fedoseev

comment:3 Changed 11 months ago by Sergey Fedoseev

Has patch: set

comment:4 Changed 11 months ago by Mariusz Felisiak

Needs documentation: set
Owner: changed from nobody to Sergey Fedoseev
Status: newassigned

comment:5 Changed 7 months ago by Mariusz Felisiak

Needs documentation: unset

comment:6 Changed 7 months ago by Mariusz Felisiak <felisiak.mariusz@…>

Resolution: fixed
Status: assignedclosed

In 026719cf:

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

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