Aginity Workbench for Greenplum 4.4 Release Notes

Aginity Workbench for Greenplum provides new functionality and improvements in stability and quality of the software over previous versions. These release notes summarize the new features and changes that apply to version 4.4.

What's New?

  • A built-in Workbench SQL Formatter is available in Workbench. In addition to using the built-in Workbench SQL Formatter, users can provide an alternative Windows Executable or .NET Assembly formatter. They can do so in Application Options > SQL Formatters.

Technical Details and Changes

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

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.3

New Features

Reference Summary
APD-6844 An option for ignoring SQL errors. Select Continue on error in the Query Options dialog box.
WPD-1 A simple SQL format tool is available.

Bug Fixes in Build 4.4.2183

Severity Reference Description Existed Since Version Resolution
Critical WPD-159 When a user exports an empty table to a file, an error occurs. 3.x Fixed.
Critical WPD-251 Under certain circumstances, when a user expands the Tables, External Tables, or Views node for a schema in the Object Browser, no tables or views are listed below. 4.4 Fixed.
Major APD-6459 When a user edits a function that has comments, in some cases saving it may cause the comments to be deleted. 4.0 Fixed.
Major APD-6444 A type mismatch error occurs when a user selects a column with a type of BIT. 4.0 Fixed.
Major APD-8795 After import from a JSON file that contains a dataset, only one record is added for the entire dataset. 4.3 Fixed. Data imported from a JSON file is now parsed into the correct number of records.
Major APD-8086 A flat data structure is incorrectly parsed after import from a JSON file. 4.3 Fixed. A flat structure is parsed into the correct number of records after import.
Major WPD-68 In some cases when a user attempts to browse columns in a table, an error occurs indicating that an object reference is not set to an instance of an object. 4.3 Fixed.
Minor WPD-88 Typo in the Restore Connections dialog box. 4.0 Fixed.

Known Issues in Build 4.4.2183

Severity Reference Description Workaround
Moderate APD-5977 The SECURITY DEFINER setting is ignored during export of a function. N/A.
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


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