Bug #18072 On "Manual Editing", "advanced", it does not display all data.
Submitted: 8 Mar 2006 14:43 Modified: 18 Jun 2006 21:07
Reporter: Bob Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S3 (Non-critical)
Version:1.0.23 rc OS:Windows (Windows XP)
Assigned to: Michael G. Zinner CPU Architecture:Any

[8 Mar 2006 14:43] Bob Miller
Description:
On the "manual Editing" screen when you select advanced it displays the "SQL Create Script of Selected Object" window.  The problem is if a view or a stored procedure has a long line of text, only 128 bytes can be viewed.

For example:
-- DROP VIEW IF EXISTS `nf`.`test1`;
-- CREATE OR REPLACE VIEW `nf`.`test1` AS
-- select "ACCOUNT_ID","ACCOUNT_NUMBER","NUMBER_OF_SUBSCRIBERS","CREATION_DATE" from account where account_id >= 2000 and account_i

This display only shows 128 of characters. The last line is actually
-- select "ACCOUNT_ID","ACCOUNT_NUMBER","NUMBER_OF_SUBSCRIBERS","CREATION_DATE" from account where account_id >= 2000 and account_id <= 2010 

Also during editing, inserting a new line is not possible, unless you do it through the clip board using cut and paste.

How to repeat:
Migrate any view or stored procedure that has a line that is greater than 128 characters.

Suggested fix:
Add scroll bars and the ability to display long lines.
[8 Mar 2006 18:38] MySQL Verification Team
Thank you for the bug report.
[18 Jun 2006 21:07] Michael G. Zinner
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html