[issue21465] sqlite3 Row can return duplicate keys when using adapters

Erlend E. Aasland added the comment: Closing this for now. If anyone disagrees, please reopen :) -- resolution: -> not a bug stage: -> resolved status: pending -> closed ___ Python tracker

[issue21465] sqlite3 Row can return duplicate keys when using adapters

Erlend E. Aasland added the comment: AFAICS, this has nothing to do with adapters; you'll get duplicate keys just by executing 'select 1 as "token", 2 as "token"'. If you want the columns to have unique names, you should assign them unique names. At most, there could be a sentence about this

[issue21465] sqlite3 Row can return duplicate keys when using adapters

Change by Mark Lawrence : -- nosy: -BreamoreBoy ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: https://mail

[issue21465] sqlite3 Row can return duplicate keys when using adapters

Change by Karthikeyan Singaravelan : -- nosy: +xtreak ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: https:/

[issue21465] sqlite3 Row can return duplicate keys when using adapters

Changes by Gerhard Häring : -- assignee: -> ghaering ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: https://m

[issue21465] sqlite3 Row can return duplicate keys when using adapters

Changes by Antoine Pitrou : -- nosy: +ghaering ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: https://mail.pyt

[issue21465] sqlite3 Row can return duplicate keys when using adapters

New submission from Mark Lawrence: Code adopted from here https://docs.python.org/3/library/sqlite3.html#default-adapters-and-converters. import sqlite3 import datetime con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES|sqlite3.PARSE_COLNAMES) con.row_factory = sqlite3.Row