Aginity Workbench for Redshift 4.7 Release Notes

These release notes summarize the changes in Aginity Workbench for Redshift version 4.7. The release notes also contain system requirements and list the known issues with the release.

What's New? (Also See Full List of Changes)

This section provides information about the main new features in version 4.7:

Technical Details and Changes

This section contains details of specific functions and changes that are included in Aginity Workbench 4.7.

Upgrading from Prior Versions

Workbench automatically checks for new updates and displays a dialog box if an update is available. In the dialog box, select Install this update now to download and install the update.

You can also choose to postpone installation of the update until the next time you run Workbench or suppress the update alert.

You can also check for updates manually by clicking Check for Updates on the Help menu and then install an available update by following the instructions in a wizard.

System Requirements

  • Windows XP or later
  • Windows Installer 3.1
  • .NET Framework 3.5 SP1
  • Memory: 256 MB RAM
  • Disk space: 100 MB, plus any necessary space for .NET Framework and Windows Installer

Full List of Changes Since Aginity Workbench 4.6

Bug Fixes in Build 4.7.0.2454

Severity Reference Description Existed Since Version Resolution
Moderate WPD-179 A user gets an error on attempt to generate an INSERT statement for a selected table in the Query Analyzer window. 4.6 Fixed.
Moderate WPD-699 An error occurs when a user attempts to use the Compare Schemas feature. 4.6 Fixed. The feature now works as expected.
Minor WPD-681 Using semicolons in subqueries causes Workbench to crash. 4.4 Fixed.
Minor WPD-216 The Help menu contains an empty item under "Check for Updates" and a delimiter followed by no menu items under “Follow us ...” 4.4 Fixed.

Known Issues in Build 4.7.0.2454

Severity Reference Description Workaround
Major WPD-542 After a user generates DDL for a table with interleaved sort keys, Workbench incorrectly shows the number of sort keys in the Sort Keys node in the Object Browser or generates an error when the user attempts to expand the node. Manually update the generated DDL with the correct keys.
Moderate APD-4093 Import of a file from the S3 file explorer fails because invalid data types are set for the columns in the file. Set all column data types as VARCHAR and re-import the file.
Moderate APD-3788 The Abort feature in Redshift Workbench does not terminate a query that is currently running. Use the SQL at http://docs.aws.amazon.com/redshift/latest/dg/r_CANCEL.html to find the process ID of the running query and cancel it.
Moderate WPD-693 A user gets an error when trying to create new code snippets or modify existing ones. N/A.
Moderate WPD-680 Workbench generates invalid DDL when a user selects the Change Sort Keys command in the Object Browser. N/A
Minor APD-4090 If you begin a download using a file system explorer (such as Amazon S3) and abort the download, a small portion of the file remains on your target system. Manually delete the file on your target system.
Trivial APD-3711 When the field type is Date, the year 0 (for example, 0000-01-01) causes an error “Year, Month, and Day parameters describe an un-representable DateTime.” Either cast the date as a VARCHAR or do not use the year 0.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk