[CALCITE-6138] Parser does not accept TIMESTAMP WITH TIME ZONE as a data type

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.36.0
• Fix Version/s: 1.37.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Mihai Budiu
• Created: 28/Nov/23 02:32
• Updated: 06/May/24 22:19
• Resolved: 15/Mar/24 02:35

Description

The current SQL grammar accepts either TIMESTAMP WITHOUT TIME ZONE or TIMESTAMP WITH LOCAL TIME ZONE. It does not accept the version without LOCAL: TIMESTAMP WITH TIME ZONE. This is a legal type in other SQL dialects, and it appears in the SQL 92 standard.

The Calcite documentation also lists the rejected type as a legal scalar type: https://calcite.apache.org/docs/reference.html#scalar-types

So there is a bug: either the compiler is wrong, or the documentation is wrong. The main question is "which one?"

Issue Links

• links to: GitHub Pull Request #3569