diff options
author | Monty <monty@mariadb.org> | 2020-05-13 23:30:34 +0300 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2020-05-13 23:30:34 +0300 |
commit | edbf124515b36dc2a5ba40ca469d0d70507734a3 (patch) | |
tree | 582bed45569de64cf79f49af7ebe811a9f263d2f /mysql-test/suite/parts/inc/partition_auto_increment.inc | |
parent | 6bc4444d7ca81786de98f27669891692c2d2e21c (diff) | |
download | mariadb-git-edbf124515b36dc2a5ba40ca469d0d70507734a3.tar.gz |
Ensure that auto_increment fields are marked properly on update
MDEV-19622 Assertion failures in
ha_partition::set_auto_increment_if_higher upon UPDATE on Aria
table
Diffstat (limited to 'mysql-test/suite/parts/inc/partition_auto_increment.inc')
-rw-r--r-- | mysql-test/suite/parts/inc/partition_auto_increment.inc | 11 |
1 files changed, 11 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 199c8680864..4392d04db8a 100644 --- a/mysql-test/suite/parts/inc/partition_auto_increment.inc +++ b/mysql-test/suite/parts/inc/partition_auto_increment.inc @@ -861,6 +861,17 @@ SELECT * FROM t1; DROP TABLE t1; } +if (!$skip_update) +{ +--echo # +--echo # MDEV-19622 Assertion failures in +--echo # ha_partition::set_auto_increment_if_higher upon UPDATE on Aria table +--echo # +CREATE OR REPLACE TABLE t1 (pk INT AUTO_INCREMENT, a INT, KEY(pk)) ENGINE=myisam PARTITION BY HASH(a); +INSERT INTO t1 VALUES (1,1),(2,2); +UPDATE t1 SET pk = 0; +DROP TABLE t1; +} --echo ############################################################################## } |