Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.4.8, 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
-
Fedora 30
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