[PYTHON-1824] Add ability to workaround Python's datetime range limitations - MongoDB Jira

XML

Word

Printable

JSON

Details

Type: Epic
Status: Closed
Priority: Major - P3
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 4.3
Component/s: None
Labels:
- neweng

Original Estimate:
2
Cost to Date:
1
Final Cost:
2
Cost Threshold %:
100
Detailed Project Statuses:
Hide

2022-07-27: Setting to Closed

Engineer: Ben Warner

Status Update

Completed - FixVersion Python 4.3

Rationale for Delays

None

Risks

None

2022-07-12: Setting target date to: 2022-07-22

Engineer: Ben Warner

Status Update

Ben started working on this Epic last week and most of the implementation is in code review

Remaining- Implement extended datetime range in Python and Document it

Rationale for Delays

None

Risks

None
Show
2022-07-27: Setting to Closed Engineer: Ben Warner Status Update Completed - FixVersion Python 4.3 Rationale for Delays None Risks None 2022-07-12: Setting target date to: 2022-07-22 Engineer: Ben Warner Status Update Ben started working on this Epic last week and most of the implementation is in code review Remaining- Implement extended datetime range in Python and Document it Rationale for Delays None Risks None

Description

PyMongo's bson module automatically decodes the bson UTC datetime type into a Python datetime. This is problematic because Python's datetimes have a stricter range of possible values and can lead to InvalidBSON errors when decoding a technically valid bson type, eg ~~PYTHON-1822~~.

We could avoid this class of decoding errors by offering a new date representation that stores the bson UTC datetime's int64 offset without decoding it into a datetme.

Attachments

Issue Links

causes

SERVER-43055 Prevent an exception from being thrown when gdb prints a BSONObj with datetimes beyond datetime.MAXYEAR

Closed

is duplicated by

PYTHON-2656 Mongodb allows storing negative Dates, but pymongo cannot parse this value.

Closed

is related to

PYTHON-1822 Test failure - Database.current_op fails decoding a UTC datetime

Closed

PYTHON-3398 Benchmark datetime decoding performance

Closed

PYTHON-3392 Change default datetime_conversion to DATETIME_AUTO

Backlog

Activity

People

Assignee:: Ben Warner (Inactive)

Reporter:: Shane Harvey

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: Apr 19 2019 06:38:29 PM UTC

Updated:: Aug 12 2022 06:13:57 PM UTC

Resolved:: Aug 04 2022 08:25:50 PM UTC

Start date:: 05/Jul/22

End date:: 22/Jul/22

Calendar Time:: 2 weeks, 3 days