New submission from Dingyuan Wang:

We have the sqlite3.set_authorizer function, where the first argument to its 
callback is one of the Authorizer Action Codes that the SQLite documentations 
defines[1]. However, the constants in the sqlite3 module is not up to date. The 
code in _sqlite/module.c haven't been updated since June, 2006.

According to the SQLite Changelog[2] and digging through the history,

* 2006-10-09 (3.3.8) added SQLITE_FUNCTION
* 2009-01-12 (3.6.8) added SQLITE_SAVEPOINT
* 2014-02-03 (3.8.3) added SQLITE_RECURSIVE

The constants above should be present in the module. The documentation[3] says, 
"All necessary constants are available in the sqlite3 module."


components: Library (Lib)
files: sqlite3.patch
keywords: patch
messages: 283363
nosy: gumblex
priority: normal
severity: normal
status: open
title: sqlite3 authorizer codes constants not up to date
type: enhancement
versions: Python 2.7, Python 3.3, Python 3.4, Python 3.5, Python 3.6, Python 3.7
Added file:

Python tracker <>
Python-bugs-list mailing list

Reply via email to