INSERT fails with ERROR 1493 when INTERVAL partitions on a TIMESTAMP column cross a change to daylight saving time

--source include/have_partition.inc

# In the MET time zone, the clocks go from 02:00 to 03:00 on 2026-03-29

SET time_zone='MET';

SET timestamp= UNIX_TIMESTAMP('2026-03-29 06:00:00');

--error 0,ER_PARSE_ERROR,ER_PARTITIONS_MUST_BE_DEFINED_ERROR,ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD

CREATE TABLE t1 (ts TIMESTAMP) PARTITION BY RANGE COLUMNS (ts) INTERVAL 1 HOUR (PARTITION p0 VALUES LESS THAN ('2026-03-29 00:00:00'));

if ($mysql_errno)

{

  --skip Needs RANGE COLUMNS ... INTERVAL partitioning

}

# The row fits p0. The INSERT adds the partitions up to the current time

--error 0,ER_RANGE_NOT_INCREASING_ERROR

INSERT INTO t1 VALUES ('2026-03-28 23:00:00');

if ($mysql_errno)

{

  --die An INSERT into a TIMESTAMP column with INTERVAL 1 HOUR partitioning fails when the new partitions cross the change to daylight saving time

}

DROP TABLE t1;

mysqltest: At line 17: An INSERT into a TIMESTAMP column with INTERVAL 1 HOUR partitioning fails when the new partitions cross the change to daylight saving time