Chat now with support
Chat with Support

Toad for MySQL 7.5 - Release Notes

Release Notes

Toad™ for MySQL

Version 7.5

Release Notes

Friday, March 20, 2015


Contents

Welcome to Toad for MySQL

New in This Release

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

System Requirements

Product Licensing

Global Operations

Getting Started

For More Information


Welcome to Toad for MySQL

With Toad™ for MySQL, developers and database administrators can use a familiar, proven tool to manage databases. Toad empowers developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management and develop SQL more efficiently.

Toad™ for MySQL also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database, while increasing your productivity and delivering access to an active user community.


New in This Release

This release of Toad for MySQL includes the following new features and enhancements.

Query Development

Background Processes

  • The Background Processes pane now identifies the Query Builder or Editor document window (if any) associated with a running process. If you have multiple statements executing simultaneously, this makes it easier to match a running process to its associated document. Click the running process in the Background Processes pane to display the associated document window.

  • In addition, for each Query Builder or Editor document with an active background process, an animated progress icon displays in the window's tab. This allows you to quickly see which windows have executing statements.

Analyze Joins

  • Toad now provides a tool to help you analyze and visualize joins in the Query Builder or a Database Diagram. After building a query or a diagram, click the join between two tables in a diagram. Toad profiles the data based on the relationship between the tables and presents the information in a Venn diagram. Click a section of the diagram to view the values represented by that section.

    The Venn diagram also indicates if a join is a Cartesian join. This gives you the opportunity to modify the join before executing the query.

Sort Columns

  • You can now sort columns in a table diagram in the Query Builder. Right-click a table and select Sort. This is useful for finding a column when the table or view has a large number of fields.

View PDF Files in LOB Viewer

  • You can now view PDF files in the LOB viewing pane in the Database Explorer, SQL Editor, or Query Builder. In the Data tab or Result Sets tab, in a LOB column, open the drop-down LOB viewing pane. If the LOB is a .pdf file, it is displayed in the PDF tab.

Automation

Throw Error Activity

  • Automation includes a new activity that allows you generate an error and add a custom error message to the script execution log. In addition, you can instruct Toad to stop or continue after the error is logged. This can be useful if you want to terminate the script when a condition exists that would not normally cause an error.

Automation Reports and Container Activities

  • In activities that allow you to select files created in previous activities in a script, reports generated in container activities are now visible in the File Collection Editor.

Idea Pond

  • Idea  Pond is a site where you can submit your ideas to improve Toad and vote or comment on other people's ideas. Toad's development has always been driven by our customers, and now it is even easier for you to tell us what changes are most important. This site is free for all customers.
  • Got a great idea for a new Toad for MySQL feature or enhancement? Share it with the Development Team and the Community by posting it on Idea Pond.
  • Visit Toad for MySQL Idea Pond where you can submit your ideas. You can also read and vote on the enhancement ideas submitted by other users.

Back to Top


Resolved Issues and Enhancements

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

Feature

Resolved Issue or Enhancement

Defect ID

Connections A connection profile that uses credentials with the "old style" password now works as expected. TMY-46
Debugger An issue that caused an error when attempting to enable Collect Debug Trace during debugging is resolved. TMY-24
Editor An issue that prevented SQL execution in one Editor after an unexpected lost connection in another Editor is resolved. TMY-45
General You should no longer encounter unexpected open transaction messages. TMY-42

Back to Top


Known Issues

The following is a list of issues known to exist at the time of this release.

Feature Known Issue Defect ID
Installation For some languages (languages using double-byte character encoding) specified using the Current language for non-unicode programs option in the Windows Region and Language dialog, the trademark symbols do not display correctly in the installer.

TDB-645

Schema Compare The timestamp column does not show differences when tables are updated. ST95642
Data Compare Views do not display in the New Comparison Wizard. ST95575
Debugger When you debug a stored procedure, Toad inserts its own statement in the user's Declare Cursor in both Procedure and Function causing a SQL error. ST93716
Automation

There are some problems with Toad for MySQL running as administrator on Windows 7/Vista systems with UAC turned on and Outlook running.

Workaround:

Either run Toad not as administrator or turn UAC off or close Outlook while opening Automation and also every time you add Send Email activity in the designer.

ST80857

Toad includes significant enhancements to Automation that affect attributes in the actual automation script. If you open an automation script from a previous version, a message informs you that the script will be upgraded so it will work in the current version of Toad.

Caution: If you upgrade this script, it will no longer be compatible with previous versions of Toad. However, a backup copy of your script will be saved in the Automation\BAK folder in the Application Data Directory under Help | About.

ST79125
Data For some queries, attempting to right-click a row and select Row Count results in a message stating that the row count could not be determined N/A
Export Wizard/ One Click Export

(Windows 7 only) When exporting data to an Excel instance using the Export wizard, Toad stops responding.

Workaround: 
On Windows 7, use One Click Export to Excel Instance to export data instead.

ST67980
Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit N/A
Import Wizard Attempting to import data that was exported to an Excel instance where the fractional seconds were truncated results in an error. N/A
Query Builder

Currently, you cannot reverse engineer a query that contains a WHERE EXIST clause.

ST75090
Version Control

If you migrate settings when upgrading Toad, you may have to reconfigure the repository setting in version control if a "Failed to open the settings for module VersionControl reverting to defaults" error displays.

Workaround:
To reconfigure the repository, select Tools | Options | Version Control | Defaults and select the previous repository in the Version control folder field. Your previous project settings are applied.

N/A
In previous releases, the method Toad used to generate the script was different than the current method. After upgrading Toad, a message may display stating that objects or files in version control are different than the local version. If your local version is current, you should check the objects and files into version control. N/A
Back to Top

Third Party Known Issues

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

Feature

Known Issue

Defect ID

Automation

Automation in MySQL 7.0 or later requires .NET Framework 4.5. If you are using .NET Framework 4.0 without .NET Framework 4.5 (such as in Windows XP), you may encounter the following:

  • After running a scheduled Automation script, Toad generates an error message even though the script executes successfully.

Workaround: Upgrade your Windows OS to Windows 7 and install .NET Framework 4.5.

N/A
Data

Currently, Korean characters are not supported.

ST41612
If the value of a TIME data type is greater than 24-hours, the value does not display correctly. N/A
Currently, geometry data types are not supported. ST70327
Import Wizard Importing large data sets from Excel (approximately 650,000 rows) is not recommended because of the amount of time it may take. This issue occurs because the Excel import component maintains the output in memory until the import completes. This can cause performance issues depending on the available system resources. CR219754

Export Wizard

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  

CR219754


System Requirements

Client Requirements

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

Platform

1 GHz minimum

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 for MySQL
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

800 MB to install Toad for MySQL

    Operating System

    Windows Server® 2008 R2 (64-bit)

    Windows® 7 (32-bit or 64-bit)

    Windows® 8 (32-bit and 64-bit)

    Windows® 8.1 (32-bit and 64-bit)

    Important: Toad uses the Microsoft® Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Vista, Windows Server 2008 and Windows 7. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access.

    .NET Framework

    The Microsoft® .NET Framework is required. The version is dependent on the operating system.

    .NET 4.5

    Windows Vista SP2, Windows 7, Windows 8, Windows Server 2008 (SP2 or earlier), Windows Server 2008 R2, Windows Server 2012

    .NET 4.0

    Windows XP, Windows Vista (SP1 or earlier), Windows Server 2003

    Notes:

    • This information is provided to aid installation. Toad for MySQL is not tested on Windows XP. Windows Vista (SP1 or earlier), and Windows Server 2003.
    • The .NET Framework 4 Client Profile is not supported.

    Additional Requirements

    Web Browser

    Microsoft® Internet Explorer® 6.0 or later

    Server Requirements

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

    Database Server

    MySQL 4.1, 5.0, 5.1, 5.5, 5.6

    Clustrix 5.2

    MariaDB 5.5.5

    Cloud Database Service Toad for MySQL can manage Amazon RDS and any other cloud or service offering compatible with MySQL, including Amazon Aurora.

    Virtualization Support

    Application Virtualization

    Limited testing has been performed for Citrix® XenApp™ 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.

    Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.

    Note: Toad may work in virtualization environments other than the ones in which it was tested.

    User Requirements

    User Requirements to Install Toad

    Only Windows Administrators and Power Users can install Toad.

    If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User, Vista standard user—on the computer.

    If a Power User installs Toad, a Restricted User cannot do the following:

    • Associate file extensions.
    • View the Toad shortcut icon on the desktop or the Toad menu options in the Windows Start menu. As a workaround, Restricted Users can create a shortcut to Toad from the install directory and place the shortcut on their desktop.

    User Requirements and Restrictions for Running Toad

    The following describes the requirements and restrictions for users who launch and run Toad:

    • 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 features.

    Product Licensing

    This product does not require licensing.


    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. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

    This release has the following known capabilities or limitations: No known limitations.

    Back to Top


    Getting Started

    Contents of the Release Package

    The Toad™ for MySQL release package contains the following products:

    1. Toad for MySQL
    2. Product Documentation, including:
      • Installation Guide
      • Online Help
      • Release Notes

    Installation Instructions

    For installation instructions, see the "Toad™ for MySQL Installation Guide" found on the Community site, http://www.toadworld.com/products/toad-for-mysql/w/wiki/297.product-documentation.aspx


    For More Information

    Get the latest product information, find helpful resources, and join a discussion with the Toad for MySQL team and other community members. Join the Toad for MySQL Community at http://www.toadworld.com/products/toad-for-mysql/default.aspx.

    Contact Dell

    Dell listens to customers and delivers worldwide innovative technology, business solutions and services they trust and value. For more information, visit www.quest.com.

    Technical Support:
    Online support

    Product Questions and Sales:
    (800) 306-9329

    Email:
    info@quest.com

    Technical Support Resources

    Please be advised before installing: Toad for MySQL is an official Dell Software Inc. Freeware Product. This license does not entitle Licensee to receive technical support from Dell .

    Get the latest product information and find helpful resources at the Toad for MySQL Community at http://toadformysql.com/index.jspa.

    Back to Top


     

    © 2015 Dell Inc.
    ALL RIGHTS RESERVED.

    This guide 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 Dell Inc.

    The information in this document is provided in connection with Dell 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 Dell products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, DELL 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 DELL 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 DELL HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Dell 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. Dell does not make any commitment to update the information contained in this document.

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

    Dell Inc.
    Attn: LEGAL Dept
    5 Polaris Way
    Aliso Viejo, CA 92656

    Refer to our web site (quest.com) for regional and international office information.

    Trademarks

    Dell, the Dell logo, Quest, SQL Navigator, vWorkspace, and Toad are trademarks of Dell Inc. and/or its affiliates. Microsoft, Windows, Windows Server, Windows Vista, Visual Studio, SharePoint, Access and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Oracle is a trademark or registered trademark of Oracle and/or its affiliates in the United States and other countries. Citrix® and XenApp™ are trademarks of Citrix Systems, Inc. and/or one or more of its subsidiaries, and may be registered in the United States Patent and Trademark Office and in other countries. MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Subversion is a trademark of the Apache Software Foundation. Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products. Dell disclaims any proprietary interest in the marks and names of others.

    Self Service Tools
    Knowledge Base
    Notifications & Alerts
    Product Support
    Software Downloads
    Technical Documentation
    User Forums
    Video Tutorials
    RSS Feed
    Contact Us
    Licensing Assistance
    Technical Support
    View All
    Related Documents

    The document was helpful.

    Select Rating

    I easily found the information I needed.

    Select Rating