[ https://issues.apache.org/jira/browse/CALCITE-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17722263#comment-17722263 ]
Sergey Nuyanzin commented on CALCITE-4555: ------------------------------------------ not sure whether there exists a SQL query to reproduce it (at least was not able to find such one) The issue was detected in Flink code where time attributes on one of the window sides are reduced to zero and {{org.apache.calcite.rex.RexBuilder#makeZeroLiteral}} is called explicitly for that > 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 > 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)