Component

Enhancement/Resolved Issue

Case ID/ Change Request

Data Grid

Significant performance improvements have been made when populating data.

CR0186975

Data and Schema Compare

Resolved an error that occurred when attempting to connect to a database due to a reference in both Data and Schema Compare to an obsolete assembly.

CR0189726

DB Browser/ Obj Palette

Toad now reads changes to data that have been made using other tools.

CR0189726

Component

Enhancement/Resolved Issue

Case ID/ Change Request

Connection

SSH tunnel connections have been fixed in this release.

CID386709

Help

You can now navigate to help for MySQL database object editors from the Table of Contents (Database Browser or Object Palette | Work with Objects | MySQL Objects). Previously, you could only view these topics by pressing F1 or clicking Help on the object editor dialog.

CR0176744

Installation

The installer now launches the correct download link if Microsoft .NET 2.0 is not installed.

CR0173617

Component

Enhancement/Resolved Issue

Case ID/ Change Request

Data Grid

You can now copy one or more rows from the data grid.

CID384417

German characters now display properly in the data grid

CR0159992

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 longer truncated when exporting a table as a fixed column width.

CR0122773

Component

Known Issue

Case ID/ Change Request

Connection

Installing Toad into a directory other than the default directory results in a System.IO.DirectoryNotFoundException error each time you establish a new connection. As a workaround, complete the following steps:

1. Exit Toad

2. Locate the MySQL.xml file in the C:\Documents and Settings\user_name\Local Settings\Application Data\Quest Software\Toad for MySQL 2.0\ModuleSettings

3. Rename or delete the MySQL.xml file in the directory.

4. Restart Toad.

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

The Ignore case in text option (Tools | Options | MySQL | Data Compare | Compare) is not applied to ENUM or SET data types.

CR0139897

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

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

Session Monitor

When monitoring a 5.x database, if the database is disconnected and you attempt to refresh the Session Monitor, a System.OverflowException error occurs. As a workaround, reconnect the database, and then refresh the Session Monitor.

CR0171607

Version Control

Some error messages are currently available with English language content only.

CR0140084

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

Database Browser/ Obj Palette

Currently, you cannot create a procedure using the DEFINER clause. However, Toad can create a procedure without this clause in MySQL versions prior to 5.0.20 (Query Browser requires this clause). As a workaround, do not specify the DEFINER clause when creating procedures.

This is a known issue in MySQL that affects the command line utility.

CID419918

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