diff options
| author | Sergey Vojtovich <svoj@sun.com> | 2009-09-02 16:19:28 +0500 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@sun.com> | 2009-09-02 16:19:28 +0500 |
| commit | f30480a695b313cbd7bcaea4fca1dfc638e8e5a1 (patch) | |
| tree | 32a6ee72d3f68b14dab2d27bca907fa313df7f2e /mysql-test/t/partition_innodb.test | |
| parent | f37a5879b4f19aab5be3e6d4ab69d2da60f443b4 (diff) | |
| download | mariadb-git-f30480a695b313cbd7bcaea4fca1dfc638e8e5a1.tar.gz | |
BUG#46483 - drop table of partitioned table may leave
extraneous file
Online/fast ALTER TABLE of a partitioned table may leave
temporary file in database directory.
Fixed by removing unnecessary call to
handler::ha_create_handler_files(), which was creating
partitioning definition file.
Diffstat (limited to 'mysql-test/t/partition_innodb.test')
| -rw-r--r-- | mysql-test/t/partition_innodb.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/partition_innodb.test b/mysql-test/t/partition_innodb.test index 2abbceffbb0..c2e98ab59b8 100644 --- a/mysql-test/t/partition_innodb.test +++ b/mysql-test/t/partition_innodb.test @@ -270,3 +270,15 @@ PARTITION BY RANGE (int_column) (PARTITION p1 VALUES LESS THAN (5)); show create table t1; drop table t1; + +# +# BUG#46483 - drop table of partitioned table may leave extraneous file +# Note: was only repeatable with InnoDB plugin +# +CREATE TABLE t1 (a INT) ENGINE=InnoDB + PARTITION BY list(a) (PARTITION p1 VALUES IN (1)); +CREATE INDEX i1 ON t1 (a); +DROP TABLE t1; +let $MYSQLD_DATADIR= `SELECT @@datadir`; +# Before the fix it should show extra file like #sql-2405_2.par +--list_files $MYSQLD_DATADIR/test/ * |