1 --source include/have_partition.inc
4 DROP TABLE IF EXISTS `t1`;
7 # On some platforms the lowest possible open_files_limit is too high...
8 let $max_open_files_limit= `SELECT @@open_files_limit > 511`;
9 if ($max_open_files_limit)
11 skip Need open_files_limit to be lower than 512;
15 --echo # Bug#46922: crash when adding partitions and open_files_limit is reached
17 CREATE TABLE t1 (a INT PRIMARY KEY)
18 ENGINE=MyISAM PARTITION BY KEY () PARTITIONS 1;
19 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11);
20 --echo # if the bug exists, then crash will happen here
21 --replace_regex /file '.*'/file '<partition file>'/
23 ALTER TABLE t1 ADD PARTITION PARTITIONS 511;