[IMPALA-5315] Cast to timestamp fails for YYYY-M-D format

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.6.0, Impala 2.7.0, Impala 2.8.0
• Fix Version/s: Impala 2.13.0
• Component/s: Backend
• Labels: ansi-sql newbie sql-language tpc-ds
• Epic Link: Timestamp Compatibility
• Assignee: Vincent Tran
• Reporter: Greg Rahn
• Created: 12/May/17 17:09
• Updated: 08/May/18 21:39
• Resolved: 14/Mar/18 18:14

Description

Dates with single digit months or days should cast to valid timestamps.

This returns NULL since it fails but should be valid.

impala> select cast('2000-3-1' as timestamp);
+--------------------------------+
| cast('2000-3-1' as timestamp)  |
+--------------------------------+
| NULL                           |
+--------------------------------+

Postgres

grahn=# select cast('2000-3-1' as timestamp);
      timestamp
---------------------
 2000-03-01 00:00:00

Issue Links

• breaks: IMPALA-6995 False-positive DCHECK when converting whitespace-only strings to timestamp
• is depended upon by: IMPALA-6641 Support more separators between date and time in default timestamp format
• relates to: IMPALA-1734 cast(<string> as timestamp) should not require zero padded elements