[
https://issues.apache.org/jira/browse/CALCITE-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723422#comment-17723422
]
Sergey Nuyanzin commented on CALCITE-4555:
------------------------------------------
Thanks for the feedback
submitted PR for that
for some reason Jira was not able to link it in automatic way...
> Invalid zero literal value is used for TIMESTAMP WITH LOCAL TIME ZONE type in
> RexBuilder
> ----------------------------------------------------------------------------------------
>
> Key: CALCITE-4555
> URL: https://issues.apache.org/jira/browse/CALCITE-4555
> Project: Calcite
> Issue Type: Bug
> Reporter: Leonard Xu
> Assignee: Sergey Nuyanzin
> Priority: Major
>
> The zero literal value for TIMESTAMP WITH LOCAL TIME ZONE type is used in
> `org.apache.calcite.rex.RexBuilder`
> {code:java}
> case TIMESTAMP_WITH_LOCAL_TIME_ZONE:
> return new TimestampString(0, 0, 0, 0, 0, 0);
> //TimestampString(int year, int month, int day, int h, int m, int s)
> {code}
> the month and day should never be zero, I think the zero value should be
> '1970-01-01 00:00:00'(epoch 0 second).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
