MySQL Bugs: #55917: "Whole Word" match option in "Find and Replace" dialog finds partial words

Bug #55917	"Whole Word" match option in "Find and Replace" dialog finds partial words
Submitted:	11 Aug 2010 16:02	Modified:	30 Oct 2010 21:52
Reporter:	Orlando Colamatteo	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.26 CE Rev 6432	OS:	Windows (64-bit Windows 7 Ultimate)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	find, REPLACE, sql editor

Description:
When doing a "find and replace" selecting the option "Whole Word" does not affect the search behavior.

How to repeat:
Open a sql editor window and type "select selection" (no quotes). Press Ctrl+F to open the "Find" tab in the "Find and Replace" dialog. Type "select" (no quotes) in the "Find" input box. Select "Whole Word" and click "Find Next" twice. Notice that it finds the whole word "select" as well as "select" within the word "selection".

Suggested fix:
Implement the "Whole Word" option so it would skip "select" within the word "selection".

Hi Orlando,
for clarification, could you add a small screenshot of the dialog you're writing about. I can only see the options "Ignore Case" and "Enable RegEx Support" in the find/Replace dialog, missing teh "whole Word" option you are mentioning.
thanks in advance

Screenshot of "Find and Replace" dialog with "Whole Word" checked

Attachment: 4c65142a.jpg (image/jpeg, text), 31.15 KiB.

I just noticed that Choosing Edit>Find>"Find and Replace" from the menu opens a different dialog than pressing Ctrl+H. 

Press Ctrl+H to access the "Find and Replace" dialog shown in my screenshot.

This can be considered a duplicate of Bug# 56898

This issue may be related to, but it is not a duplicte of Bug# 56898. That bug reports an error that occurs when using the Find and Replace dialog. This bug reports an issue with incorrect results when using the selecting the "Whole Word" option.