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

            Assignee:
            thiru Thirunarayanan Balathandayuthapani
            Reporter:
            karll Karl Levik
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated: