Bug #58233 find and replace fails
Submitted: 16 Nov 2010 16:12 Modified: 16 Nov 2010 16:49
Reporter: Brandon Gallagher Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[16 Nov 2010 16:12] Brandon Gallagher
I was trying to use find/replace to change a typo across my script. 

How to repeat:
 I was trying to change "varchar" to "varchar(50)".  Hitting Replace All, I just get an error.  

Below is the script I was running the replace on...

create table dim_date (
	trans_date DATE,
	trans_year INTEGER,
	trans_month_of_year INTEGER,
	trans_month_name VARCHAR,
	trans_month_name_short VARCHAR,
	trans_day_of_year INTEGER,
	trans_day_of_week INTEGER,
	trans_weekday_name VARCHAR,
	primary key (trans_date)

) engine = MyISAM;

create table dim_zipcode (
	zipcode VARCHAR,
	city VARCHAR,
	state VARCHAR,
	country VARCHAR,
	primary key (zipcode)
) engine = MyISAM;
[16 Nov 2010 16:49] Valeriy Kravchuk
This is a duplicate of bug #56898.