[SOLR-15576] Solr SQL filter on valid ISO 8601 timestamp fails

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 9.0, 8.10
• Component/s: Parallel SQL
• Labels: RobustSQL
• Assignee: Timothy Potter
• Reporter: Timothy Potter
• Created: 03/Aug/21 20:15
• Updated: 28/Sep/21 20:27
• Resolved: 06/Aug/21 16:54

Description

On the mailing list, a user reported a simple query like:

WHERE addedon>= '2021-07-13T15:12:10.037Z'

fails. I reproduced this on main (different error than what was reported on the mailing list)

Given how common ISO-8601 timestamps are these days, I think we should support this syntax.

Issue Links

• links to: GitHub Pull Request #247
• links to: GitHub Pull Request #2548