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
