Toad for MySQL v2.0

Release Notes

/ Release Notes
Toad™ for MySQL
Version: 2.0
Revised: April 26, 2006
Copyright 2006 Quest Software, Inc. All rights reserved.
New in this Release / System Requirements / Global Operation / Before You Begin / Enhancements/ Resolved Issues / Known Issues / Third Party Known Issues / Contacting Customer Support

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

General

·  Support for triggers.

·  Significant performance improvements when running queries.

SQL Modeler

Quickly create the framework for a SQL statement from a graphical interface, including selecting tables and views; selecting and joining columns, adding conditions, etc.

Version Control

Easily check code in/out, add files, and get the latest revision without leaving the Editor window.

Session Monitor

Quickly view session information, including queries per second, number of threads, etc.

Database Browser/Object Palette

·  Object editors have a new look-and-feel.

·  Create LIKE support for database objects.

Reports

·  Create schema reports for selected databases and objects, including the source code for each object and links that display details for the object when selected.

·  Generate and format data reports.

Master Detail Browser

View or edit data from one or more tables that contain constraints.

Editor

·  Code Snippet Improvements—You can now insert any code snippet into the Editor using the shortcut name and pressing CTRL+SPACE. The Code Snippets tool window now functions as an editor where you can add, rename, and delete snippets.

·  Macro Record/Playback—Record a series of keyboard commands in the Editor that can be played back multiple times.

·  Find and Replace in File—Performs a Find and Replace across multiple files found in a directory structure.

Service Manager

Easily add, remove, start, or stop services from Toad.

Security Setup

Ability to restrict access to specific features in Toad.

Export Wizard Enhancement

Support for Microsoft Excel.

Knowledge Xpert

Enhanced MySQL content, including strategies for using a turnkey script to run an entire database migration at the "turn of a key."

Advanced Administration

·  Schema and Data Compare—Quickly compare and synchronize database objects and data.

·  Flush & Reset—Easily issue flush and reset commands to the server.

System Requirements

Verify that your system meets the following minimum requirements.

Minimum Hardware Requirements

Computer with a minimum of 233 MHz; 300 MHz or higher recommended

36 MB of disk space for installation

256 MB of RAM minimum, 512 MB recommended

SVGA monitor with a minimum resolution of 800x600, 1024x768 is recommended.

Minimum Software Requirements

Microsoft® Windows® 2000, 2003, XP

Microsoft .NET Framework 2.0

Microsoft Internet Explorer 5.0.1 or later

Adobe® Acrobat® Reader 5.0 or later (for viewing the Getting Started Guide)

Supported Databases

MySQL® Network™ 4.1.x, 5.0.x

MySQL Community 4.0.x, 4.1.x, 5.0.x

Global Operation

The platforms and configurations supported in this release can use any time zone, character encoding, language, or locale configuration to operate this product. Toad for MySQL supports multi-locale operation and uses the Unicode character set internally to support simultaneous operation with multilingual data.

The following limitation has been identified:

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

Before You Begin

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 will not be able to see the desktop icon or menu options in the Windows Start menu. Restricted users can create a shortcut to the application and place it on their desktop from the install directory.

·  If an Administrator installs Toad, they can share desktop icons and menu items with any user on the computer.

·  Network and LAN installations are currently not supported.

Please review important installation and upgrade information in the Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for MySQL 2.0 | Documentation.

Enhancements and Resolved Issues

Component / Enhancement/Resolved Issue / Case ID/ Change Request
Data Grid / You can now copy one or more rows from the data grid. / CID384417
Database Browser/ Obj Palette / Foreign keys and constraints now refresh properly when added, altered, or dropped. / CID368732
Attempting to create a foreign key constraint no longer results in an error message. / CR0123858
Attempting to alter a table with a large MAX_ROWS value no longer results in an overflow exception error. / CID394664
You can now define custom shortcuts for actions such as Add Column, in the Object Details pane. / CID387563
When running Toad on MySQL v4.1.14 database, a System.InvalidCastException error no longer occurs on the Constraint tab, Script tab, or when altering a table. / CR0142144
Selecting the Checksum or Delay Key Write checkbox when altering tables no longer results in an error / CR0123787 CR0123788
Attempting to insert a record in a Longblob column that is greater than 1 MB no longer results in a System.IO.IOException error. / CR0107768
Editor / Greek characters now display properly when executing queries. / CID416527
Auto-completion lists now support aliases / CID389277
Export Wizard / LONGTEXT columns are no longertruncated when exporting a table as a fixed column width. / CR0122773

Known Issues

Component / Known Issue / Case ID/ Change Request /
Connection / In order to connect using SSH, you must build an SSH tunnel with port forwarding. / CID386709
Code Snippets / When creating a new snippets folder, an exception error occurs if you do not rename the folder. / CR0164885
Data Compare / In this release, you can compare indexed views, but you cannot synchronize them. / CR0166497
When generating a sync script for a connection that doesn't exist may result in a "Couldn't resolve connection for TRL: {0}" error. / CR0167735
When running the Synchronization Wizard on two tables that have a foreign key relationship, the sync script that is created places the insert statements in alphabetical order rather than in logical order. This can result in errors when attempting to run the script.
As a workaround, disable script options for triggers, dropping primary and foreign keys, etc. until the sync is complete under Tools | Options | MySQL | Data Compare | Script. / CR0165611
Quest recommends limiting compares to 20000 rows in tables. When using Data Compare on large databases, Quest recommends excluding tables with large data sets from the comparison. / CR0142208
Database Browser/ Obj Palette / When creating a host, you cannot enable all privileges for a selected database. As a workaround, select each privilege checkbox individually. / CR0166777
Currently, you cannot create a procedure using the DEFINER clause. As a workaround, do not specify this clause in procedures. / CID419918
Editor / Attempting to launch the Editor after migrating settings from the 1.0 release may result in an error stating, "If a # is specified as the start of a web color, six hexadecimal digits must follow." This error occurs because you modified syntax highlighting for a language in the 1.0 release, and new highlighting styles were introduced in the 2.0 release. As a workaround, perform the following:
1.  Select Help | About and click the Application Data Directory link in the About dialog to open the data directory.
2.  Select Templates\Languages from the data directory.
3.  Delete all the files in the Languages directory.
Note: Any custom highlighting styles you set in the 1.0 release will be lost. You do not need to exit or restart Toad to continue. / CR0144639
Toad cannot execute an SQL script in the Editor if syntax highlighting is disabled (Tools | Options | Editor | Highlighting Styles). / CR0167980
The following object types are not found when using the View Object at Cursor feature:
·  Triggers
·  Procedures
·  Functions
·  Users
·  Hosts / CR0164917
Currently, the same parameter name cannot be used more than once for multiple tables in a query. / CR0163853
Currently, the explain plan is available with English language content only. / CR0158212
Object Search / Currently, you cannot search Unicode databases. / CR0166781
Security / Currently, the security feature is not functioning for add-on modules such as Schema and Data Compare. / CR0165320
Version Control / Some error messages are currently available with English language content only. / CR0140084

Third Party Known Issues

Component / Known Issue / Case ID/ Change Request
Connection / If you are using geometric data types, you will need to select the Use MySQL client libraries checkbox on the New Connection dialog. Note that you will need to set the client libraries up properly by adding the libmysql.dll to your path. This is a known limitation in the CoreLabs MySQL driver.
Data Grid / Currently, Korean characters are not supported. / CID395795
Editor / Attempting to load a large file in the Editor may result in the Editor becoming unresponsive or an error message due to a limitation in the parser. As a workaround, you can reduce the number of statement types processed by the Code Navigator in Tools | Options | Editor | Tools. / CID378430
Export Wizard / In order to export to an Office 2003 Excel instance, the Office 2003 Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from: http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en / CR0138239
Help / The internal help file uses an ActiveX control to enable cross-frame navigation in an internal browser window. Microsoft security update 896358 restricts the use of the ActiveX control due to potential vulnerabilities and results in the internal help topic displaying in the TOC or Index pane. If you want to use internal help, you will need to disable some features in the security update. Refer to Microsoft Knowledge Base article: http://support.microsoft.com/kb/896905/ for steps to re-enable these features in ActiveX. / CR0129554
Output / Currently, Korean characters are not supported. / CID395795
Version Control / Quest recommends using the native VSS implementation in Toad rather than VSS via SCC integration. When using VSS via SCC, if the file does not have the attributes that SCC expects, there may be issues with the file being updated properly. / CR0138078

Contacting Customer Support

Quest Software's world-class support team is dedicated to ensuring successful product installation and use for trial and commercial versions of Quest Software solutions.

SupportLink: www.quest.com/support

Email:

You can use SupportLink to do the following:

·  Create, update, or view support requests

·  Search the knowledge base

·  Access FAQs

·  Download patches

Yahoo Group

You can join the Toad for MySQL discussion group by sending an email to:

8