[IMPALA-9206] SQL:2016 datetime patterns: Backslash with single quote is parsed incorrectly

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Impala 3.3.0
• Fix Version/s: Not Applicable
• Epic Color: ghx-label-12
• Assignee: Gabor Kaszab
• Reporter: Gabor Kaszab
• Created: 28/Nov/19 14:19
• Updated: 29/Nov/19 10:49
• Resolved: 29/Nov/19 10:49

Description

Copy-paste a review comment from ajeges:

I've found one more anomaly about apostrophe separator:

This is succeeding although \ is not a separator:

> select cast("2010\\'02-01" as date FORMAT "YYYY'MM-DD");

This works too;

> select cast("2010\\\'02-01" as date FORMAT "YYYY'MM-DD");

This fails:

> select cast("2010\\\\'02-01" as date FORMAT "YYYY'MM-DD");