SQLite cursor.description is not DB-API compatible

[CharlieX]

BPO	15460

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = None
closed_at = <Date 2012-07-27.19:32:30.076>
created_at = <Date 2012-07-26.18:39:01.087>
labels = ['type-bug', 'docs']
title = 'SQLite cursor.description is not DB-API compatible'
updated_at = <Date 2012-07-27.19:32:30.074>
user = 'https://bugs.python.org/CharlieX'

bugs.python.org fields:

activity = <Date 2012-07-27.19:32:30.074>
actor = 'ghaering'
assignee = 'docs@python'
closed = True
closed_date = <Date 2012-07-27.19:32:30.076>
closer = 'ghaering'
components = ['Documentation']
creation = <Date 2012-07-26.18:39:01.087>
creator = 'CharlieX'
dependencies = []
files = []
hgrepos = []
issue_num = 15460
keywords = []
message_count = 2.0
messages = ['166498', '166602']
nosy_count = 4.0
nosy_names = ['ghaering', 'docs@python', 'tshepang', 'CharlieX']
pr_nums = []
priority = 'normal'
resolution = 'wont fix'
stage = None
status = 'closed'
superseder = None
type = 'behavior'
url = 'https://bugs.python.org/issue15460'
versions = []

[CharlieX]

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.

[ghaering]

SQLite's columns aren't typed, only SQLite values are. So it's entirely possible for the same column to have different types, like the NULL type, the INTEGER type and the TEXT type.

It's thus impossible to give meaningful type information in a SQLite3 DB-API module. That's why it's set to None instead.