summaryrefslogtreecommitdiff
path: root/mysql-test/suite/parts/inc/partition_auto_increment.inc
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2022-12-13 18:24:51 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2022-12-13 18:24:51 +0200
commitb7914f562da0d4bce7c1c26b119e7063594be974 (patch)
treedf85f229a896cf3e6b24ebc34063b078774b3834 /mysql-test/suite/parts/inc/partition_auto_increment.inc
parent21ef68d52e13ec146dab6cf54e0d3eca87306d58 (diff)
parentd7a4ce3c804334914b2431e91d6328945dce6b02 (diff)
downloadmariadb-git-b7914f562da0d4bce7c1c26b119e7063594be974.tar.gz
Merge 10.8 into 10.9
Diffstat (limited to 'mysql-test/suite/parts/inc/partition_auto_increment.inc')
-rw-r--r--mysql-test/suite/parts/inc/partition_auto_increment.inc13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/suite/parts/inc/partition_auto_increment.inc b/mysql-test/suite/parts/inc/partition_auto_increment.inc
index b19a8cd7749..567733edab0 100644
--- a/mysql-test/suite/parts/inc/partition_auto_increment.inc
+++ b/mysql-test/suite/parts/inc/partition_auto_increment.inc
@@ -886,6 +886,19 @@ eval CREATE OR REPLACE TABLE t1 (pk INT AUTO_INCREMENT, a INT, KEY(pk)) ENGINE=$
INSERT INTO t1 VALUES (1,1),(2,2);
UPDATE t1 SET pk = 0;
DROP TABLE t1;
+
+--echo #
+--echo # MDEV-29636 Assertion `part_share->auto_inc_initialized || !can_use_for_auto_inc_init()'
+--echo # failed in ha_partition::set_auto_increment_if_higher upon REPLACE
+--echo # with partition pruning
+--echo #
+eval CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY) ENGINE=$engine
+PARTITION BY RANGE (a) (
+ PARTITION p0 VALUES LESS THAN (10),
+ PARTITION pn VALUES LESS THAN MAXVALUE
+);
+REPLACE INTO t1 PARTITION (p0) SELECT 1;
+DROP TABLE t1;
}
if (!$skip_delete)