Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16499

[10.1] ER_NO_SUCH_TABLE_IN_ENGINE followed by "Please drop the table and recreate" upon adding FULLTEXT key to table with virtual column

    XMLWordPrintable

Details

    Description

      --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.

      Attachments

        Issue Links

          Activity

            People

              kevg Eugene Kosov (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.