Mihai Budiu created CALCITE-6138:
------------------------------------
Summary: Parser does not accept TIMESTAMP WITH TIME ZONE as a data
type
Key: CALCITE-6138
URL: https://issues.apache.org/jira/browse/CALCITE-6138
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.36.0
Reporter: Mihai Budiu
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?"
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
