Concurrent INSERTs each add the missing INTERVAL partitions, so the table gets several times the partitions it needs

--source include/have_partition.inc

--source include/have_innodb.inc

SET timestamp= UNIX_TIMESTAMP('2026-05-02 00:00:00');

--error 0,ER_PARSE_ERROR,ER_PARTITIONS_MUST_BE_DEFINED_ERROR

CREATE TABLE t1 (c DATE) ENGINE=InnoDB PARTITION BY RANGE COLUMNS (c) INTERVAL 1 DAY (PARTITION p0 VALUES LESS THAN ('2026-04-30'));

if ($mysql_errno)

{

  --skip Needs RANGE COLUMNS ... INTERVAL partitioning

}

DROP TABLE t1;

# 10 rounds. In each round, 8 sessions send the same INSERT at the same time

--let $r= 10

while ($r)

{

  CREATE TABLE t1 (c DATE) ENGINE=InnoDB PARTITION BY RANGE COLUMNS (c) INTERVAL 1 DAY (PARTITION p0 VALUES LESS THAN ('2026-04-30'));

  --let $i= 8

  while ($i)

  {

    --connect (con$i,localhost,root,,test)

    SET timestamp= UNIX_TIMESTAMP('2026-05-02 00:00:00');

    --dec $i

  }

  --let $i= 8

  while ($i)

  {

    --connection con$i

    --send INSERT INTO t1 VALUES ('2026-04-25')

    --dec $i

  }

  --let $i= 8

  while ($i)

  {

    --connection con$i

    --reap

    --disconnect con$i

    --dec $i

  }

  --connection default

  # One INSERT alone adds 3 partitions: up to 2026-05-03

  --let $n= query_get_value(SELECT COUNT(*) AS n FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1', n, 1)

  if ($n != 4)

  {

    --die Concurrent INSERTs each added the missing INTERVAL partitions: t1 has $n partitions instead of 4

  }

  DROP TABLE t1;

  --dec $r

}

mysqltest: At line 44: Concurrent INSERTs each added the missing INTERVAL partitions: t1 has 10 partitions instead of 4

mysqltest: At line 44: Concurrent INSERTs each added the missing INTERVAL partitions: t1 has 25 partitions instead of 4