MySQL Bugs: #33800: Some SQL keywords are ignored by the search engine

Bug #33800	Some SQL keywords are ignored by the search engine
Submitted:	10 Jan 2008 15:28	Modified:	10 Sep 2012 14:34
Reporter:	Hubert Roksor	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Websites: bugs.mysql.com	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	Vlad Safronov	CPU Architecture:	Any

Description:
I recently encountered what I think is a bug in MySQL server's parser regarding the usage of "HAVING". Before reporting that bug I wanted to check that it hadn't been previously reported, unfortunately, "having" is ignored by the search engine. I guess the engine has a list of the most common english words and "having" happens to be on that list. Unfortunately, while in english "having" doesn't carry much meaning, it's entirely different in SQL, that's why I think that it should be removed and the search engine should allow searching for it.

I passed the list of MySQL reserved words (http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html) to the search engine, here is the list of ignored words:
ALL AND AS BEFORE BETWEEN BOTH BY EACH ELSE FOR FROM HAVING IF IN INNER INTO IS LIKE NO NOT ON OR OUT RIGHT THEN TO USE USING WHEN WHERE WHILE WITH

While some of them are not really relevant to any bug reports (AND, OR, IF) others can be critical for finding info about a specific issue (HAVING, INNER, RIGHT).

One last irony, as I wanted to check whether that issue had been previously reported the search engine told me that "The following words were ignored: ignored" http://bugs.mysql.com/search.php?search_for=ignored&cmd=display

Thanks for reading

How to repeat:
Search for "HAVING" or any keywords from the list above

Suggested fix:
Remove those words from the ignore list

Thank you for a bug report.

HAVING, RIGHT, INNER, USING and ignored have been removed fron the stopword list.

HAVING, RIGHT, INNER, USING and IGNORED have been removed from the stopwords list.
Now the search function works as expected.