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.

Author sockonafish
Recipients sockonafish
Date 2009-01-29.23:53:28
SpamBayes Score 8.611251e-06
Marked as misclassified No
Message-id <1233273211.24.0.156313751238.issue5105@psf.upfronthosting.co.za>
In-reply-to
Content
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.
History
Date User Action Args
2009-01-29 23:53:31sockonafishsetrecipients: + sockonafish
2009-01-29 23:53:31sockonafishsetmessageid: <1233273211.24.0.156313751238.issue5105@psf.upfronthosting.co.za>
2009-01-29 23:53:29sockonafishlinkissue5105 messages
2009-01-29 23:53:28sockonafishcreate