New submission from Brandon Adams <[email protected]>: When using sqlite3.Row as the row_factory for a sqlite3 connection and performing a SQL join that returns rows from two or more tables with identical column names, the returned sqlite3.Row object contains duplicate keys. Subsequently, when trying to access values by key, only the value contained in the lowest numbered index matching the key is returned. Additionally, attempting to use the keys returned to create a new table in the database fails due to a duplicate column name error.
A better behavior would be for the sqlite3.Row object's indices to be prefixed with table names for cases in which a query produces results from two or more tables. ---------- components: Library (Lib) messages: 80798 nosy: sockonafish severity: normal status: open title: sqlite3.Row class, handling duplicate column names resulting from a SQL join type: behavior versions: Python 2.6 _______________________________________ Python tracker <[email protected]> <http://bugs.python.org/issue5105> _______________________________________ _______________________________________________ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
