| Bug #40453 | Search in Boolean mode doesn't work | ||
|---|---|---|---|
| Submitted: | 31 Oct 2008 10:48 | Modified: | 31 Oct 2008 20:45 |
| Reporter: | Jakub Vrana (Candidate Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Websites: bugs.mysql.com | Severity: | S3 (Non-critical) |
| Version: | n/a | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | qc | ||
[31 Oct 2008 17:34]
Valeriy Kravchuk
Thank you for a problem report. Please, try again. In case of the same problem, please, describe what exct search fields you had set. I can not repeat the problem based on your description, hence the request.
[31 Oct 2008 20:45]
Jim Winstead
I am pretty sure this was related to a temporary out-of-disk-space problem on the bugs database server.
Description: Search in Boolean mode at bugs.mysql.com leads to following error: SELECT SQL_CALC_FOUND_ROWS bugdb.*, UNIX_TIMESTAMP(ts1) AS entered, UNIX_TIMESTAMP(ts2) AS modified, UNIX_TIMESTAMP(eta) AS eta, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged, CONCAT(user.firstname,' ',user.lastname) AS assign_name, user.firstname, user.lastname, user.email, CONCAT(u2.firstname, ' ', u2.lastname) AS lead_name, u2.firstname AS lead_firstname, u2.lastname AS lead_lastname, u2.email AS lead_email, MATCH (sdesc,ldesc) AGAINST ('+text +default' IN BOOLEAN MODE) AS relevance FROM bugdb LEFT JOIN user ON bugdb.assign = user.user_id AND bugdb.assign != 0 LEFT JOIN user AS u2 ON bugdb.lead = u2.user_id AND bugdb.lead != 0 WHERE 1 AND severity != 4 AND MATCH (sdesc,ldesc) AGAINST ('+text +default' IN BOOLEAN MODE) AND NOT private GROUP BY id ORDER BY relevance DESC LIMIT 0,10 Got error 28 from storage engine How to repeat: Search for '+text +default'.