MySQL Forums
Forum List  »  Full-Text Search

MariaDB and MATCH AGAINST Query
Posted by: SGK Stmk
Date: August 01, 2016 08:30AM

Hi

something weird:

- two identical databases with the same dataset. One on my local computer XAMPP & mySQL, the other one on a Diskstation MariaDB.
- an nearly identical table b_entry with a FULLTEXT-index (3 columns: title, sht, lot); engines are InnoDB (mySQL) and myISAM (MariaDB), but this should not take effect.
- an identical SELECT (working on a fulltext-search - yes, it's a bit rough, but it's work in progress :) ):

SELECT DISTINCT b.id, b.title, b.shtext, b.lotext
FROM b_entry b, b_category c, b_entry2user eu
WHERE (
(MATCH(b.title, b.shtext, b.lotext) AGAINST('[searchterm]'))
OR (b.title LIKE '%[searchterm]%' OR b.shtext LIKE '%[searchterm]%' OR b.lotext LIKE '%[searchterm]%')
)
AND b.archive = 0
AND (
(b.categoryId = 4 AND b.id = eu.entryId AND eu.userId = [id])
OR (b.categoryId = c.id AND c.parentId = 3 AND b.id = eu.entryId AND eu.userId = [id])
OR (b.categoryId = c.id AND c.parentId = 2)
OR (b.categoryId = c.id AND c.parentId = 1)
);

Testing with mySQL I do get a resulstset with XX rows.
Testing with MariaDB I get an empty resultset, using the same searchterm and the same id?

What am I missing here?!?

Any help very appreciated!!

Options: ReplyQuote


Subject
Views
Written By
Posted
MariaDB and MATCH AGAINST Query
3447
August 01, 2016 08:30AM
1376
August 02, 2016 06:16PM
1212
August 11, 2016 12:45AM
1219
August 11, 2016 06:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.