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

InnoDB: Error in pars0opt.cc: table test/#sql-5870_3 has prefix_len != 0

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE IF NOT EXISTS t1 (c CHAR(255)) ENGINE = InnoDB;
      ALTER TABLE t1 ADD FULLTEXT KEY ftidx (c);
      INSERT INTO t1 VALUES ('foo'),('bar');
      ALTER TABLE t1 ADD PRIMARY KEY (c(8));
       
      # Cleanup
      DROP TABLE t1;
      

      10.0 8e1056bce073530e815939ed596581980952d729

      bug.t8                                   [ fail ]  Found warnings/errors in server log file!
              Test ended at 2017-05-19 16:33:06
      line
      InnoDB: Error in pars0opt.cc: table test/#sql-58d3_3 has prefix_len != 0
      ^ Found warnings in /data/bld/10.0/mysql-test/var/log/mysqld.1.err
      

      Also reproducible with MySQL 5.6.
      Not reproducible with MariaDB 10.2 or MySQL 5.7.
      Please feel free to close as "won't fix" if you don't think it's worth fixing.

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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