-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1, 10.0
-
Labels:None
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (a INT, b CHAR(12), c INT AS (a) VIRTUAL) ENGINE=InnoDB; |
ALTER TABLE t1 ADD FULLTEXT KEY(b); |
|
# Cleanup
|
DROP TABLE t1; |
10.1 c22ab56f0d6 |
CURRENT_TEST: bug.corrupt2
|
mysqltest: At line 4: query 'ALTER TABLE t1 ADD FULLTEXT KEY(b)' failed: 1932: Table 'test.t1' doesn't exist in engine
|
2018-06-15 19:45:14 140505486965504 [Warning] InnoDB: table test/t1 contains 3 user defined columns in InnoDB, but 3 columns in MySQL. Please check INFORMATION_SCHEMA.INNODB_SYS_COLUMNS and http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how to resolve it
|
2018-06-15 19:45:14 140505486965504 [Warning] InnoDB: Cannot open table test/t1 from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
|
Not reproducible on 10.2.
- relates to
-
MDEV-16500 Assertion `user_table->n_def > table->s->fields' failed in innobase_get_col_names upon ALTER TABLE with virtual columns
-
- Open
-
-
MDEV-16501 [10.1] InnoDB: Failing assertion: !strcmp(from, s) in dict0mem.cc upon ALTER TABLE with virtual column
-
- Open
-