diff options
| author | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2018-04-18 13:39:03 +0530 |
|---|---|---|
| committer | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2018-04-18 13:39:03 +0530 |
| commit | fa68b88b5d415ebec84602b449bddeed761be04f (patch) | |
| tree | 0f9c322a6f8b9600dda7b9d66ad18bdbc5929e60 /mysql-test/suite/innodb_fts/t/innodb-fts-ddl.test | |
| parent | cff60be7fe159fdcb2517ce8441610ad512aa7d0 (diff) | |
| download | mariadb-git-fa68b88b5d415ebec84602b449bddeed761be04f.tar.gz | |
MDEV-15828 Server crash or assertion `num_fts_index <= 1' failure up on ALTER TABLE adding two fulltext indexes
- Inplace alter shouldn't support if the number of newly added fts index
exceeds 1 even though the table undergoes rebuild. It is a regression of
MDEV-14016
Diffstat (limited to 'mysql-test/suite/innodb_fts/t/innodb-fts-ddl.test')
| -rw-r--r-- | mysql-test/suite/innodb_fts/t/innodb-fts-ddl.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_fts/t/innodb-fts-ddl.test b/mysql-test/suite/innodb_fts/t/innodb-fts-ddl.test index 23065a97002..58282809083 100644 --- a/mysql-test/suite/innodb_fts/t/innodb-fts-ddl.test +++ b/mysql-test/suite/innodb_fts/t/innodb-fts-ddl.test @@ -271,3 +271,10 @@ SELECT * FROM articles WHERE MATCH (title, body) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); DROP TABLE articles; + +# Add more than one FTS index +CREATE TABLE t1 (a VARCHAR(3)) ENGINE=InnoDB; +ALTER TABLE t1 ADD FULLTEXT KEY(a), ADD COLUMN b VARCHAR(3), ADD FULLTEXT KEY(b); + +# Cleanup +DROP TABLE t1; |