Toad™ for MySQL
Version 7.5
Release Notes
Friday, March 20, 2015
Resolved Issues and Enhancements
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.
This release of Toad for MySQL includes the following new features and enhancements.
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.
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.
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.
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 |
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: |
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: |
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 |
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:
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: 2007 PIAs: |
CR219754 |
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:
Platform |
1 GHz | ||||
Memory |
512 MB of RAM minimum, 1 GB recommended Note: The memory required may vary based on the following:
| ||||
Hard Disk Space |
| ||||
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.
| ||||
Additional Requirements |
Web Browser Microsoft® Internet Explorer® 6.0 or later |
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. |
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. |
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:
The following describes the requirements and restrictions for users who launch and run Toad:
This product does not require licensing.
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.
The Toad™ for MySQL release package contains the following products:
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
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.
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
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.
© 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.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center