Wrong results with date arithmetic for dates in October 1582

Detail name	Value
Changelog Number	10987
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.1.0, Exasol 6.2.0, Exasol 7.0.0
Fix Versions	Exasol 7.1.0, Exasol 7.0.4, Exasol 6.2.12
Resolution Date	2020-11-09

Description 

There is a gap in the Exasol calendar between 1582-10-05 and 1582-10-14 corresponding to the Julian to Gregorian calendar reform.

The result for adding or subtracting an interval or integer number of days can be wrong if the start or end date is in October 1582, for example:

select date '1582-10-04' + 2;
-- Expected: 1 row, values (1582-10-16)
-- Observed: 1 row, values (1582-10-15)

Workaround

There is no workaround

Fix

The results for this date arithmetic is correct.