Bug #2162 The word "LIKE" is ignored but not displayed as ignored
Submitted: 18 Dec 2003 12:27 Modified: 15 Dec 2005 18:45
Reporter: Sergey Petrunya Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Websites: bugs.mysql.com Severity:S3 (Non-critical)
Version: OS:
Assigned to: Indrek Siitan CPU Architecture:Any

[18 Dec 2003 12:27] Sergey Petrunya
Description:
Search for "LIKE" in the bugs db yields message 
"The following words were ignored:"  (instead of "The following words were ignored: LIKE" ?).

Search for "LIKE is" yields message
"The following words were ignored: , is"

How to repeat:
see description
[19 Dec 2003 8:02] Alexander Keremidarski
The message I got is different and seems to be correct:

http://bugs.mysql.com/search.php?cmd=display&search_for=LIKE+is

No bugs with the specified criteria were found.
The following words were ignored: is
[29 Nov 2004 4:14] Sergey Petrunya
The bug exists and still there:

1. Look at this url and see "The following words were ignored:"  and no ignored words listed:
http://bugs.mysql.com/search.php?search_for=+LIKE&limit=10&order_by=&direction=ASC&cmd=dis...

2. Try finding this bug using word "LIKE" : 
http://bugs.mysql.com/search.php?search_for=LIKE&limit=10&order_by=&direction=ASC&cmd=disp...
[5 Dec 2004 12:22] Hartmut Holzgraefe
The problem is caused by a leading blank in the search field,
search input should be trim()ed before processing
[15 Dec 2005 18:45] Jim Winstead
Stopwords are now reported as skipped.