sqlite3 Cursor.description doesn't set type_code

[wesclemens]

BPO	11691
Files	sqlite3_type_code_py27.diff: This patch adds type_code to Cursor.description Python 2.7 sqlite3_type_code_py33.diff: This patch adds type_code to Cursor.description Python 3.3

^{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 2015-08-19.09:43:29.994>
created_at = <Date 2011-03-27.04:16:14.523>
labels = ['type-bug', 'library', 'docs']
title = "sqlite3 Cursor.description doesn't set type_code"
updated_at = <Date 2015-08-19.09:43:29.992>
user = 'https://bugs.python.org/wesclemens'

bugs.python.org fields:

activity = <Date 2015-08-19.09:43:29.992>
actor = 'ghaering'
assignee = 'ghaering'
closed = True
closed_date = <Date 2015-08-19.09:43:29.994>
closer = 'ghaering'
components = ['Documentation', 'Library (Lib)']
creation = <Date 2011-03-27.04:16:14.523>
creator = 'wesclemens'
dependencies = []
files = ['21421', '21422']
hgrepos = []
issue_num = 11691
keywords = ['patch']
message_count = 3.0
messages = ['132289', '132290', '248824']
nosy_count = 3.0
nosy_names = ['ghaering', 'docs@python', 'wesclemens']
pr_nums = []
priority = 'normal'
resolution = 'wont fix'
stage = None
status = 'closed'
superseder = None
type = 'behavior'
url = 'https://bugs.python.org/issue11691'
versions = ['Python 2.7', 'Python 3.3']

[wesclemens]

The DB API Spec 2.0 (PEP-249) clearly requires that column name and type_code be set as the first two values in Cursor.description the other 5 attributes are optional. The sqlite3 module doesn't set type_code.

[wesclemens]

The patch for version 3.3 has a one line difference.

[ghaering]

There is no guarantee that all any column in a SQlite resultset always has the same type. That's why I decided to err on the side of setting the type code to "undefined".

Closing as wontfix.