[HIVE-23129] Cast invalid string to date returns incorrect result

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.1.2
• Assignee: wenjun ma
• Reporter: Yuming Wang
• Created: 02/Apr/20 05:36
• Updated: 26/Jul/21 05:06
• Resolved: 26/Jul/21 05:06

Description

hive> select cast('2020-20-20' as date);
OK
2021-08-20
Time taken: 4.436 seconds, Fetched: 1 row(s)

Issue Links

• is related to: HIVE-25306 Change Date/Timestamp parser from LENIENT to STRICT