[IMPALA-9280] Time string with signed TZH token preceded by dash cannot be cast to timestamp

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 3.3.0
• Fix Version/s: Impala 3.4.0
• Component/s: Backend
• Labels: newbie
• Target Version: Impala 3.4.0
• Epic Color: ghx-label-9
• Assignee: Riza Suminto
• Reporter: Jozsef Koza
• Created: 08/Jan/20 13:29
• Updated: 12/Feb/20 20:08
• Resolved: 12/Feb/20 19:12

Description

Given a time string containing a TZH token with a sign which is preceded immediately by a dash delimiter cannot be cast to timestamp.

To reproduce

Execute

select cast("08:00-+01" as timestamp format "HH:MI-TZH");

which results in NULL.

 

---

It seems like the delimiter is incorrectly recognised as the sign of the timezone offset hour which prevents parsing the TZH value.
Adding an additional delimiter (other than dash itself) between the dash separator and the sign in the time string makes cast working.

Executing

select cast("08:00- +01" as timestamp format "HH:MI-TZH");

results in 08:00:00.