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 serhiy.storchaka
Recipients Dennis Sweeney, berker.peksag, eric.smith, ravi-misra, serhiy.storchaka
Date 2020-09-05.22:39:11
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <1599345551.32.0.594431948042.issue41724@roundup.psfhosted.org>
In-reply-to
Content
PARSE_DECLTYPES does not work for generated fields. sqlite3_column_decltype() just returns NULL.

PARSE_COLNAMES works only when the column name contains the column type in square brackets. For generated fields sqlite3_column_name() returns the expression used to evaluate it, e.g. "max(d)". It does not contain needed information.

So we cannot do anything with this because SQLite just does not provide information needed to determine the type.

It would be worth to document this limitation.
History
Date User Action Args
2020-09-05 22:39:11serhiy.storchakasetrecipients: + serhiy.storchaka, eric.smith, berker.peksag, Dennis Sweeney, ravi-misra
2020-09-05 22:39:11serhiy.storchakasetmessageid: <1599345551.32.0.594431948042.issue41724@roundup.psfhosted.org>
2020-09-05 22:39:11serhiy.storchakalinkissue41724 messages
2020-09-05 22:39:11serhiy.storchakacreate