[FLINK-13232] TemporalTypesTest>ExpressionTestBase.evaluateExprs in blink planner fails on PST Timezone

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.9.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Jingsong Lee
• Reporter: Bowen Li
• Created: 11/Jul/19 20:56
• Updated: 12/Jul/19 06:07
• Resolved: 12/Jul/19 06:07

Description

TemporalTypesTest>ExpressionTestBase.evaluateExprs in blink planner seems to have a bug on timezone.

When I run it locally at PST timezone, it always fails as:

[ERROR] Failures:
[ERROR]   TemporalTypesTest>ExpressionTestBase.evaluateExprs:154 Wrong result for: [CURRENT_DATE] optimized to: [CURRENT_DATE] expected:<2019-07-1[2]> but was:<2019-07-1[1]>

I didn't find it fails on travis. Thus I suspect there's a bug w.r.t. timezone.

Issue Links

• links to: GitHub Pull Request #9095