Slow conversion of strings to date/timestamp for Non-4 Digit Years

Detail name	Value
Changelog Number	15445
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.0.0, Exasol 7.1.0, Exasol 8.0.0, Exasol 8.1.0
Fix Versions	Exasol 7.1.14, Exasol 8.6.0
Resolution Date	2022-09-21

Description

If a CHAR or VARCHAR value gets converted to a DATE or TIMESTAMP value, e.g., by TO_DATE, and the format model contains one of the following elements, then the performance is lower than expected:

• YYY
• YY
• Y
• IYY
• IY
• I
• vYY
• vY
• v
• VYY
• VY
• V

Workaround

Change the string representation to contain a 4-digit year and adapt the format model used for the cast accordingly (YYYY, IYYY, vYYY, or VYYY).

Fix

Conversions of strings to date/timestamp data types in the above scenario are as fast as conversions with 4-digit years.