Bug #52251 Search&Replace does not work in SQL editor
Submitted: 21 Mar 2010 6:23 Modified: 12 May 2010 16:13
Reporter: Georgiy Okrokvertskhov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.16 OS:Any (Fedora12, Mac OS X)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: Search&replace, sql editor

[21 Mar 2010 6:23] Georgiy Okrokvertskhov
Description:
Search&Replace feature simply does not work at all in SQL Editor. It looks like that Find feature also does not work. It is not a critical issue but it is a bit tediously to replace several items in script manually.

How to repeat:
1. Connect to MySQL Server
2. Choose "File->Open SQL Script" menu item
3. Open some script file
4. Being on script editor tab choose "Edit->Find->Search&Replace" menu item
5. Add something what exists in script file to Find test field
6. Add "123" to replace test field
7. Click on Replace All
8. Click on Replace
9. Click on Find Next

As a result nothing will be changed. Find next will not show next occurrence of the searched item.
[21 Mar 2010 9:25] Valeriy Kravchuk
Looks like a more general case of bug #51923.
[4 May 2010 21:33] Alfredo Kojima
Added Find and Replace support in SQL Editor and all Scintilla based editors in Mac.
Linux pending.
Windows is probably missing support in non-SQL Editor code editors (view, rgroup and trigger editors)
[5 May 2010 0:17] Alfredo Kojima
Linux implemented, Windows check pending.
[5 May 2010 18:08] Alfredo Kojima
Changed in Windows to allow find&replace from any code editor (ie, table/view/routine editors)
[7 May 2010 15:41] Johannes Taxacher
fix confirmed in repository
[12 May 2010 16:13] Tony Bedford
An entry has been added to the 5.2.21 changelog:

In the SQL Editor the Find and Replace facility did not appear to function.