This issue tracker has been migrated to GitHub ,
and is currently read-only.
For more information,
see the GitHub FAQs in the Python's Developer Guide.
Created on 2012年07月26日 18:39 by CharlieX, last changed 2022年04月11日 14:57 by admin. This issue is now closed.
| Messages (2) | |||
|---|---|---|---|
| msg166498 - (view) | Author: Charlie Clark (CharlieX) | Date: 2012年07月26日 18:39 | |
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. |
|||
| msg166602 - (view) | Author: Gerhard Häring (ghaering) * (Python committer) | Date: 2012年07月27日 19:32 | |
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. |
|||
| History | |||
|---|---|---|---|
| Date | User | Action | Args |
| 2022年04月11日 14:57:33 | admin | set | github: 59665 |
| 2012年07月27日 19:32:30 | ghaering | set | status: open -> closed resolution: wont fix messages: + msg166602 |
| 2012年07月27日 18:51:49 | pitrou | set | nosy:
+ ghaering |
| 2012年07月27日 18:43:27 | tshepang | set | nosy:
+ tshepang, docs@python components: + Documentation, - Library (Lib) assignee: docs@python |
| 2012年07月26日 18:39:01 | CharlieX | create | |