INSERT ... ON DUPLICATE KEY UPDATE doesn't support application-time periods

Both DELETE and UPDATE support a clause to work with application-time periods:

FOR PORTION OF date_period

    FROM '2001-01-01' TO '2018-01-01'

INSERT ... ON DUPLICATE KEY UPDATE currently has no equivalent option.

Reference:
https://mariadb.com/kb/en/application-time-periods/

—

NOTE: for consistency, you might want to implement this clause for REPLACE too. But I'm not opening a feature request for it.