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

InnoDB Fulltext indexes

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.5
    • None
    • None

    Description

      It's possible to create a fulltext index in an InnoDB table in 10.0.3, and, superficially, it appears to work as expected. This feature is untested, so either needs to be fully tested and incorporated as a feature, or disabled.

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-4115 Merge InnoDB fulltext index from MySQL 5.6

          • Major - Major loss of function.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-3932 5.6 merge

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Task - A task that needs to be done. MDEV-4786 merge 10.0-monty → 10.0

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4801 Server crashes in my_strdup on setting innodb_ft_user_stopword_table to DEFAULT

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4802 Filesort is used on same match expression as where clause (while it is not supposed to)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 10 older comments
            sanja Oleksandr Byelkin added a comment -

            innodb-fts-stopword (crash)
            innodb_fts_opt

            sanja Oleksandr Byelkin added a comment - innodb-fts-stopword (crash) innodb_fts_opt
            sanja Oleksandr Byelkin added a comment -

            – source include/have_innodb.inc

            select @@innodb_ft_user_stopword_table;
            create table user_stopword(value varchar(30)) engine = innodb;
            set session innodb_ft_user_stopword_table = "test/user_stopword";
            select @@innodb_ft_user_stopword_table;
            SET SESSION innodb_ft_user_stopword_table = default;
            select @@innodb_ft_user_stopword_table;
            drop table user_stopword;

            sanja Oleksandr Byelkin added a comment - – source include/have_innodb.inc select @@innodb_ft_user_stopword_table; create table user_stopword(value varchar(30)) engine = innodb; set session innodb_ft_user_stopword_table = "test/user_stopword"; select @@innodb_ft_user_stopword_table; SET SESSION innodb_ft_user_stopword_table = default; select @@innodb_ft_user_stopword_table; drop table user_stopword;
            sanja Oleksandr Byelkin added a comment -

            innodb_fts_opt which tests optimization now the only failing test probably because the optimization do not work somewhere...

            sanja Oleksandr Byelkin added a comment - innodb_fts_opt which tests optimization now the only failing test probably because the optimization do not work somewhere...
            sanja Oleksandr Byelkin added a comment -

            fixed fts optimization with limit and rolling back optimization with limit. still have some differences in the fts optimization applied...

            sanja Oleksandr Byelkin added a comment - fixed fts optimization with limit and rolling back optimization with limit. still have some differences in the fts optimization applied...
            sanja Oleksandr Byelkin added a comment -

            pushed (without optimization and optimization test (should be more general solution)).

            sanja Oleksandr Byelkin added a comment - pushed (without optimization and optimization test (should be more general solution)).

            People

              sanja Oleksandr Byelkin
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.