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
• Status: Closed
• Category: MySQL Websites: bugs.mysql.com
• Severity: S3 (Non-critical)
• 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.