[issue15460] SQLite cursor.description is not DB-API compatible

[Charlie Clark]

New submission from Charlie Clark <charlie.clark at clark-consulting.eu>:

It says in the docs:
"""This read-only attribute provides the column names of the last query. To remain compatible with the Python DB API, it returns a 7-tuple for each column where the last six items of each tuple are None."""

According to the DB-API, however, the first two items, name and type, must be specified:
"""
The first two items (name and type_code) are mandatory, the other five are optional and are set to None if no meaningful values can be provided.
"""

Even with it's limited number of types SQLite is typed and should be able to return the type for column.

----------
components: Library (Lib)
messages: 166498
nosy: CharlieX
priority: normal
severity: normal
status: open
title: SQLite cursor.description is not DB-API compatible
type: behavior

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue15460>
_______________________________________