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

FULLTEXT search with apostrophe, and mandatory words

    XMLWordPrintable

Details

    Description

      Aria and MyISAM appear to work, but not InnoDB:

      CREATE TABLE customer (
          name TINYTEXT NOT NULL,
          FULLTEXT (name)
      ) ENGINE = InnoDB;
       
      INSERT INTO customer VALUES ('O''Brien');
       
      SELECT * FROM customer WHERE MATCH (name) AGAINST ("+O'Brien" IN BOOLEAN MODE);
      Empty set (0.000 sec)
       
      CREATE TABLE customer2 (
          name TINYTEXT NOT NULL,
          FULLTEXT (name)
      ) ENGINE = Aria;
       
      INSERT INTO customer2 VALUES ('O''Brien');
       
      SELECT * FROM customer2 WHERE MATCH (name) AGAINST ("+O'Brien" IN BOOLEAN MODE);
      1 row in set (0.001 sec)
       
      CREATE TABLE customer3 (
          name TINYTEXT NOT NULL,
          FULLTEXT (name)
      ) ENGINE = MyISAM;
       
      INSERT INTO customer3 VALUES ('O''Brien');
       
      SELECT * FROM customer3 WHERE MATCH (name) AGAINST ("+O'Brien" IN BOOLEAN MODE);
      1 row in set (0.001 sec)
      
      

      Problem first reported on StackExchange:
      https://dba.stackexchange.com/questions/250524/mariadb-fulltext-search-with-apostrophe-and-mandatory-words

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            karll Karl Levik
            Votes:
            2 Vote for this issue
            Watchers:
            10 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.