[CALCITE-5405] MongoDB: Invalid TIMESTAMP conversion

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.32.0
• Fix Version/s: 1.33.0
• Component/s: mongodb-adapter
• Labels: pull-request-available

Language

java

• Assignee: Tim Nieradzik
• Reporter: Tim Nieradzik
• Created: 29/Nov/22 13:27
• Updated: 07/Feb/23 22:33
• Resolved: 13/Jan/23 00:56

Description

When using the MongoDB adapter, the following conversion does not work as expected:

cast(_MAP['date'] as TIMESTAMP)

The resulting date is always 1970-01-01 and only the fractional seconds are set.

Issue Links

• links to: GitHub Pull Request #2990
• links to: GitHub Pull Request #2990