[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[Eric V. Smith]

Eric V. Smith  added the comment:

Thanks for the PR!

--
resolution:  -> fixed
stage: patch review -> resolved
status: open -> closed

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[Eric V. Smith]

Eric V. Smith  added the comment:


New changeset 24862b02dfd1e2843727f28fa2ba05828fdfa8de by Miss Islington (bot) 
in branch '3.8':
bpo-41724: Explain when the conversion is not possible with detect_types 
enabled (GH-23855) (GH-23863)
https://github.com/python/cpython/commit/24862b02dfd1e2843727f28fa2ba05828fdfa8de


--

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[Eric V. Smith]

Eric V. Smith  added the comment:


New changeset a34ab8188e0352e4066da4f79ed3cc24d1b61a63 by Miss Islington (bot) 
in branch '3.9':
bpo-41724: Explain when the conversion is not possible with detect_types 
enabled (GH-23855) (GH-23862)
https://github.com/python/cpython/commit/a34ab8188e0352e4066da4f79ed3cc24d1b61a63


--

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[miss-islington]

Change by miss-islington :


--
pull_requests: +22725
pull_request: https://github.com/python/cpython/pull/23863

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[miss-islington]

Change by miss-islington :


--
nosy: +miss-islington
nosy_count: 6.0 -> 7.0
pull_requests: +22724
pull_request: https://github.com/python/cpython/pull/23862

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[Eric V. Smith]

Eric V. Smith  added the comment:


New changeset 09a36cdfb7c22f44df45b44e5561776206bcedfb by sblondon in branch 
'master':
bpo-41724: Explain when the conversion is not possible with detect_types 
enabled (GH-23855)
https://github.com/python/cpython/commit/09a36cdfb7c22f44df45b44e5561776206bcedfb


--

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[Stéphane Blondon]

Change by Stéphane Blondon :


--
keywords: +patch
nosy: +sblondon
nosy_count: 5.0 -> 6.0
pull_requests: +22720
stage:  -> patch review
pull_request: https://github.com/python/cpython/pull/23855

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[Serhiy Storchaka]

Serhiy Storchaka  added the comment:

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.

--
nosy: +berker.peksag, serhiy.storchaka

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[Dennis Sweeney]

Dennis Sweeney  added the comment:

Here's a reproducer.

--
nosy: +Dennis Sweeney
Added file: https://bugs.python.org/file49447/reproducer.py

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue41724] SQLite returns "str" instead of "datetime.datetime" with aggregate queries.

[Eric V. Smith]

Eric V. Smith  added the comment:

[Adjusted title so that it displays correctly when not logged in. The text 
within less-than and greater-than was being dropped, probably because some 
piece of code didn't want to display unknown tags.]

--
nosy: +eric.smith
title: SQLite returns  instead of  with aggregate 
queries. -> SQLite returns "str" instead of "datetime.datetime" with aggregate 
queries.

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com