summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/parts/t/insert_ignore-5421.test
blob: 889f2ccae7b2feba3a45d108f8c25b7404e7f79d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
#
# MDEV-5421 Assertion `! is_set()' fails on INSERT IGNORE when a table has no partition for a value
#

--source include/have_partition.inc
CREATE TABLE t1 (i INT) ENGINE=MyISAM
PARTITION BY RANGE (i) (
  PARTITION p00 VALUES LESS THAN (1),
  PARTITION p01 VALUES LESS THAN (2)
);
INSERT IGNORE INTO t1 VALUES (3);
DROP TABLE t1;