[CASSANDRA-16105] InvalidQuery when datetime string format is not zero padded

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.0-beta3, 4.0
• Component/s: CQL/Interpreter
• Bug Category: Correctness - API / Semantic Implementation
• Severity: Normal
• Complexity: Normal
• Discovered By: User Report
• Platform: All
• Since Version: 4.0-beta2

Source Control Link

https://github.com/apache/cassandra/commit/07f8db31ae10a3883c06194642354feb711e361c

Test and Documentation Plan

new unit test characterizing the behavior

• Assignee: Adam Holmberg
• Reporter: João Reis

Authors

Adam Holmberg

Reviewers

Brandon Williams

• Created: 03/Sep/20 16:47
• Updated: 03/Jan/21 17:03
• Resolved: 15/Sep/20 15:45

Description

With CASSANDRA-15976, Cassandra no longer accepts certain datetime string formats that it used to accept before:

Unable to parse a date/time from '2020-09-03 9:00:00+0000'

In this example, 2020-09-03 9:00:00+0000 is not accepted in 4.0-beta2 but it is accepted in previous versions (I tested this with 4.0-beta1 and 3.11.4). If I add a zero so that it becomes 2020-09-03 09:00:00+0000 then it is accepted in all of the 3 mentioned versions (note the zero padded time part - 9:00:00 vs 09:00:00)