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 tony.wu
Recipients tony.wu
Date 2020-09-22.00:43:12
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <1600735393.55.0.581457090913.issue41829@roundup.psfhosted.org>
In-reply-to
Content
Supplying a sequence or sqlite3.Row objects to sqlite3.Connection.executemany will cause the Row objects to be interpreted as Sequences instead of Mappings even if the statement to be executed uses named parameter substitution.

That is, values in the Rows are accessed using their numerical indices instead of column names.

This script demonstrate how this is unexpected behavior.

Issue found in Python 3.8.5 and 3.7.6.
History
Date User Action Args
2020-09-22 00:43:13tony.wusetrecipients: + tony.wu
2020-09-22 00:43:13tony.wusetmessageid: <1600735393.55.0.581457090913.issue41829@roundup.psfhosted.org>
2020-09-22 00:43:13tony.wulinkissue41829 messages
2020-09-22 00:43:13tony.wucreate