[CALCITE-2339] JDBC adapter should transform timestamp arithmetic for target database

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: jdbc-adapter
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 30/May/18 22:12
• Updated: 26/Oct/22 18:07

Description

JDBC adapter should transform timestamp arithmetic for target database.

There are two ways in Calcite to add intervals to timestamps: the TIMESTAMP_ADD function and the "<timestamp> + <interval>" operator.

The attached document (authored by James Doung) describes their pros and cons.

Issue Links

• depends upon: CALCITE-2836 Remove maven-compiler-plugin from calcite-plus module pom.xml
• is blocked by: CALCITE-2359 Inconsistent behavior when casting interval literals to integer
• is depended upon by: CALCITE-2337 Release Calcite 1.17.0
• links to: GitHub Pull Request #721
• links to: GitHub Pull Request #2466
• links to: GitHub Pull Request #2467