Version 4.0.0

Release Notes

August 2008

Welcome to Toad for MySQL	New in this Release	Resolved Issues and Enhancements	Known Issues	Third Party Known Issues
Upgrade and Compatibility	System Requirements	Global Operations	Installation	For More Information

Welcome to Toad for MySQL

Toad for MySQL is a database development and administration solution that provides productivity features for rapidly creating and executing queries, automating database object management, developing SQL code, and instant access to MySQL expertise.

Developers and administrators have access to a community of users, peers, and experts to help solve development and administration issues and assist in developing applications and feedback for improving Quests products.

All of this comes with the backing of Quest Software, a healthy and growing corporate entity that can provide the necessary training, support, and superior customer service demanded by IT management.

New in This Release

Review the following sections for updates in this release and new features:

General
Database Administration
Query Development
Data Management
Automation
Version Control

General

Many of the menu items have been reorganized to help you locate features faster.

You can now generate a report of assigned keyboard shortcuts. This is useful for keeping up with any customized shortcuts you create.
You can now share notes about objects, lookup tables, and hidden column settings with other users by specifying a network share location under Object Annotation Cache in Tools | Options | Database | Cache.
Toad now supports opening Excel 2007 (.xlsx) files. You can also export data to an Excel 2007 instance, but cannot export to an Excel 2007 file or import data from an Excel 2007 file.

Database Administration

The Database Browser has been renamed to Database Explorer, and the Object Palette has been renamed to Object Explorer.
You can now press DELETE to open a Drop object window.

When creating, altering, or dropping an object, the default is to execute the script without having to preview it first. To enable the preview script mode again, select the Always preview script in object editors checkbox in Tools | Options | Database | General.
When using the Generate SQL right-click menu from the Object Explorer or Database Explorer, you can now set an option to format the generated SQL (disabled by default). To format the SQL, select the Automatically format generated SQL checkbox in Tools | Options | Explorer | General.

Query Development

General:

You can now reverse engineer queries from the Editor or Query Builder.

Query Builder:

You can now specify whether to generate a SELECT, INSERT, UPDATE, DELETE, or CREATE statement from the toolbar.
You can manually edit a query in the Query tab of the Query Builder. Any differences between the SQL in the Query tab and Diagram tab are highlighted. Toad also supports full editor functionality in the tab, including code completion and snippets.

Queries executed in the Query Builder are now saved to SQL Recall so you can re-use them.

Editor:

Group execution is now integrated in the editor so you can execute SQL across multiple connections.
Execution of scripts and statements has been combined into the Script Execution toolbar button (Keyboard: F5). If you do not select a statement in the editor, the default is to execute the entire script.
Toad automatically saves a backup copy of open editor files that have been modified at five minute intervals (default). It also saves a backup copy anytime you execute the SQL. If the application does not terminate normally, the next time you open Toad for MySQL the backup copies automatically open in the editor so you can either save changes to your regular file or discard them.

You can specify the backup interval in Tools | Options | Environment | General:

A shortcut key has been added to invoke the "Surround With" Code Snippets. To use this functionality, select the text you want the template to surround and press CTRL+SHIFT+SPACE to select a comment or procedure.

Toad Insight (Intellisense) has been redesigned and renamed to Code Completion. Additional code completion enhancements include:
- Additional statement types are supported including update, delete, insert, call, and truncate table.
- Comments, object data types, and parameters display, if available.
- Functions that return a table type now display.
- Complete join statements are now generated.
- Local variables now display when you enter the @ symbol. To display global variables, enter the @@ symbol.

Code completion options are located in Tools | Options | Editor | Code Completion.

Embedded SQL has been renamed to Application Code. In addition, you can now select the template to use to add or remove application code from a statement in the toolbar.

Debugger:

You can now debug procedures and functions in MySQL. With the debugger, you can:

Debug stored procedures from create scripts that include more than one procedure or function in the file.
Add or evaluate local or global watches, calculated expression watches, hover watches (place the cursor over a variable to view a tooltip that displays the value).
Inspect local variables within the context of your call stack.
Set breakpoints, including conditional breakpoints based on watch values or counters.
Does not require you to recompile your procedures or functions with instrumentation to enable debugging.
Navigate through the calls, including selecting the line that invoked the subroutine in the calling procedure from the Call Stack window.

Data Management

Export Data:

You can export data to an Excel 2007 instance, but cannot export to an Excel 2007 file.
You can export data into an existing spreadsheet, including an existing worksheet or a new one. You can also specify the column and row where you want to begin adding data. This allows you to build charts and graphs from an existing spreadsheet and “refresh” the report by updating the data worksheet.
You can save export settings as a template that you can use for scheduled automation scripts.

Import Data:

Import data into a new table you create on-the-fly or into an existing table.
Save import settings as a template that you can use for scheduled automation scripts.
Currently, you cannot import data from an Excel 2007 file.

Data Grid:

You can now compare result sets from the current editor or a different editor in the Database Explorer's Data tab or the editor's Result Sets without having to save one of the sets to a file.

You can also save a result set and later use it for comparison. This is useful from the Database Explorer's Data tab when, over time, the data might be changing and can then be compared against this data that was saved.
You can right-click a data grid and select Show | option to customize the look and feel of the grid without having to open an options page.

The data grid in the Editor and the Data tab are now read-only by default. A red circle in the lower-left corner of the data grid indicates that the data is read-only. To edit the data, right-click the red circle and select Read-only. The circle changes to green, and you can now edit the data.
You can quickly find and replace data by pressing CTRL+F in any data grid.

You can now make minor changes to the underlying query in a Toad pivot grid. To edit the query, right-click in the data area of the pivot grid and select Edit Underlying Query. If you add or remove a column, a dialog warns you that you should create a new query.
You can specify an integer format that is separate from the number format in Tools | Options | Environment | Grid.

Automation

Automation activities have been moved to the left of the Design pane to provide a more intuitive workflow.

Support for new automation activities:

Select to File	Execute an existing SQL script or Query Builder query and export the results to an Excel, HTML, or CSV file. You can then use additional activities to add the exported result file to a zip file, attach the file to an email, or copy the file. Note: Bind variables are not supported for this activity. If bind variables are detected, a message alerts you during the test run of the automation script.
Execute SQL	Execute an existing SQL script or Query Builder query. Note: Bind variables are not supported for this activity. If bind variables are detected, a message alerts you during the test run of the automation script.
Select to Editor with Results	Execute an existing SQL script or Query Builder query and save it and any results sets in a Toad editor file (.tef). This file format is useful for building scripts that have large result sets that you do not want to continue executing or for saving results when you have not finished building a script.
Export Wizard	Export data from databases, tables, views, or query into a CSV, Excel, or other file. You can save the export settings as a template that you can use for scheduled automation scripts.
Import Wizard	Import data from a CSV, Excel, or other file into a new table or append to an existing table. You can save the import settings as a template that you can use for scheduled automation scripts.
Toad Pivot Grid	Refresh an existing Toad pivot grid and export results to a report. You can then use additional activities to add the pivot grid to a zip file, attach it to an email, or copy it.
Delete File	Delete one or more files from a specified location.

You can now click an activity to automatically add it to the Design pane.
Toad automatically adds a connection to the current database anytime you add an activity that requires a connection.
Improved exception handling lets you set exception handling and error logging by double-clicking the Script Settings activity that displays by default in the Design pane. Once you specify these settings, they are used by all subsequent automation scripts.

You can now save properties for any activity as a template for future use.

Version Control

Toad now supports the Team Foundation Server (TFS) version control provider. In order to use TFS, you must install the Visual Studio Team Foundation Server MSSCCI Provider on the same computer as Toad.

Note: This is not the same client that you install with Visual Studio. You can download the MSSCCI Provider from one of the following locations:

2005 MSSCCI Provider: http://www.microsoft.com/downloads
/details.aspx?FamilyID=87e1ffbd-a484-4c3a-8776-d560ab1e6198&DisplayLang=en

2008 MSSCCI Provider: http://www.microsoft.com/downloads/
details.aspx?familyid=FAEB7636-644E-451A-90D4-7947217DA0E7&displaylang=en

For more information about configuring TFS, see Configuration Prerequisites and in the help.

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of the Toad for MySQL.

Feature	Resolved Issue	Defect
Automation	Reports that require bind variable inputs are now supported.	CR#218790 ST#42253
Data Compare	Data Compare has been redesigned to support very large data sets. You no longer need to limit a compare to 100,000 records for each table.	CR#142208
Data Grid	You can now right-click a column header and select Fit to Header to size the width of all data columns to the width of the column header text.	CR#154172 ST#41602
Data Grid	When creating a custom data filter for a column, the Custom AutoFilter window now includes "Like" and "Not Like" operators.	ST#42514
Editor	The explain plan is now available with Unicode content.	CR#158212
Editor	Code completion now filters out object types that do not apply to the current context.	CR#223790 ST#42539
ER Diagram	Adding all tables to the ER Diagram no longer results in an error.	CR#223498
Export Wizard/ One Click Export	Exporting more than 65,536 rows to an Excel 2007 instance causes an error.	CR#211832
Export Wizard/ One Click Export	You can now successfully export data from a query with parameters.	CR#229814 ST#43093
Import Wizard	You can now select multiple worksheets in an Excel file to import.	CR#215343 ST#42114
Master Detail Browser	You can now select a checkbox beside each column you want to view in the Master Detail Browser.	CR#229305 ST#43015
Object Explorer/ Database Browser	You can now select Automatically format generated SQL in Tools \| Options \| Explorer \| General to either preserve your custom formatting or use the database formatting when you right-click an object and select Generate SQL. The default is to use the database format.	ST#46427 ST#49645
Reports	Reports Manager: You can now right-click a an existing data report and select Design Report to edit it. Newly created folders are now saved.	ST#43399 ST#43398
Version Control	Using the http or https protocol to configure subversion in Toad no longer results in an error.	ST#44067
Version Control	The help file now provides more detailed information about prerequisites needed to configure Subversion to work with Toad. For more information, see Version Control Objects and Files in the help.	ST#43596
Web Browser	When selecting the address field in the Web Browser, the entire URL is now highlighted.	ST#41939

Known Issues

The following is a list of issues known to exist at the time of the Toad for MySQL release.

Feature	Known Issue	Defect
Installation/ Upgrades	Customized options selected in the Configuration wizard are not applied if you are running Toad as a Restricted user. Workaround: Customize these settings in the Options pages in Toad (Tools \| Options from the menu).	CR#216699
Startup	(Windows Vista on Toad client only) If you initially start Toad when logged in as a standard user and enter a license key, the license key should be saved to: C:\Program Files\Quest Software\Toad for SQL Server 4.0 However, a standard user does not have write privileges in Vista to C:\Program Files so the key is saved to the following directory instead: C:\Users\username\AppData\Local\VirtualStore\Program Files\Quest Software\Toad for SQL Server 4.0 If you later start Toad as an administrator, you are prompted to enter the key again because it is not in the C:\Program Files directory.	N/A
Data Reports	Currently, you cannot create a Label Report in the Toad Data Report wizard.	CR#215945
Debugger	If you use a GET_LOCK command in a script you are debugging, you cannot debug the methods.	N/A
Editor	The following object types are not found when using the View Object at Cursor (F4) feature: Triggers Procedures Functions Users Hosts	CR#164917
Editor	(MySQL 4.1 only) Attempting to execute a "show innodb status" statement results in a "Net packets out of order" error message.	CR#193385
Export Wizard/ One Click Export	Binary data types cannot be exported in this release.	CR#170430
Export Wizard/ One Click Export	When exporting large results sets (approximately 500K), you may run out of memory before the operation completes. Workaround: Create a view for the query and export using that view.	CR#203483
Import Wizard	Currently, you cannot import Excel 2007 files because they are saved using an xlsx format. *Workaround:* Save the Excel 2007 file as a 2003 compatible file before importing it.	CR#221667
Query Builder	When reverse engineering SQL from the Query tab or the Editor, consider the following: If the statement contains an Inner Join, when you click Visualize Query in the toolbar to open the Diagram tab, and then select the Query tab again, the Inner Join is changed to a Cross Join. This issue occurs because the parser returns an incorrect join type. The Diagram tab does not support a SELECT clause where the columns are qualified with the database name. Workaround: When you visualize the query to display in the Diagram tab, Toad automatically creates calculated columns for the columns qualified with a database name. This allows you to execute the query and return the correct result set. The Diagram tab does not correctly model a Group by clause on a calculated column. Instead, it applies the Group by clause to the original column.	ST#52569 ST#49731 ST#48258

Third Party Known Issues

The following is a list of third party issues known to exist at the time of Toad for MySQL release.

Feature	Known Issue	Defect
Data Grid	Currently, Korean characters are not supported.	CR#160929
Data Grid	Currently, if the value of a TIME data type is greater than 24-hours, the value does not display correctly.	N/A
Export Data	In order to export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations: 2003 PIAs http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en 2007 PIAs http://www.microsoft.com/downloads/details.aspx?familyid=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displaylang=en	CR#138239
Output	Currently, Korean characters are not supported.	CR#160929

Upgrade and Compatibility

For information about upgrading, see the Installation Guide available from the Windows Start menu under Program Files | Quest Software | Toad for MySQL Freeware 4.0 | Documentation.

System Requirements

Client Requirements

Before installing Toad for MySQL, ensure your client system meets the following minimum hardware and software requirements:

Platform	1 GHz recommended
Memory	512 MB of RAM minimum, 1 GB recommended Note: The memory required may vary based on the following: Applications that are running on your system when using Toad Size and complexity of the database Amount of database activity Number of concurrent users accessing the database
Hard Disk Space	51 MB of disk space for installation
Operating System	Windows^® 2000 Note: The Automation feature requires the .NET Framework 3.0, which is not supported on Windows 2000. Windows 2003 Windows XP Professional (32-bit or x64) Windows Vista (32-bit or x64)
Additional Software	.NET Framework Microsoft .NET Framework 2.0 or 3.0 Notes: Consider the following: To run Toad, the .NET security policy must be set to unrestricted. For more information, see User Privilege Requirements. To use the Automation feature, the .NET Framework 3.0 must be installed. Web Browser Microsoft Internet Explorer 6.0 or later PDF Viewer Adobe^® Acrobat^® Reader 7.0 or later (for viewing the Toad for MySQL Installation Guide)

Server Requirements

Before installing Toad for MySQL, ensure your server meets the following minimum hardware and software requirements:

Database Operating Systems

Windows^® 2000 with SP4

Windows 2003

Windows XP Professional

Tested Databases

MySQL 4.1.22

MySQL 5.0.41

Citrix Requirements

Toad has been tested for Citrix support on Windows Server 2003 Enterprise Server SP2 using the MetaFrame Presentation Server 4.0 and Citrix Presentation Server Clients 10.2. For information about installing Toad in a Citrix environment, see Install Toad on Citrix Systems in the Toad for MySQL Installation Guide.

User Privilege Requirements

The following user privileges are required for installing and running Toad for MySQL:

Only Power users and Administrators can install Toad.
If a Power user installs Toad, a Restricted user can run the application but cannot
- Associate file extensions.
- See the Toad shortcut icon on the desktop or the Toad menu option in the Windows Start menu. As a workaround, Restricted users can create a shortcut to the application and place it on their desktop from the install directory.
If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and the Toad menu option in the Windows Start menu with any user on the computer.
To run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:

From the Windows Start menu, select Settings | Control Panel.

Double-click Administrative Tools.

Double-click Microsoft .NET Framework 2.0 Configuration.

Click + to expand My Computer, and then select the Runtime Security Policy node. A list of tasks for the node display in the right panel.

Click Evaluate Assembly from the list of tasks in the right panel. An Evaluate an Assembly window displays.

Browse to the location of Toad.exe in the File field.

Click Next to view permissions for Toad.exe.

Set the permission to Unrestricted.

To create or modify the QuestSoftware.ToadSecurity table to enable Toad Security, the user who maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the QuestSoftware.ToadSecurity table to use Toad Security.

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America,
Western Europe and Latin America, Far-East Asia, Japan.

The following limitation has been identified:

The Knowledge Xpert feature is available with English language content only.

Installation

Contents of the Release Package

The Toad for MySQL release package contains the following products:

Toad for MySQL 4.0.0
Product Documentation, including:
- Installation Guide
- Online Help
- Release Notes

Installation Instructions

For important installation information, see the Installation Guide available
from the Windows Start menu under Program Files | Quest Software | Toad for MySQL Freeware 4.0 | Documentation.

For More Information

Contact Quest Software:

Email	info@quest.com
Mail	Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA
Web	http://www.quest.com

Refer to our web site for regional and international office information.

This document contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser's personal use without the written permission of Quest Software, Inc.

Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Fastlane, Final, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, Internet Weather Report, InTrust, IT Dad, JClass, Jint, JProbe, Knowledge Xpert, LeccoTech, LiteSpeed, LiveReorg, Matrix Insight, Matrix.Net, MIQ, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Speed Change Manager, Speed Coefficient, Spotlight, SQL Firewall, SQL Impact, SQL LiteSpeed, SQL Navigator, SQLab, SQLGuardian, SQLProtector, SQL Watch, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656
Email: legal@quest.com

Disclaimer

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.