diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-02-11 11:36:00 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-02-11 11:38:18 +0200 |
| commit | be25414828958d9cf829f7e8f162377bbfdfb4db (patch) | |
| tree | 498a139b3e3dcd60443bba97206bfb94de324668 /mysql-test/suite/innodb/r/foreign_key.result | |
| parent | af3cbb51cef507e9f233a48a017d1237ee17cca6 (diff) | |
| download | mariadb-git-be25414828958d9cf829f7e8f162377bbfdfb4db.tar.gz | |
MDEV-18016: Cover the no-rebuild case, and remove a bogus debug assertion
The code path where the table was not being rebuilt during ALTER TABLE
was not covered by the test. Add coverage, and remove the debug assertion
that could fail in this case.
Diffstat (limited to 'mysql-test/suite/innodb/r/foreign_key.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/foreign_key.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/foreign_key.result b/mysql-test/suite/innodb/r/foreign_key.result index 4e253261f2e..d28ade4c543 100644 --- a/mysql-test/suite/innodb/r/foreign_key.result +++ b/mysql-test/suite/innodb/r/foreign_key.result @@ -82,3 +82,13 @@ ALTER TABLE t1 ADD FULLTEXT INDEX ft2 (f); Warnings: Warning 1088 failed to load FOREIGN KEY constraints DROP TABLE t1; +CREATE TABLE t1 (f VARCHAR(256), FTS_DOC_ID BIGINT UNSIGNED PRIMARY KEY) +ENGINE=InnoDB; +SET SESSION FOREIGN_KEY_CHECKS = OFF; +ALTER TABLE t1 ADD FOREIGN KEY (f) REFERENCES non_existing_table (x); +SET SESSION FOREIGN_KEY_CHECKS = ON; +ALTER TABLE t1 ADD FULLTEXT INDEX ft1 (f); +Warnings: +Warning 1088 failed to load FOREIGN KEY constraints +ALTER TABLE t1 ADD FULLTEXT INDEX ft2 (f); +DROP TABLE t1; |