Aqua Data Studio Changelog

What's new in Aqua Data Studio 22.3.2

May 3, 2023

SUPPORT : Multiple issues with ADS after upgrading OS to MacOS Ventura (13.0)

New in Aqua Data Studio 22.1.3 (May 30, 2022)

New in Aqua Data Studio 22.0.1 (Nov 15, 2021)

New in Aqua Data Studio 20.6.1-4 (Nov 21, 2020)

New in Aqua Data Studio 20.6.1 (Nov 21, 2020)

New in Aqua Data Studio 20.0.4 (Jan 8, 2020)

New in Aqua Data Studio 20.0.2 (Jan 8, 2020)

New in Aqua Data Studio 20.0.1 (Jan 8, 2020)

New in Aqua Data Studio 20.0.0 (Jan 8, 2020)

New in Aqua Data Studio 19.5.0 (Feb 24, 2019)

New in Aqua Data Studio 19.0.0 (May 6, 2018)

SCHEMA SYNCHRONIZATION:
More Databases Supported:
We have added synchronization capabilities to three additional database servers: MySQL, PostgreSQL and Sybase IQ.
DOCKING FRAMEWORK:
Usability and Functional Enhancements:
We have added significant usability and functional enhancements to our docking framework which now offers several viewing modes, new orientation styles, and controls for resizing and showing/hiding of panels.
MONGODB:
Views, Decimal128 & Collation:
MongoDB support has been enhanced to support Views, the Decimal128 datatype and Collation. The MongoShell and Java Driver have been upgraded to 3.4.
VISUAL EXPLAIN:
Explain Plans for 3 More Databases:
You can now use Explain Plans in Text format for Hive, Impala & Spark to help reduce SQL query bottlenecks.
NEW DATABASE VERSIONS:
More DB Version Support:
Connect to Amazon EMR Hive 5.4, Apache Derby 10.13, Cloudera 5.8, DB2 z/OS 12, Hortonworks 2.5, MapR 5.2, Netezza 7.2.1, PostgreSQL 9.6, SAP HANA 2, SQLite 3.16, Sybase Anywhere 17, and VoltDB 7.4.
VA PRODUCTIVITY ENHANCEMENTS:
Filter Enhancements:
Our new sharing filter capability enables Visual Analytics to share filters across multiple worksheets. You can also add or remove multiple filter choices from the chart view in a single operation.
Combined Fields:
Our new combined fields offer a quick and convenient way of combining multiple dimension fields into a new dimension.
Chart Title:
You can now show and customize the chart title on your worksheets and dashboards.
Size Legend:
We now offer a Size Legend for the measure placed in the Size Deck. The legend shows the range and size distribution for that measure. You can edit the range and size distribution using the Edit Size dialog.
More Charting Enhancements:
Create tooltips with rich text formatting for parameters. Copy and paste a list of values from a clipboard in the parameter. View aggregation calculations in the Visual Analytics status bar when two or more chart segments are highlighted. Pick a color from anywhere on your desktop or the web and assign it to the selected data item. Copy a pivot grid to Web and desktop applications without losing highlighting and formatting of the pasted data. Our new table calculation function returns the number of rows in the partition.
VA DATA LABEL ENHANCEMENTS:
Show and Hide Data Labels:
Turn labels on and off for each measure field individually.
Move Data Labels on Shape Chart:
Reposition data labels to best fit your chart view. Visual Analytics automatically draws a leader line from the label to the data point when you move the label to a new location.
Data Label Colors:
Our new data label color functionality allows customizing the default foreground and background colors of the data labels.
Vertical Orientation:
Color legend in VA supports vertical orientation.Learn More
VA PERFORMANCE ENHANCEMENTS:
Filter Performance Enhancements:
For larger data sets, the filter response time has reduced from 1 minute 52 seconds to under 2 seconds when items are unchecked from the Filter Deck. Show and Cancel buttons have been introduced to reduce lag time when toggling multiple checkboxes.
Export PDF Performance Enhancements:
PDFs are now exported in native format which results in smaller file sizes and reduced export times when exporting larger data sets. In addition, text and chart elements appear very crisp at higher zoom levels.

New in Aqua Data Studio 18.5.0 (Dec 7, 2017)

15392: Enhancement : ADS : Schema Tree : Added icons to easily identify partition, clustering keys in Table Properties and Schema Tree node.
15389: Enhancement : ADS : Projects : Added support Vertica Pojection extraction in the Database Schema and Data Exporter.
15387: Enhancement : ADS : DB - Cassandra : Added these new types - smallint, date, time, tinyint.
15385: Enhancement : Visual Analytics : In table calculation dialog, added the ability to view the table calculation formula.
15379: Enhancement : Visual Analytics : Enhanced open workbook processing. Now opening workbooks with long query latency allows other Aqua Data Studio processing to proceed.
15375: Enhancement : ADS : Query Analyzer : Added key mapping entry for column block selection mode.
15364: Enhancement : ADS : Export : Enhanced the Aqua Data Studio Export tool to generate a separate tab in an Excel workbook with the query used to export the data.
15304: Enhancement : ADS : Editor : Added shift + delete as an alternative key mapping for windows/linux for our default key binding for CUT.
15294: Enhancement : ADS : Visual Editor : Enhanced the Table Visual Editor so that the constraints user interface is resizable making it easier to add constraints.
15222: Enhancement : Visual Analytics : Added support for the label deck for bar charts. This allows dragging of dimension fields onto the Label deck.
15208: Enhancement : ADS : Table Data Editor : BigQuery Standard SQL can now use the Table Data Editor feature in Aqua Data Studio.
15044: Enhancement : ADS : History : We now enable the SQL History Archive so that your SQL history is no longer deleted.
14963: Enhancement : ADS : Table Data Editor : Identifying that a column is not editable makes Table Data Editoring easier.
14888: Enhancement : ADS : DB - Vertica : Added support for Geospatial datatypes for Vertica 8.0.x and above in the Visual Editor and ER Modeler.
14829: Enhancement : ADS : Query Analyzer : Added Median and Percentile options to the Grid Results Aggregate Bar.
14703: Enhancement : ADS : DB - Vertica : Added "Check" as a constraint option for Vertica 7.2 and above when creating a table using the Aqua Data Studio Visual Editor.
13241: Bug : ADS : Table Data Editor : Fixed the "Find and Replace" window in the Table Data Editor window. It is now wide enough to display all of the buttons correctly.
10045: Enhancement : ADS : Git Client : Added "Create Branch from Tag" option for the Git Client.
4989: Enhancement : ADS : DB - Netezza : Added the "Execute" option for Netezza Procedures when selecting the scripting menu from the schema tree.

New in Aqua Data Studio 18.0.19 (Sep 27, 2017)

New in Aqua Data Studio 18.0.18 (Jul 14, 2017)

New in Aqua Data Studio 18.0.17 (Jun 26, 2017)

New in Aqua Data Studio 18.0.16 (Jun 25, 2017)

New in Aqua Data Studio 18.0.15 (Jun 20, 2017)

New in Aqua Data Studio 18.0.14 (Jun 17, 2017)

New in Aqua Data Studio 18.0.13 (Jun 5, 2017)

New in Aqua Data Studio 18.0.12 (May 15, 2017)

New in Aqua Data Studio 18.0.11 (May 8, 2017)

New in Aqua Data Studio 18.0.10 (May 1, 2017)

New in Aqua Data Studio 18.0.9 (Apr 18, 2017)

New in Aqua Data Studio 18.0.8 (Apr 18, 2017)

New in Aqua Data Studio 18.0.7 (Apr 3, 2017)

New in Aqua Data Studio 18.0.6 (Mar 28, 2017)

New in Aqua Data Studio 18.0.5 (Mar 19, 2017)

New in Aqua Data Studio 18.0.4 (Mar 16, 2017)

15073 : Bug : ADS : DB - Oracle -> Fixed extraction and scripting of indexes on virtual columns which was expanding the expression instead of column names
15072 : Bug : ADS : DB - SQL Server -> Fixed extraction and scripting of indexes for partitioned tables using 'include' clause
15069 : Bug : ADS : Schema Compare -> NPE on changing the Group By drop down is fixed
NONE : Improvement : ADS : Fix to catch all Throwables if .isValid() method is not supported by a jdbc driver
NONE : Improvement : Editor : Introduced File > Option > General > Editor Encoding (Default) to set default encoding in Editors
NONE : Improvement : Editor : Introduced File > Option > [Editor] > Auto Indent to toggle Auto Indent behavior in Editors
NONE : Bug : ADS : Editor Encoding : Fixed inconsistent behavior for encodings with exclamation mark for an in-memory editor and physical file
NONE : Bug : ADS : Editor Encoding : Fixed the java.lang.StringIndexOutOfBoundsException when Ctrl+X was pressed on changing file encodings
NONE : Bug : ADS : Editor - File > Open : On performing 'Reload from file system' operation, File was not getting reloaded properly
NONE : Bug : ADS : Schema Sync -> Script was not saved with .sql extension in Deployment tab of Schema Synchronization
NONE : Bug : ADS : Schema Compare -> Searched object is removed from search box after applying the filter on the object
NONE : Bug : ADS : Schema Sync - SQL Server and Sybase ASE -> Fixed the failure in deployment script when the composite key in the table is avoided
NONE : Bug : ADS : Schema Compare -> Added a warning popup if the user moves cursor on State/Type column and then clicks on "Compare Data" icon
NONE : Bug : ADS : Schema Sync -> Fix to handle unchanged constraints/indexes on table changes without table rebuild
NONE : Bug : Visual Analytics : Empty cells of Highlight table chart should not turn grey on highlighting cell
NONE : Bug : Visual Analytics : Fixed exception on Highlight Charts with reference line on merged axes chart, table calculation on measure field & same field is selected from Color legend

New in Aqua Data Studio 18.0.3 (Mar 10, 2017)

New in Aqua Data Studio 18.0.2 (Mar 7, 2017)

15058 : Enhancement : ADS : Added IBM DB2 LUW v11.x version string in Server Registrations and in File > Options
15053 : Enhancement : ADS : Script Ignore Policy: Dropdown should shrink on making window small. Modified layout manager for the component
15052 : Bug : App - General: SQL Server -> Fixed scripting of Column Store Index -> WITH options which was scripting blank ()
15051 : Bug : ADS : Tools - Compare - Schema: Fixed exception on hitting CNTRL+C key when Group By option = Type of Difference, during Schema Compare
15050 : Bug : ADS : App - Charts: Fixed Retina Display issue in Mac OSX. Ported fix from Visual Analytics after the JOGL 2.3.2 upgrade
15049 : Bug : ADS : Tools - Compare - Schema: Fixed Script Ignore Policy: Ignore whitespace, empty lines, ignore case showed incorrect differences
15046 : Bug : ADS : Tools - Compare - Schema: Fixed exception on saving Schema Compare Results (HTML) with Group by > No Groups and criteria on Search Filter
NONE : Improvement : ADS : Update to Mac OSX Java 1.8.0_121
NONE : Bug : Editor : Fixed NPE on hitting CTRL+O keys, while query analyzer open was in process
NONE : Bug : Editor : Fixed ADS to preserve BOM in case of preloaded data. ADS was displaying incorrect behavior on File > Open and assigning encoding to another type
NONE : Bug : Editor : XML Tag highlighting was not cleared when content size exceeded code completion limit
NONE : Bug : Editor : Fixed the issue with cursor not changing its location after Undo/Redo operation
NONE : Bug : Editor : Corrected the Option name in the invalid range popup message
NONE : Bug : Editor : Fixed the issue with versioned file, where the Inline Diff Sidebar disappeared after changing case to Upper/Lower case
NONE : Bug : Editor : Added method so that we can programmatically decide if the tab will be added in main tool bar or its side tool bar
NONE : Bug : Editor : SQL editor - Encoding does not display correctly when loading a new file
NONE : Bug : Editor : IF, WHILE, PARTITION keywords was not highlighted after restarting ADS for OS X & Linux OS
NONE : Bug : ADS : Schema Sync -> Fixed scripting to handle unchanged constraints/indexes on table changes without table rebuild
NONE : Bug : ADS : Schema Sync -> Fixed the incorrect deployment script being generated on objects with constraint/index/trigger objects attached
NONE : Bug : Visual Analytics : Fixed the issue on Color mapping, which was not getting restored on Undo operation
NONE : Bug : Visual Analytics : Fixed the NPE on moving Filter field to Color deck
NONE : Bug : Visual Analytics : Color settings are reset to default, on updating calc field expression

New in Aqua Data Studio 18.0.1 (Feb 28, 2017)

REDESIGNED EDITORS:
Usability and Functional Enhancements:
The redesigned editors offer enhanced Status, Annotation, and Marker bars, streamlined Find and Replace functionality, changing font size (zooming) in active editor, and Punctuation completion features.
SQL Editor Enhancements:
The SQL Editor has been enhanced to support code folding, navigating amongst errors in text results pane, an improved autocompletion matching algorithm and sorting autocompletion entries either lexicographically or by relevance.
AquaScript Editor Enhancements:
We have introduced six new templates for creating AquaScripts. The AquaScript Editor has also been enhanced to support code folding, provide an improved autocompletion matching algorithm, navigate amongst errors/warnings, and facilitate real-time indexing.
Diff and Compare Enhancements:
We now provide a smarter difference engine and have simplified your diff related tasks. An improved UI supports syntax highlighting, an annotation bar to customize your editor settings, collapsing unchanged fragments, and more. You can now compare and synchronize the content of your directories using our brand new Directory Compare interface.
CONNECTION MONITOR:
Connection Monitor Tool:
Our new all-in-one connection monitor tool offers the ability to ping database connections on a periodic basis, refresh results in your Query Window at a specified interval, and turn on auto-commit after the idle threshold is exceeded.
EXCEL JDBC IMPROVEMENTS:
Performance Improvement:
Our Excel JDBC driver delivers a 10x performance improvement when expanding schema objects in large Excel workbooks.
Reduced Memory Footprint:
The Excel JDBC driver consumes 6x less memory when expanding schema objects in large Excel workbooks.
SCHEMA SYNCHRONIZATION:
Schema Synchronization:
You can now seamlessly deploy differences from your source schema to your target schema for Oracle, MS SQL Server, Sybase ASE, and DB2 LUW. A wizard allows you to select dependencies, map missing columns, configure your script to fix potential deployment issues, view a summary of actions and warnings, and generate the deployment script to execute in Query Analyzer.
Schema Compare Enhancements:
The Schema Compare Results UI now groups results according to the type of differences and offers a more powerful and streamlined Search capability. You can also specify the source and the target schema objects to synchronize.
VISUAL EXPLAIN:
Find Amazon Redshift Query Bottlenecks:
Our Visual Explain Plan capabilities are now available for Amazon Redshift.
Find Teradata Query Bottlenecks:
You can now use Explain Plans in Text format for Teradata to help reduce SQL query bottlenecks.
GOOGLE BIGQUERY ENHANCEMENTS:
Standard SQL Support:
Aqua Data Studio now supports BigQuery Standard SQL syntax.
Insert Performance Optimization:
Aqua Data Studio can now insert multiple records in a single INSERT statement, thereby significantly reducing the time it takes to import a large amount of data into BigQuery.
NEW DATABASE VERSIONS:
More DB Version Support:
Connect to MongoDB 3.4, SQL Server 2016, Apache Hive 2.1, Cloudera 5.8, Hortonworks 2.5, MapR 5.1, DB2 LUW 11.1, MySQL 5.7, PostgreSQL 9.5, Vertica 8, and VoltDB 6.8.
Microsoft JDBC Support:
You can now use the Microsoft JDBC driver to connect to SQL Server and Azure.
MORE VISUAL ANALYTICS:
Axes Enhancements:
Our enhanced axes support lets you specify a fixed axis range, reverse the order of values on an axis, display a separate axis per measure, and retain measure colors as you change your axes type.
Sorting Enhancements:
You can now choose to sort data based on any field in your dataset or a custom order. Sorting shortcuts have been added in the toolbar, chart tooltips, and most row and column headers.
Filter Enhancements:
Our new filtering capabilities enable you to create relative date filters. Moreover, you can keep only/exclude selected records directly from the chart view or legends.
Export Enhancements:
Export your visualizations to PDF. Also, large charts can now be exported without being cropped to PNG, HTML, and PDF formats.
Symbol Map & Bullet Charts:
We now offer Symbol Map and Bullet charts so you can produce the data visualizations you need.
Calculated Field Enhancements:
Our redesigned Calculated Field Editor provides many new functions such as autocompletion, syntax highlighting, find and replace, punctuation completion, and much more. New calculated fields and table calculation functions have also been added.
Chart Highlighting:
Chart Highlighting allows you to emphasize specific chart segments and perform an empirical analysis on them. Trend lines and reference lines have been enhanced to dynamically recalculate based upon the highlighted data points.
More Charting Enhancements:
Split large composite strings into multiple fields. Export view data to CSV or Excel. Add effects to your plotted data by applying borders, markers, and halos. Leverage table calculation productivity enhancements and newly added functions.

New in Aqua Data Studio 17.0.12 (Feb 20, 2017)

15025 : Bug : ADS : Hive: Fixed incorrect Hive - Nested Struct's display in the schema tree node, Query Builder and Autocompletion
15024 : Enhancement : ADS : Abbreviations -> Support administrator level abbreviations file
15022 : Improvement : Object Search: DB2 -> Source Search will now include function source
15009 : Bug : ADS : ER Modeler: ERM -> Fix for Data type conversion into Sybase IQ for char(255)
14999 : Bug : ADS : Q Analyzer: Format script changes to remove "c", "g", "k", "m" from SQL beautifier keyword list
14992 : Bug : ADS : DB - PostgreSQL -> Fixed Function with Array type so compilation takes place successfully
14971 : Bug : ADS : App - General: TeraData -> Case Sensitivity support in ANSI mode
14931 : Improvement : ADS : DB - PostgreSQL -> will only be escaped to \ while dollar quoting value is not equal to a single quote
14923 : Improvement : ADS : Tools - Excel Import: Import data from Excel file, provide default value for blank cells to non-nullable columns
14913 : Bug : ADS : App - General: On OSX, cycling through windows with Command+` (tilde) to a Floating Query Window leave keybinding of main frame
14907 : Bug : ADS : Cassandra -> extraction/scripting fixes for tables with columns having static property and primary keys with multiple columns
NONE : Improvement : ADS : Support syntax highlighting for multi-line string literals for PostgreSQL
NONE : Improvement : ADS : Exclude virtual MAC for activation
NONE : Bug : ADS : MySQL -> User Dialog -> Dialog should not fail on warning message return
NONE : Bug : Visual Analytics : Fixed the jTDS bug with date and datetimeoffset
NONE : Bug : Visual Analytics : NPE fixed for Forward Migration V15/V16->V18, Radar chart was not generated in V18
NONE : Bug : Visual Analytics : Changes to include a separate cache to store java.sql.Date objects
NONE : Bug : Visual Analytics : Migration V18 to V17: Fixed NPE thrown for opening vizx file under ADS_V-17 using added dashboard sheet vizx file
NONE : Bug : Visual Analytics : Fixed Backward migration issue for the Table calculation comparative operator First and Last. Address Duplicate keys
NONE : Bug : Visual Analytics : Fixed Backward migration issue for the Table calculation comparative operator First and Last. Update dialog text, type and icon
NONE : Bug : Visual Analytics : Fixed Backward migration issue for the Table calculation comparative operator First and Last
NONE : Bug : Visual Analytics : When opening .qbw that contains unsupported object types, return an error message

New in Aqua Data Studio 17.0.11 (Jan 9, 2017)

New in Aqua Data Studio 17.0.10 (Oct 12, 2016)

New in Aqua Data Studio 17.0.9 (Sep 22, 2016)

New in Aqua Data Studio 17.0.8 (Aug 24, 2016)

New in Aqua Data Studio 17.0.7 (Jul 7, 2016)

New in Aqua Data Studio 17.0.6 (Jun 7, 2016)

New in Aqua Data Studio 17.0.5 (May 27, 2016)

14435 : Bug : ADS : Vertica 7.2 DBA Tools -> Fix for Session Manager's session extraction query, which was not displaying any Session information for Vertica 7.2
14431 : Bug : ADS : Visual Explain -> PostgreSQL and Greenplum : Added a configurable parameter to turn ON/OFF Analyze when explaining a SQL query
14430 : Bug : ADS : Greenplum Visual Explain -> Fix for executing a SQL query twice when Show Execution Plan is turned on
14426 : Bug : ADS : SQL Server -> Fix for Alter Jobs UI : Alter Job steps menu is modified, so that text box will not overlap the long text in the command text
14420 : Bug : ADS : SQL Server -> Jobs: Fixed case sensitivity issue with Job steps. Modified information retrieval from the Hashmap keys, so that it is not case sensitive
14411 : Bug : ADS : MongoDB -> Added File -> Options -> Results -> Grid Results -> Maximum number of columns allowed
14409 : Bug : ADS : ER Modeler -> IBM DB2 iSeries -> Script Alter Table Drop Constraint -> Qualify objects will now be taken into consideration while scripting the constraint name
14408 : Bug : ADS : ER Modeler -> Fixed the issue with Compare ER model and database which was not scripting constraints on table objects
14407 : Bug : ADS : ER Modeler -> Fixed issue with scripting. The Script Constraint was missing constraint name and constraint schema
14403 : Bug : ADS : Query Analyzer -> If Show Text is enabled and Show Grid is disabled, then the query results should display the Text view only
14402 : Bug : ADS : File -> Print -> Fixed the character clipping issue in the Query Analyzer with line wrap
14401 : Bug : ADS : Oracle -> Fixed the issue with Table column datatype info that replaced a null value with a string "" value
NONE : Bug : ADS : Restore Workspace : changeDatabaseDirect() on database context restore needs to assure autocommit=true for all databases
NONE : Bug : ADS : Teradata : When query window initially opened and autocommit=false in Teradata & Informix, do not prompt commit/rollback confirmation on database context change
NONE : Bug : ADS : Changed sequence in setting auto-commit of connection when creating new Query Window to prevent an open transaction
NONE : Bug : ADS : Fixed ADS freezing for MongoDB Grid Results with a large number of columns in collections

New in Aqua Data Studio 17.0.4 (Apr 21, 2016)

14393 : Bug : ADS : MySQL -> ER Modeler -> Fix for numerical datatypes precision which was always being set to 15
14392 : Bug : ADS : Oracle -> Fix for Materialized views extraction/scripting. Objects were getting displayed multiple times in the Schema Tree node
14391 : Bug : ADS : Oracle -> Fix for Jobs: Alter jobs was giving java.lang.NoSuchFieldError exception
14390 : Bug : ADS : Oracle -> Materialized Views -> Added support in the Schema Script Generator, Object Search & Schema Compare Tools
14381 : Enhancement : Visual Analytics : Added support for MEDIAN on Measures
14380 : Bug : ADS : Oracle -> Job UI -> Fix for Alter job which was incorrectly setting job class and not correctly scripting pl/sql block changes
14379 : Bug : ADS : Oracle -> NPE handling for job schedule type, when it is not set
14378 : Bug : ADS : Sybase ASE -> Details Pane was not displaying information in Tree, Indexes node. Datatype bigint was not introduced until version 15.x
14377 : Bug : ADS : Oracle -> Instance Manager -> Added the job STATE property column
14375 : Bug : ADS : Oracle -> Oracle Jobs -> Fix to insure that any string values encapsulated in a single quote are escaped
14372 : Bug : ADS : File -> Options -> Scripting -> -> ';' statement separator option will now change the flag and save the option correctly
14368 : Bug : ADS : Oracle -> Job UI -> Fix for TIMESTAMPTZ method requires Oracle's connection object
14364 : Bug : ADS : Oracle -> Instance manager -> Start Job UI will now offer Use Current Session option
14362 : Bug : ADS : IBM DB2 iSeries -> Fix for Compare issues in ER Modeler
14361 : Bug : ADS : Hive -> Fix for issues with MapR Impala table columns and tables where the owner field is null
14355 : Bug : ADS : MongoDB -> Fix issues with expanding Collections, Indexes nodes when connecting to a secondary replica set member only
14345 : Bug : ADS : Sybase ASE -> Fix in extract/scripting Table with computed columns will correctly create the computed column definition string
14343 : Bug : ADS : SAP Hana -> Fix to Import data into binary datatype, should construct string field correctly
14342 : Bug : ADS : SQL Server -> Schema Compare -> UDF with unsupported DDL extraction will no longer throw NPE
14340 : Bug : ADS : Schema Compare: Fix to ignore blank lines in the generated DDL
14337 : Bug : ADS : MS SQL Database (Azure): Fix for File -> Options -> Results Format for Azure
14330 : Bug : ADS : MongoDB: Added support for DBPointer
14328 : Bug : ADS : Schema Compare: Fix to ignore embedded spaces in the generated DDL
14316 : Bug : ADS : Oracle -> Fix to debug package procedure with no parameters in oracle 12c
14315 : Bug : ADS : MySQL -> Fix to allow default value to script without single quote when date time function used with fractional seconds
14303 : Bug : ADS : Changed formatting for date/time/timestamp datatypes with NONE formatting to use UTC time zone
14302 : Bug : ADS : Apache Cassandra: Use UTC time zone if date format is [None] or "yyyy-mm-dd HH:mm:ssZ"
14285 : Bug : ADS : Excel -> Added Excel connection support for SET COLLATION, SET BINARY_COLLATION
14276 : Bug : ADS : MongoDB -> Fix to enclose database name in quotes in USE statement
14265 : Enhancement : Visual Analytics : Added support for Count Distinct - COUNTD
13278 : Bug : ADS : RedShift -> Extraction of constraint column info column conkey & confkey return arraytypes with new redshift driver
NONE : Bug : ADS : Script table : Fixed the Default value which was set to null if it didn't fall under correct rules
NONE : Bug : ADS : Change German translation for Informix Schema Object "dbspace" to "DB-Space"
NONE : Enhancement : ADS : Added "$" as acceptor for double click selection of words in editor
NONE : Enhancement : ADS : PostgreSQL -> version 9.4 product major minor extraction & ER Modeler -> Support for version 9.3 & 9.4
NONE : Enhancement : Visual Analytics : COUNTD function is not available in filter pop-up window of date dimension & measure if placed in filter deck
NONE : Enhancement : Visual Analytics : Fix for ADS crash when trying to render Filled Map chart in Windows

New in Aqua Data Studio 17.0.3 (Feb 11, 2016)

New in Aqua Data Studio 17.0.2 (Feb 2, 2016)

New in Aqua Data Studio 17.0.1 (Jan 31, 2016)

New in Aqua Data Studio 17.0.0 (Jan 28, 2016)

SAP Hana:
Dive into SAP HANA: You can now connect to SAP HANA, an in-memory database and application platform to query and analyze your big data and gain valuable insights.
APACHE SPARK:
Query Spark Clusters: You can now connect to Apache Spark, the blazing fast in-memory large-scale data processing engine.
MongoJS Query Analyzer:
Run MongoDB JavaScript commands: Our new MongoJS Query Analyzer can execute MongoDB javascript commands and display the results in a tree hierarchy. MongoJS also supports autocompletion, syntax highlighting and pretty print JSON text results.
VISUAL EXPLAIN PLANS:
Explain Plans for 7 More Databases: You can now use Explain Plans in Text format for Amazon Redshift, Greenplum, ParAccel, Teradata Aster, Netezza, PostgreSQL and MySQL to help reduce SQL query bottlenecks.
GOOGLE BIGQUERY:
Query & Analyze BigQuery Datasets: Connect to Google BigQuery, a cloud-based big data analytical web service, to explore your projects, run SQL queries and use the intuitive visual editors for all your BigQuery datasets.
Expanded DBA tools:
DBA Tools for 11 More Databases: We now support DBA tools for Amazon RedShift, PostgreSQL, Greenplum, Teradata Aster, Netezza, ParAccel, Informix, Sybase Anywhere, Sybase IQ, Teradata, and Vertica.
EXCEL improvements:
Excel SQL SELECT using WHERE: We now support MS Excel WHERE, ORDER BY, GROUP BY, HAVING, and JOIN clauses that give you the ability to connect, query, and generate results from XLS and XLSX files.
Excel Import Wizard: Our new Excel Import tool imports data directly from single or multiple Excel sheets into existing or new database tables.
New database versions:
More DB Version Support: Connect to Cloudera 5.4, HortonWorks 2.3, MapR with Spark, IBM DB2 z/OS 11, PostgreSQL 9.4.1 and VoltDB 5.5.
More Visual Analytics:
9 New Charts: We now offer nine new charts: Filled Map, Highlight Table, Heat map, Funnel, Gauge, Horizon, Mekko, Radar, and Sunburst so you can produce the data visualizations you need.
Reference Lines and Box plots: Reference lines, bands, distributions and box plots offer a powerful new way to highlight aspects of specific interest in a given data set.
R Integration with Visual Analytics: Our new R integration enables you to incorporate advanced statistical computing directly into Visual Analytics.
Text and Images in Dashboard: You can now add Text and Image objects in dashboards. These objects increase the visual appeal of your dashboards and enable you to share key analysis about your data.
Customizable Color Legend: Our new color legend provides sequential and diverging color themes, the freedom to divide colors into discrete steps and a customizable color gradient range.
Date and Time Hierarchy Navigation: Our new navigational enhancement significantly reduces the number of clicks to drill down into date and time fields.

New in Aqua Data Studio 16.0.13 (Jan 25, 2016)

New in Aqua Data Studio 16.0.10 (Dec 2, 2015)

New in Aqua Data Studio 16.0.9 (Oct 8, 2015)

New in Aqua Data Studio 16.0.7 (Sep 24, 2015)

13751 : Bug : ADS : DBA Tools - Session Manager: Session tree nodes are not displayed in sorted order after Refresh
13748 : Bug : ADS : DBA Tools - Session Manager: Display bug in ADS Session Manager on Sort
13718 : Bug : ADS : MS SQL Server -> Identity DDL string creation NPE error fixed
13715 : Bug : ADS : Add option "/" Statement separator with default value of Enabled
13708 : Bug : ADS : Cassandra 2.2.x -> modification to support 2.2.x
13691 : Bug : ADS : RedShift -> Extract/scripting changes for grantee type
13671 : Bug : ADS : Ctrl-shift-[UP/DOWN] no longer moves to bookmark position in editor
13668 : Bug : ADS : Debugging with a named instance gives The PORTNUMBER connection property is invalid
13570 : Enhancement : ADS : Add method AQExcelSpreadsheet.setCell( row, col, value, Font, backgroundColor, foregroundColor )
13564 : Bug : ADS : Fix OID problem for PostgreSQL batch import
13558 : Bug : ADS : Support all data types for PostgreSQL batch import, Fixed INET, CIDR and MACADDR
13451 : Bug : ADS : Fix usage of DataCache to use final value instead of intermediate value
13389 : Bug : ADS : Fix NPE when stopping query on a bad Query Window (Connection already closed)
13380 : Bug : ADS : Change server throw NPE when connection already closed. Display text from original Query Window
13372 : Bug : ADS : MongoSQL - Cache the resultset (returned by DBCursor#iterator() ) internally
13366 : Bug : ADS : Result set pinning implementation may cause memory leak
13344 : Bug : ADS : Querypanel -> introduce columns and introduce qualified columns will now use the column open/close identifiers
13330 : Bug : ADS : PostgreSQL -> New option added for Dollar Quoting variable. Option affects function text body and if not a single quote body will not escape single quotes
13297 : Bug : ADS : Teradata -> users extraction info -> V table was not set for version 14.1 and above on users table
13290 : Enhancement : ADS : IBM DB2 iseries -> Logical file menu items. Missed menu for logical files object folder
13289 : Enhancement : ADS : IBM DB2 iseries -> Logical file icon
13288 : Bug : ADS : Teradata -> Use [V] views for 14.10 and above where possible
13044 : Bug : ADS : During memory cannibalization, check to see if the table model's dataset has been referenced by others. If not, clear the dataset to free memory for the next query
NONE : Enhancement : ADS : Added MERGE to Informix SQL syntax
NONE : Bug : ADS : Auto-reconnect for Sybase. Customer problem where retry menu was not displayed when network disconnects. Sybase was throwing exception
NONE : Enhancement : ADS : Remember Password = Unchecked, the login name is displayed instead of ~`credsecure::username`~
NONE : Enhancement : ADS : Retrieving User Credential Outside the Application - Secure Storage Mechanism
NONE : Bug : ADS : NPE on expand tree node, after deleting the secured storage username and password
NONE : Bug : Visual Analytics : Marking the BIExpressionCalculatedColumn instance associated to a bin field as invalid; exception occurs during revalidation (datasource is refreshed)
NONE : Bug : Visual Analytics : Performing full traversal on pivot data model when running totals are present
NONE : Bug : Visual Analytics : Marking measure field as invalid when aggregation type is unknown
NONE : Bug : Visual Analytics : Properly preventing intermediate pivot model computation when loading workbook
NONE : Bug : Visual Analytics : Aborting intermediate model computations when loading workbooks
NONE : Bug : Visual Analytics : Unregistering the model and GUI listeners when the worksheet pane is rebuilt
NONE : Bug : Visual Analytics : Checking if bin fields are referenced by calculated fields
NONE : Bug : Visual Analytics : Checking if BIExpressionCalculatedColumn is valid before quering it for depending aggregates
NONE : Bug : Visual Analytics : Fixing some CCE that were thrown when INTEGER() or FLOAT() functions were used on string parameters
NONE : Bug : Visual Analytics : Fixing memory leak in TableModelPivotDataSource
NONE : Bug : Visual Analytics : Fix Memory Leak in VA
NONE : Bug : Visual Analytics : Preventing NPE from being thrown when backward-migrating workbooks that contain calculated fields having unrecognized function names
NONE : Bug : Visual Analytics : Duplicate dimension get created in Break deck on converting data type of date dimension to Number
NONE : Bug : Visual Analytics : NPE exception for trend line for include field for factors
NONE : Bug : Visual Analytics : Indexoutofbounds exception is displayed in View log for linear trend line. Distinguish between trendpercolor and multiple colorKeys
NONE : Bug : Visual Analytics : Trend lines are not displayed as per color. Some Trend lines are missing

New in Aqua Data Studio 16.0.5 (May 1, 2015)

New in Aqua Data Studio 16.0.4 (Apr 18, 2015)

13249 : Bug : ADS : App - Visual Editing : Stored Procedure Properties for Databases except MSSQL Server was giving NPE
13248 : Bug : ADS : Extraction : Sybase ASE -> Extraction of index and storage information -> Arithmetic overflow
13237 : Bug : ADS : App-General : Sybase ASE Drop Function option was throwing NPE
13234 : Bug : ADS : Tools - Schema Script Generator : ADS incorrectly scripts MSSQL tables with Data compression and Table Partitioning
13222 : Bug : ADS : Pinning : For multiple SQL's vertical scrollbar wasn't appearing making it difficult to read Query Results in grid
13216 : Bug : ADS : Informix : Create Object GUI : gets displayed initially and then disappears
13215 : Bug : ADS : SQL Server : Create Object GUI : Schema defaults to the first schema instead of dbo
13212 : Enhancement : ADS : Enhance Generic JDBC schema browser to display schemas specific to DB
13207 : Bug : Visual Analytics : Timestamp gets displayed as String Dimension
13203 : Enhancement : ADS : SQL Server : Drop Trigger confirmation message improved
13201 : Enhancement : ADS : Support for extended stored procedures in Sybase ASE 15.5+
13200 : Bug : ADS : Datatypes missing in Vertica ER Modeler and Create Table GUI
13179 : Bug : ADS : Informix 12.10 : Unable to perform SQL for BSON Datatype with Transaction Type = Batch
13178 : Bug : ADS : Informix 12.10 : Import Data caused exception with Transaction Type = Batch
13177 : Bug : ADS : PostgreSQL 9.3 : Unable to export data for bit datatype
11787 : Bug : ADS : Missing option File->Options->Results->Message Results->Enable Undo
10956 : Enhancement : ADS : Support node for Projections in Vertica RDBMS
NONE : Bug : Visual Analytics : Right on Pinned Tab Header was giving java.lang.ClassException
NONE : Bug : Visual Analytics : Trend Line Details window displays incorrect information after Swap Rows & Columns
NONE : Bug : Visual Analytics : Trend Line for Merged Axes displays separate section for each measure with 0 and NAN values
NONE : Bug : Visual Analytics : Exponential Trend Line 'R-squared' and 'p-Value' displayed on tooltip are not in sync with those displayed in Trend Line Details window
NONE : Bug : Visual Analytics : Trend line details observation does not display if fields are in rows deck
NONE : Bug : Visual Analytics : NPE on Tooltip using keyboard shortcut CTRL+Z
NONE : Bug : Visual Analytics : Proper Tooltip was not getting displayed for Undo-Redo for Visualization component
NONE : Bug : Visual Analytics : Wrong syntax for DATETRUNC() function displayed in the description
NONE : Bug : Visual Analytics : Undo-Redo was causing Exception on Calculated Fields and Parameters
NONE : Bug : Visual Analytics : Calculated Fields enhancements on two users using different locales exchanging workbooks containing date or number calculated fields
NONE : Bug : Visual Analytics : Trend Line does not get displayed for Shape chart with Parameters of type Float or Integer
NONE : Bug : Visual Analytics : Measure Names field option is not listed under Options pane
NONE : Bug : Visual Analytics : After changing date grouping polynomial trend line is displayed at proper place

New in Aqua Data Studio 16.0.3 (Apr 1, 2015)

13193 : Bug : ADS : Schema Script Generator : NCluster -> Version 4.6+ -> Schema Script Generator -> Include Table Storage option to script the Partitions
13186 : Enhancement : ADS : DB2 iSeries -> Logical files are now displayed under the Views node in the Schema Tree and also displayed in the Query Builder & Object Search
13166 : Bug : ADS : Query Analyzer : Tab name "OBJECT_TYPE - OBJECT_NAME" is not persisted on relaunching ADS
NONE : Enhancement : Visual Analytics : Undo edit parameter with data type change rebuilds worksheet twice
NONE : Enhancement : Visual Analytics : Gradient Blue Color theme should be selected when we Reset the color theme on Bin field
NONE : Bug : Visual Analytics : In Pivot table, wrong default color shows when ignored field in color deck
NONE : Bug : Visual Analytics : Treemap > color field > apply secondary date options > date format on tooltip and in view data window is different
NONE : Bug : Visual Analytics : Invalid filter card is generated when we change datatype of parameter for calculated field and Undo it
NONE : Bug : Visual Analytics : Date & time values are not displayed properly if calculated field containing table calculation function is available in data pane
NONE : Bug : Visual Analytics : Aggregated calculated field value should be null if it is invalid
NONE : Bug : Visual Analytics : NPE throws on changing chart type from Pivot table when when grand totals are applied
NONE : Bug : Visual Analytics : Top N Filter effect should be discarded if we change the datatype of filter field
NONE : Bug : Visual Analytics : Particular chart name should display instead of "Automatic" in first and second accordion
NONE : Bug : Visual Analytics : SUBSTRING() function gives incorrect result when we exceed the position from its length by 1
NONE : Bug : Visual Analytics : Chart appears black then to default color in dashboard
NONE : Bug : Visual Analytics : Undo is not working properly for Color style of horizontal chart
NONE : Bug : Visual Analytics : Incorrect Dual Combination chart is generated & from Chart Properties pane,Color & Axes decks are missing
NONE : Bug : Visual Analytics : Blank chart is displayed on undo for all charts except table
NONE : Bug : Visual Analytics : Indexoutofbounds exception is displayed in View log on Redo after selecting High low close icon from Visualization tab
NONE : Bug : Visual Analytics : As per applied trend line model type,model formula is not displayed

New in Aqua Data Studio 16.0.1 (Mar 21, 2015)

New in Aqua Data Studio 15.0.15 (Mar 14, 2015)

11916 : Bug : Visual Editing : IBM DB2 UDB 10.5 Security - Create Groups, Roles and Users gives SqlSyntaxErrorException
11923 : Bug : DBA Tools : DB2 : Session Manager : IBM DB2 UDB 10.5 - No authorized routine named "SNAPSHOT_APPL"
12144 : Bug : Visual Editing : IBM DB2 UDB 10.5 SqlSyntaxErrorException: "TABLESPACE_NAME" is not valid in the context where it is used..
13058 : Bug : Editor : Opening a large file in Query Analyzer - results in IndexOutOfBoundException
13064 : Bug : Query Analyzer : Parameterized Scripts : Parameterized Script: User would like to declare a variable and use it in a filename for export
13068 : Enhancement : FluidShell : Investigate enhancing FluidShell \session and \connect command to allow attaching to Query Analyzer connections
13083 : Bug : FluidShell : Session command is only showing name in QA Window for shared connections
13085 : Bug : Table Data Editor : PostgreSQL : Should check "show standard_conforming_strings" in ConnectionProperties.requiresEscapeBackslash()
13087 : Bug : Table Data Editor : PostgreSQL : Type databases may need to check "show standard_conforming_strings" in ConnectionProperties.requiresEscapeBackslash()
13099 : Enhancement : Query Analyzer : Hive : Add cancel query support
13101 : Bug : Query Analyzer : Choose Server or Database dialog performance improvement
13103 : Enhancement : MongoDB : Support CaonicalizeHostName property in MongoDB enterprise
13104 : Enhancement : Server Registration : Hive : Default to "HiveServer2"
13114 : Enhancement : DB2 iSeries : Primary key constraint > Scripting > schema should be present in constraint name
13116 : Bug : Tools - Import Tool : PostgreSQL : Importing data to new table will open many new connections
13117 : Bug : Tools - Import Tool : PostgreSQL : Detail View of the PostgreSQL 9.4 "Process Info" node doesn't show sessions
13118 : Bug : Tools - Import Tool : PostgreSQL : Importing data into UUID on PostgreSQL in Batch mode gives error
13132 : Bug : Server Registration : Sybase ASE : File > Options > General > Sybase quoted_identifier (Default) is not reflected
NONE : Bug : Hive : Added Cloudera JDBC 41 to CoreHiveDriver so JDBC 41 drivers can be detected.
NONE : Bug : SQL Server : Return value of BIT should be INT and not BOOL
NONE : Bug : Schema Browser : Tooltip text in Connect to Server dialog can take a long time to process if login/password info is retrieved from an external process
NONE : Bug : Visual Analytics : When a label becomes invalid, set aggregation to default if it is invalid
NONE : Bug : Visual Analytics : When a label becomes valid, correct aggregation and table calculation type if they are valid
NONE : Bug : Visual Analytics : Fixed ArrayIndexOutOfBoundsException
NONE : Bug : Visual Analytics : Ignore invalid mapped column indexes error if workbook has been downgraded
NONE : Bug : Visual Analytics : Fixed NPE in Table Calculation code
NONE : Bug : Visual Analytics : If chart type is not supported, default to Automatic
NONE : Bug : Visual Analytics : In 'Filter Field' window select 'Count' for date > In filter card, date is displayed instead of count when we try to manually change value
NONE : Bug : Visual Analytics : Ctrl + drag and drop allows adding duplicate field in filter deck (Specific to date dimension)
NONE : Bug : Visual Analytics : Backward Migration : Table Calculation : Rank/Percentile changes to "Difference from" in v15, but chart "difference from" table calculation is not displayed
NONE : Bug : Visual Analytics : Backward Migration : Table Calculation : Use a calculated field using table calculation function in chart, open this file in v15 exception is thrown in view log
NONE : Bug : Visual Analytics : Migration : Infinite NPEs are displayed after opening vizx containing calculated field
NONE : Bug : Visual Analytics : Backward Migration : Treemap opened in v15 returns Unsupported aggregation ID in error log
NONE : Bug : Visual Analytics : Backward Migration : Shape Chart with calculated fields opened in v15 returns ArrayIndexOutOfBounds Exception
NONE : Bug : Visual Analytics : Backward Migration : Table/Pie Chart gives NPE in v15

New in Aqua Data Studio 15.0.14 (Feb 6, 2015)

New in Aqua Data Studio 15.0.13 (Jan 30, 2015)

11494 : Bug : Server Registration : VoltDB : Wrong link for "Online help - VoltDB JDBC Drivers"
11829 : Bug : Oracle : Oracle 12c System generated column should not be included in Insert script generated by ADS
12366 : Bug : Sybase Anywhere : Sybase Anywhere 12 Execute window, Parameter list is missing when creating via "Create Procedure in Editor"
12684 : Enhancement : Shortcut Toolbar : If password save unchecked don't force two Authentications following incorrect password use
12687 : Bug : Server Registration : Sybase (ASE, IQ, Anywhere) : Permissions tab DDL on drops of temp table not working
12691 : Enhancement : Visual Editing : MS SQL Server 2014 : Server Audit specification - need to Improve validation pop up message
12724 : Enhancement : Generic JDBC : Add Index Columns in Schema Browser for Generic-JDBC
12729 : Bug : Hive : Impala : Expanding schema tree(tables) causing excessive connections to database
12765 : Bug : ER Modeler : java.lang.IllegalArgumentException "Save All as Images" & "Generate HTML Report" when sheets with no entities added
12785 : Enhancement : Visual Editing : Netezza : Support Procedure Edit GUI
12788 : Bug : Server Registration : Hive : Apache Hive Include and Exclude Folders options of Filter tab are not working properly
12864 : Bug : DBA Tools : DB2 : Session Manager : DB2 10.1 displays as empty - exceptions in SQL Log
12867 : Bug : Server Registration : Hive : Impala : Objects are not filtered out on creating Object Folder filter in Server Register window
12917 : Enhancement : Server Registration : Hive : Add additional drop down selection for User Name only in server properties panel
12935 : Bug : Server Registration : MS Excel : Link to landing page at bottom of General tab incorrect
12954 : Bug : SQL Automation : Hive : HortonWorks 2.2 : Automate > Introduce INSERT Statement gives exception
12974 : Bug : ER Modeler : Hive : Impala : Default length for Char and Varchar datatype is not getting assigned
12976 : Enhancement : Visual Editing : Hive : Impala : Set default precision value '9' for decimal datatype column
12984 : Enhancement : Server Registration : Sybase IQ : connection url for iAnywhere Driver for Multiple Databases
12988 : Bug : Schema Browser : Floating schema browser window - F5 or refresh inside it - focus sent to Query Analyzer and query executes
12993 : Bug : ER Modeler : Hive : Apache Hive : Incorrect validations in Table Storage Property tab
13003 : Enhancement : Hive : Apache Hive Version .14 changes
13022 : Enhancement : Hive : Support AWS EMR
13029 : Enhancement : Hive : Retrofit changes from V16 to V15 to handle Cloudera Simba drivers
13039 : Bug : App - General : Command line scripts should load jars under /lib folder
13042 : Enhancement : Hive : Add "Database" field in Register Server Dialog for Hive Connection
13045 : Enhancement : Hive : User should be able to enter driver parameters instead of principal in server properties when using Kerberos
13053 : Bug : DBA Tools : MS SQL Server : Job Schedule - Active End Time was getting truncated
13056 : Bug : Import Tool : Informix : If new table is a temp table do not provide schema association for insert script creation
13057 : Enhancement : Hive : For Kerberos, Server Properties Window and Connection should handle/translate Principal to properties
13060 : Enhancement : Query Analyzer : Enhance Custom SQL Filters
13061 : Enhancement : Query Analyzer : Query Window permissions on sqlfilter needs to ignore client & server side comments
13064 : Bug : Query Analyzer - Parameterized Scripts : User would like to declare a variable and use it in a filename for export
NONE : Bug : ER Modeler : Update MongoDB version in ER Modeler
NONE : Enhancement : Visual Analytics : Improved backward compatibility with future versions
NONE : Bug : Visual Analytics : After changing Data type to Default, default values are not persisted
NONE : Bug : Visual Analytics : Filter : No data sample in popup menu after dropping date filter with count()
NONE : Bug : Visual Analytics : Calculated Fields : Converted calculated field is not restored correctly on reading in saved workbook
NONE : Bug : Visual Analytics : Memory leak during Auto-Refresh

New in Aqua Data Studio 15.0.11 (Nov 14, 2014)

New in Aqua Data Studio 15.0.10 (Nov 7, 2014)

12471 : Enhancement : Export Tool : Export by SELECT statement should ignore leading SQL comments
12480 : Bug : Excel : Table does not exist when connections are pooled
12480 : Bug : Excel : Do not change schema when pooledConnection is on for Excel
12510 : Enhancement : Excel : Autocompletion : support autocompletion of column names for Excel connection type
12543 : Enhancement : Apache Cassandra : Support Cassandra 2.1.0
12548 : Bug : FluidShell : NPE on excel2csv -s command with Chinese Characters in excel
12565 : Enhancement : Schema Compare : SQL Server : SQL Server 2014 comparing two Database Audit Specifications gives blank results
12567 : Bug : Visual Editing : SQL Server : Not able to add a new Audio Action if first action is deleted
12568 : Enhancement : Visual Editing : SQL Server : Add Server Audit Name label for drop down in Create Server Audit Specification
12572 : Bug : Detail View : SQL Server : Incorrect icons in Detail View when viewing Server Audit details
12577 : Bug : Visual Editing : SQL Server : Database Audit Specification unable to add new Audit Action if all actions deleted
12581 : Bug : Object Search : SQL Server : SQL Server 2000 gives exception if Source Search - Trigger Source is enabled
12582 : Enhancement : Visual Editing : SQL Server : Database Audit Specification GUI issue with Create/Alter to make it consistent with rest of the application
12583 : Bug : Excel : Disable compare for multiselecting two columns
12584 : Enhancement : Excel : Improve show column command to make it consistent with other DBs
12585 : Bug : Visual Editing : SQL Server : Database Audit Specification - Audit Action is not getting selected
12586 : Bug : Excel : Two different behaviors when multiselecting tables
12594 : Bug : Query Analyzer : Autocompletion limitation with aliased subquery
12657 : Enhancement : Server Registration : Update link to Aster JDBC Driver in Server Registration test connection dialog
NONE : Enhancement : SQL Server : Always enable Audits for versions 2008 and above
NONE : Enhancement : Visual Analytics : Add a "Do not show again" checkbox to the extract informational dialog
NONE : Enhancement : Visual Analytics : Behavior of Accept Default option on filter pop up
NONE : Enhancement : Visual Analytics : Performance degrades after enabling Data labels
NONE : Bug : Fixing file separator consistency issues
NONE : Bug : Object Search : SQL Server : Searching on procedure source returning additional and incorrect rows
NONE : Bug : SQL Server : Audit Dialog - removed ":" from State Enabled check box label
NONE : Bug : Visual Analytics : While processing or changing sort order the pivot table UI gets disturbed
NONE : Bug : Visual Analytics : Memory leak
NONE : Bug : Visual Analytics : Data Model - Dimensions and Measures : Sort icon is not displayed on dimension fields present in decks, after converting dimension to measure
NONE : Bug : Visual Analytics : Error message or Show Trend Line option should be disabled when trend line not supported
NONE : Bug : Visual Analytics : Unable to resize Filter Deck when the all fields in Filter Deck are converted to Measure
NONE : Bug : Visual Analytics : Double click on axes makes ADS unresponsive, requiring a force quit sometimes
NONE : Bug : Visual Analytics : After refresh applied, sort order gets changed and displays in its default order
NONE : Bug : Visual Analytics : Default color is not applied when we replace a measure field with any other measure field
NONE : Bug : Visual Analytics : NPE when computing Moving Calculation on nested subtotals
NONE : Bug : Visual Analytics : After auto-refresh occurs the selected function is not applied on the fields
NONE : Bug : Visual Analytics : Calculated field value varies in Chart and Color card
NONE : Bug : Visual Analytics : Avoiding auto number formatting on pivot table header cells
NONE : Bug : Visual Analytics : IllegalArgumentException: Default value is not of type java.sql.Timestamp on validating calculated field
NONE : Bug : Visual Analytics : Color of data label points are not updating on applying new color to chart untill refresh
NONE : Bug : Visual Analytics : "Not Available" text is displayed in Filter card for field which contains value and is present in Columns Deck
NONE : Bug : Visual Analytics : Sort icon overlap during column level sort order swapping
NONE : Bug : Visual Analytics : Switching to worksheet whose name is shorter goes to third worksheet instead of second
NONE : Bug : Visual Analytics : dashboard Pie chart datalabels are not auto-refreshed
NONE : Bug : Visual Analytics : Left followed by right mouse clicks invoke default popup action in Data Pane
NONE : Bug : Visual Analytics : Take into account some double-click peculiarities on OSX
NONE : Bug : Visual Analytics : ConcurrentModificationException during continuous clicks on column level sort icon
NONE : Bug : Visual Analytics : Swapping datatypes followed by dimension to measure conversion causes ClassCastException
NONE : Bug : Visual Analytics : Automatic Number Format algorithm decimal issue
NONE : Bug : Visual Analytics : Charts throw NPE after sorting and then DnD same field in Columns/Rows deck
NONE : Bug : Visual Analytics : Parameter field not shifting after changing datatype of parameter
NONE : Bug : Visual Analytics : Only first color in color theme is applied, If we first apply filter and then color theme
NONE : Bug : Visual Analytics : Format of value is not updating immediately
NONE : Bug : Visual Analytics : Unable to perform edit data type operation for parameter field after auto-refresh
NONE : Bug : Visual Analytics : On changing datatype of any field subtotal column get removed from pivot table
NONE : Bug : Visual Analytics : Duplicate field name is created on changing "Max Results"
NONE : Bug : Visual Analytics : Only ascending sort is possible,if same measure fields are in same deck and sorting is applied

New in Aqua Data Studio 15.0.9 (Oct 15, 2014)

11702 : Bug : Informix : Unable to drop procedures containing varchar or char datatype as parameter in Informix 12.1
11791 : Enhancement : Oracle : Syntax highlighting for Oracle Keywords
11938 : Bug : Excel : Duplicate Schema displayed in Schema Browser when .xls file is open in background
12494 : Bug : Informix : Execute Edit on Informix is failing
12501 : Enhancement : Create Kerberos support information under Help menu
12517 : Bug : SQL Server : Query Analyzer : execute edit throws failed to locate table error for SQL Server
12522 : Bug : App : General : Upper on database side compared to java toUpper() on client side does not always match
12521 : Bug : App : General : Double clicking .sql files will not open the file
12525 : Enhancement : Teradata Aster : Add Function Lookup button to Query Analyzer toolbar for Teradata Aster v6 and greater
12526 : Bug : Informix : Procedure Editor : Modifying existing Stored Procedure gives "A syntax error has occurred."
12528 : Enhancement : Server Registration : Add static driver parameter(properties) information for databases that don't dynamically extract
12529 : Enhancement : Server Registration : Data Warehousing "Write Only" mode
12531 : Enhancement : DB2 : Allow editing of Graphic, VarGraphic fields in DB2 z/OS, LUW and iSeries in Table Data Editor
12549 : Enhancement : Teradata : Added support for XML, number, time with zone, timestamp with zone, JSON datatypes
NONE : Enhancement : Query Builder : Quick table add dialog in settings by default “select none” should be checked instead of “select indexed columns”
NONE : Enhancement : Visual Analytics : Allow drag and drop of items to create Favorites
NONE : Enhancement : Visual Analytics : Allow color selection for individual items in Individual Axis chart
NONE : Enhancement : Visual Analytics : Show filter option for multiple selected fields
NONE : Enhancement : Visual Analytics : Automatic number format algorithm
NONE : Enhancement : Visual Analytics : Drag and drop to filter deck produces a filter options dialog
NONE : Enhancement : Visual Analytics : Improve performance when large number of distinct records placed in columns deck
NONE : Enhancement : Visual Analytics : Display table summary tab information color deck fields
NONE : Enhancement : Visual Analytics : Cancel button should be renamed to Close after changes in edit axis dialog
NONE : Enhancement : Visual Analytics : Shift apply button to right side in add table calculation window
NONE : Enhancement : Visual Analytics : Prompt user on delete of calculated field parameter field
NONE : Enhancement : Visual Analytics : When user performs long operation, the view area will show blank grey screen for 2 seconds. Beyond 2 seconds, we display “Computing Visualization…”
NONE : Enhancement : Visual Analytics : Optimize table column widths
NONE : Enhancement : Visual Analytics : Change rename dialog size and button layout
NONE : Enhancement : Visual Analytics : Implement data label cache to fix edge conditions
NONE : Bug : App : General : does not open .sql file the first time file is double clicked
NONE : Bug : Informix : Added Informix DBCENTURY, DBDATE, GL_DATE, GL_DATETIME to properties lookup
NONE : Bug : Genreric JDBC : Generic JDBC fails on .setFetcSize()
NONE : Bug : Visual Analytics : First/Last behavior related sorting issues
NONE : Bug : Visual Analytics : AutoRefresh causing focus shift from main window to Visual Analytics window
NONE : Bug : Visual Analytics : Packaged workbook worksheet not resized if there is an empty deck in dashboard
NONE : Bug : Visual Analytics : Field details missing in cell tooltip
NONE : Bug : Visual Analytics : Dragged field should replace an existing field
NONE : Bug : Visual Analytics : Measure fields displayed as discrete when used in invalid calculated field
NONE : Bug : Visual Analytics : Valid name not accepted for date parameter
NONE : Bug : Visual Analytics : Out of bounds exception on changing filter single value to dropdown
NONE : Bug : Visual Analytics : Enhancement : Show values as per top N filter with empty view
NONE : Bug : Visual Analytics : Using connect as in dropdown prevents VA window from opening
NONE : Bug : Visual Analytics : Date axis values not displayed in applied date format after editing axis tick marks to fixed
NONE : Bug : Visual Analytics : Worksheet field name not in sync with data source after rename
NONE : Bug : Visual Analytics : Table and values not displayed properly in dashboard
NONE : Bug : Visual Analytics : NPE when changing chart type from table to vertical bar side by side
NONE : Bug : Visual Analytics : Row header not adjusted until mouse out of header
NONE : Bug : Visual Analytics : Stack overflow on running total calculation
NONE : Bug : Visual Analytics : Invalid drag and drop operation while drag and drop in progress
NONE : Bug : Visual Analytics : Exceptions occur after clicking sort icon
NONE : Bug : Visual Analytics : Referenced field shown twice in alert message following rename calculated field parameter
NONE : Bug : Visual Analytics : Refresh of data changes default data type
NONE : Bug : Visual Analytics : Switching from any chart type to pie or table causes display issue
NONE : Bug : Visual Analytics : Table becomes blank and exception thrown when stretching column width
NONE : Bug : Visual Analytics : Specific formula causes illegal argument exception
NONE : Bug : Visual Analytics : Bar chart horizontal axes field names and values overlapping
NONE : Bug : Visual Analytics : Invalid drag and drop operation when action taken in second window
NONE : Bug : Visual Analytics : NPE when hovering data label tooltip
NONE : Bug : Visual Analytics : Menus overlapping choose a color window
NONE : Bug : Visual Analytics : NPE and chart gray when changing date format field and converting dimension to measure
NONE : Bug : Visual Analytics : Pie chart generates ConcurrentModificationException
NONE : Bug : Visual Analytics : Shape deck shows shape for non shape chart field in merged dual axis chart
NONE : Bug : Visual Analytics : Chart not refreshing on change from multiple value to single value list
NONE : Bug : Visual Analytics : Pressing enter key continuously hangs Visual Analytics
NONE : Bug : Visual Analytics : Calculated fields not showing values until a refresh
NONE : Bug : Visual Analytics : Increasing size of rename window increases its buttons sizes
NONE : Bug : Visual Analytics : Rename not functioning consistently if extract used
NONE : Bug : Visual Analytics : Merged axis not presisted switching from table to other charts
NONE : Bug : Visual Analytics : Connection property incorrect in data source properties
NONE : Bug : Visual Analytics : Pie labels hidden when increasing hiegh of chart
NONE : Bug : Visual Analytics : Showing DB info as a tooltip
NONE : Bug : Visual Analytics : Properties dialog support custom width and height
NONE : Bug : Visual Analytics : Small bug fixed in AND logic
NONE : Bug : Visual Analytics : Favorite highlighting border adds extra space around favorite list when disabled
NONE : Bug : Visual Analytics : RenameFieldDialog message cleanup, log caught exception but only display generic error
NONE : Bug : Visual Analytics : Default renderer for JComboBox is not DefaultListCellRenderer. So we should delegate the changes to the actual renderer to get the default look and feel.

New in Aqua Data Studio 15.0.7 (Sep 20, 2014)

New in Aqua Data Studio 15.0.5 (Sep 20, 2014)

11803: Bug: App: General: Changing ADS Look and Feel to Metal or classic, all MenuItem icons overlaps to labels
11911: Bug: Apache Hive: Schema Compare: Null Pointer Exception on compare of tables due to uncaught database exceptions
12479: Bug: App: General: Import Data tab not retaining server properties Tab Color
12488: Bug: App: Server Registration: Color Palette tab does not persist
12493: Bug: App: General: Look and Feel on Windows set to Aqua Data Studio (Classic) displays incorrectly
12494: Bug: Informix: Execute Edit on Informix is failing
12496: Bug: Grid Results: Result set pane doesn't receive focus when Select All is selected
12500: Bug: DB2 iSeries: Object Search: Physical table types not being searched
12501: Enhancement: Server Registration: Create kerberos support information under Help
12502: Bug: Informix: Null Pointer on CREATE TABLE with latest Informix drivers
12503: Bug: Key Bindings: Cannot remove Duplicate Line key mapping for Ctrl + K
Enhancement: Query Builder: Added menu option for Connection > Edit Connection to allow editing connection information
Enhancement: Visual Analytics: Change the number format's max fraction digits to 16 - only to edit format.
Enhancement: Visual Analytics: Display Table Calculation name in Trend Details instead of measure names for the Table Calculation
Enhancement: Visual Analytics: On applying Number (Standard) wrong value for "Decimal Places" is displayed in Number (Custom)
Enhancement: Visual Analytics: If chart type is table Summary tab information is not displayed for the field which is in Color deck
Enhancement: Visual Analytics: Performance - Precompile frequently used static regex patterns
Enhancement: Visual Analytics: Table performance optimizations
Enhancement: Visual Analytics: Aggregation filter performance optimizations
Enhancement: Visual Analytics: Support a Cancel button inside the computing visualizations dialog
Enhancement: Visual Analytics: Sync calculated and parameter fields in extract and model
Enhancement: Visual Analytics: Resizing the VA workbook is slow in pivot & chart mode part II
Bug: Visual Analytics: Exception on changing filter from Single Value (List) to (Dropdown)
Bug: Visual Analytics: Takes too long to render Table chart with date dimension, and Table calculation is applied to Measure
Bug: Visual Analytics: An invalid field appears when using extract and column has been deleted from data source
Bug: Visual Analytics: Number (Custom) format is always set with maximum fraction digit = 9
Bug: Visual Analytics: Invalid calculated field does not get validated even though we provide validation criteria
Bug: Visual Analytics: Data not displayed in Underlying tab
Bug: Visual Analytics: Auto Refresh consumes too much memory
Bug: Visual Analytics: Rename and Reset have same shortcut key in Rename Field dialog
Bug: Visual Analytics: Continuous 'Date/Time' dimension field does not become valid unless refresh is performed
Bug: Visual Analytics: Calculated and parameter fields being added to table model twice when doing Use Extract
Bug: Visual Analytics: Colors in Color deck of Dashboard tab get removed during Refresh
Bug: Visual Analytics: Aggregation filter not removing empty rows
Bug: Visual Analytics: Parameter (or calculated) field value is not displayed correctly when using extract

New in Aqua Data Studio 15.0.3 (Sep 18, 2014)

New in Aqua Data Studio 15.0.2 (Sep 16, 2014)

New in Aqua Data Studio 15.0.0 (Sep 13, 2014)

New in Aqua Data Studio 14.0.18 (Jul 18, 2014)

New in Aqua Data Studio 14.0.17 (Jun 25, 2014)

New in Aqua Data Studio 14.0.16 (Jun 18, 2014)

New in Aqua Data Studio 14.0.15 Build 38231 (Jun 3, 2014)

New in Aqua Data Studio 14.0.14 Build 37903 (May 16, 2014)

New in Aqua Data Studio 14.0.13 Build 37713 (May 7, 2014)

New in Aqua Data Studio 14.0.12 Build 37636 (May 2, 2014)

New in Aqua Data Studio 14.0.11 Build 37136 (Apr 17, 2014)

10310 : Bug : Sybase ASE : Visual Explain Diagram : String index out of range: 4230
11623 : Bug : Netezza : Visual Editing : Netezza Alter User Throws "java.lang.NullPointerException"
11777 : Bug : Hive : Method not supported message is shown while creating Index
11798 : Bug : SQL Server : OpenAPI : ExtractFunctions OpenAPI methed against MSSQL is very slow and seems to ignore schema parameted
11825 : Bug : Hive : Method not supported message is shown while creating Index
11836 : Bug : Sybase ASE : Extract/scripting of table with computed index is wrong
11837 : Bug : Hive : Cloudera : Can't connect with HiveServer2 for Cloudera Distribution
11840 : Bug : Hive : Aqua Commands : "Query Analyzer, using Hive, reverts the Database drop down back to default after command is submitted"
11850 : Enhancement : Netezza : Import Tool : Retrofit Netezza Batch Import to V14
11851 : Enhancement : SQL Server : Visual Editing : Add support for Extended Properties to the database object
11854 : Bug : Hive : Cloudera : Query Analyzer : Autocompletion for Cloudera in 14.0.10 is not working
11855 : Bug : Hive : Cloudera : Query Analyzer : Use database does not change the database context in the dropdown for Cloudera
11856 : Bug : Hive : Cloudera : ER Modeler : "SQL Exception when you generate ER Diagram in Cloudera, as there are no indexes"
11857 : Bug : Hive : Cloudera : Schema Script Generator : "SQL Exception in Schema Script Generator in Cloudera, as there are no indexes"
11862 : Bug : Hive : Cloudera : Visual Editing : Data type mismatch in ADS Create Table GUI and Cloudera distribution
11864 : Bug : Hive : Query Analyzer : SQL Exception in Query Builder when you add a table
11865 : Bug : Hive : Cloudera : ER Modeler : Data type mismatch in ADS Create Table GUI for ER Modeler and Cloudera distribution
11873 : Bug : Hive : Cloudera : ER Modeler : Disable index node for Cloudera ER Modeler
11876 : Enhancement : Hive : "Added Free Form URL into Authentication Area. Also, eliminated population of realm for Kerberos if KDC is missing"
11878 : Bug : Netezza : ER Modeler : Generate Script is not taking into account the Schema Name
11879 : Bug : Netezza : Query Analyzer : Autocompletion is not displaying Netezza synonyms even when Enabled synonyms in Options
11880 : Enhancement : Netezza : FluidShell : Change schema command for Netezza with multi schema is not working for FluidShell
11884 : Bug : Netezza : Schema Browser : Constraint node for a particular schema displays all constraints in Database
11885 : Bug : Netezza : Visual Editing : Foreign Key Match Type comes with keyword UNSPECIFIED which gives error in Netezza
11886 : Enhancement : Netezza : Visual Editing : Qualify Object w/ Schema and Netezza 7.0.3 Multi Schema support
NONE : Bug : Sybase ASE : Functional indexes -> index can have non function and functional parameters
NONE : Bug : Hive : Cloudera : ER Modeler : Removed DATE/DATETIME, and Ordered Hive distributions.
NONE : Bug : Hive : Cloudera : ER Modeler : Eliminated ER index addition within the main menu
NONE : Bug : Decode the username for SQL Server Windows Authentication

New in Aqua Data Studio 14.0.10 Build 36591 (Mar 14, 2014)

New in Aqua Data Studio 14.0.9 Build 36459 (Mar 6, 2014)

10211 : Enhancement : Visual Editing : User Defined Data Types with multiple column is not extracted correctly
10363 : Bug : ER Modeler : Unique option is enabled in create index window
11364 : Enhancement : FluidShell : No Connection Found for a connection not in .datastudio\connections folder for runfluidscript
11418 : Enhancement : Query Analyzer : Netezza : For Netezza 7.0.3 and below, improve the SQL for DESC to ignore the owner
11480 : Bug : Query Analyzer : MySQL : Auto-Complete with a login with a dot
11541 : Bug : Visual Editing : NOT NULL gets appended to foreign key all the time
11639 : Bug : Import Tool : Oracle : Batch import with Date Column is slower and inserts incorrect 1/1/1970 for all date rows
11640 : Bug : Debugger for SQL Server : java.net.UnknownHostException on debugging with a named instance
11659 : Bug : SQL Server : Scripting of user-defined types not complete, missing IDENTITY and PRIMARY KEY
11675 : Bug : Parameterized Scripts : SaveResults with parameters in file name is not working in 13.0.4
11685 : Bug : Query Builder : NPE on double clicking on a .xqb file
11688 : Bug : Parameterized Scripts : Parameterized script condition that fails with nn identified as a parameter
11689 : Bug : Parameterized Scripts : Parameterized script condition in file that fails with .save and &t option
11716 : Bug : Parameterized Scripts : Unexpected error in executing parameterized scripts
11717 : Bug : Visual Editing : Sybase ASE : Throws "java.lang.NullPointerException"
11762 : Bug : Query Analyzer : AFStatementParserExt not parsing tables which start with numbers correctly
11763 : Bug : Schema Script Generator : Hive : Mapr : Tables are not listed in Schema Script Generator to be scripted
11764 : Bug : ER Modeler : Hive : Mapr : Tables are not listed in ER Diagram Generator
11765 : Enhancement : General : SQL Server : Tree Node -> Database Node -> Add support for Offline Icons
11766 : Bug : Query Analyzer : Hive : Not able to execute SQL statements in Hive Mapr - RuntimeException
11767 : Bug : ER Modeler : Teradata Aster : In ER diagram, table properties are uneditable for table having column with "text" datatype
11770 : Bug : ER Modeler : Teradata Aster : Time without time zone and "timestamp without time zone" datatypes are gray out in Table Properties window for Aster 6.0
11782 : Bug : Schema Browser : Vertica : Script CREATE issue with column on a cluster
11787 : Enhancement : Options : Add option File->Options->Results->Message Results->Enable Undo
11817 : Bug : General : Sybase ASE : Computed columns of large length -> Extraction not always correct
NONE : Bug : Cassandra : Moved logging of LoggerFactory instantiation failure to connect method
NONE : Bug : Oracle Session Manager : Last column should be of value Long
NONE : Enhancement : Cassandra : Added .cql as hard cored extension for SQL files.
NONE : Enhancement : Hive : Add Apache, Cloudera, HortonWorks, MapR with native JDBC driver support
NONE : Bug : SQL Server : Database extraction -> status is set to online and changed if bit values meet criteria for sql server 2008 and below
NONE : Bug : ER Modeler : Unique option is enabled in create index window
NONE : Bug : Hive : Shows incorrect Database server version for Hive 0.12
NONE : Enhancement : Netezza : Describe command will no longer use schemas in extraction query

New in Aqua Data Studio 14.0.8 Build 35460 (Jan 10, 2014)

New in Aqua Data Studio 14.0.7 Build 35294 (Dec 21, 2013)

New in Aqua Data Studio 14.0.6 Build 35166 (Dec 12, 2013)

New in Aqua Data Studio 14.0.5 Build 34791 (Nov 13, 2013)

New in Aqua Data Studio 14.0.4 Build 34739 (Nov 8, 2013)

Enhancement : ER Modeler : Tools -> Generate HTML Reports. Include images as well
Bug : Query Analyzer : Drop down does not display the selected database for Query Analyzer Window
Bug : Cassandra : ADS not supporting Cassandra 2.0.1
Bug : Visual Editing : MongoDB : Alter Collection > Storage Size becomes editable after clicking Alphabetic icon
Bug : MongoDB : MongoSQL : Different format of FLATTEN_ARRAY when aliases used
Bug : Pivot Grid : pivot grid Field settings for Count don't carry over to Excel Pivot Grids
Bug : MongoDB : MongoSQL : Issues with ORDER BY when DISTINCT in WHAT
Bug : Open API : AQServerConnection.executeScript returns only 1,000 records
Bug : Visual Editing : SQL Server : "GO" Keyword missing for create Server roles script in MS SQL Server 2012
Bug : Visual Editing : MongoDB : Does not accept any Storage size once we delete default field value
Bug : Open API : AQTextProcessor.setQuoteIdentifier(int column, String quote) does not process quote properly
Enhancement : DBA Tools : Sybase ASE : Indicate the list of locks could not be determined due to exception
Bug : Export Tool : Generic ODBC : Access Export Tool generating error
Bug : MongoDB : NPE on Storage Size for MongoDB
Bug : Visual Editing : Cassandra : Column from primary key is duplicated in script generation and table options
Bug : Cassandra 2.0 : Regression with timestamp
Bug : ER Modeler : Cassandra : In ERD Cassandra 1.2 shown instead 2.0
Bug : DBA Tools : Sybase ASE : Session manager isolation_level
Bug : Query Builder : Cassandra : Query builder adds table name to the column name in WHERE and ORDER BY clauses
Enhancement : Import : Oracle : Investigate Oracle Import performance improvement techniques
Bug : Scripting : DB2 LUW : "Execute Bind” - current time not used, a hard coded date in 2005 is used instead
Bug : Table Data Editor : Cassandra 2.0 : BLOB type becomes NULL while CLONE row in Table Data Editor
Bug : Visual Editing : Create Table - making primary keys and foreign keys, the foreign keys ON DELETE and ON UPDATE not included for all foreign keys
Enhancement : Register Server : SQL Server - detect when Server Name: begins with \ or \\
Bug : Query Builder : Cassandra : for Cassandra Criteria taken in ( ) which cause CQL error
Bug : Connection Clustering : Issues with connection clustering on changing databases from the default specified in the server properties
Bug : Visual Editing : Exception on selecting Insert/Delete Constraint for table create UI
Bug : Options : Results Format : custom date, custom datetime options - carrying over to Decimal options
Bug : DB2 z/OS : Extraction of foreign key columns including other keys columns

New in Aqua Data Studio 14.0.3 Build 34446 (Oct 18, 2013)

New in Aqua Data Studio 14.0.1 Build 34381 (Oct 10, 2013)

New in Aqua Data Studio 14.0.0 Build 34352 (Oct 9, 2013)

New in Aqua Data Studio 13.0.4 Build 33788 (Aug 31, 2013)

Bug : Sybase ASE : extract trigger -> instead of triggers have a system type of 'IT' instead of 'TR'... added 'IT' as trigger type to extraction of object triggers
Bug : toggle breakpoint behavior should allow toggle where right click occurs
Bug : DB2 : Display dependencies with objects with identical name but in different schemas
Bug : SQL Server : Selecting File and Filegroup in Backup Database for SQL Server gives java.lang.StackOverflowError
Bug : SQL Server : Not able to Attach Database in SQL Server due to large file name with spaces in syntax
Enhancement : Oracle : support scripting permissions on Materialized Views
Enhancement : DB2 zOS : version 10 compatible to version 9 catalog tables need to run as version 9
Bug : SQL Server : Alter to attach a database - attach succeeds, but the Alter dialog does not close
Bug : SQL Server : Detach Database - Warning says the Detach fails - click ok and then cancel - Detach succeeds
Bug : Teradata : semicolon ; as statement separator
Bug : Sybase ASE : fix for database device number lookup. was comparing string object to integer object.
Enhancement : OpenAPI : Add a results compare API
Bug : Editor : Tab key changes alignment
Bug : Partitions and SubPartitions appear as separate objects in the Schema Node
Enhancement : SQL Server : Display last modified date for sql server objects in the detail view
Bug : Incorrect calculation in AQMath.median
Enhancement : OpenAPI : Create an API for extracting primary keys
Bug : SQL Server : When trying to Create Index for SQL Server getting Java Exception
Bug : MySQL : Changing the MySQL SQL Server mode to ONLY_FULL_GROUP_BY gives exception in the Storage Manager
Enhancement : AQNet: add custom port support to sftpTo/From()
Bug : MySQL : Fix "Auto Join on Foreign Key" for MySQL
Bug : Informix : extraction of paramaters throwing NPE. ifx_param_types(##) may return null.
Bug : Sybase ASE : storage manager -> database devices with segmaps of 1,2,5,6 needed handling
Enhancement : DB2 : Handle DB2 XML data type

New in Aqua Data Studio 13.0.3 Build 32954 (Jun 21, 2013)

New in Aqua Data Studio 13.0.2 Build 32848 (Jun 14, 2013)

New in Aqua Data Studio 13.0.1 Build 32232 (May 10, 2013)

#5111: Enhancement: Sybase IQ Explain Plan: Implement Visual Explain for Sybase IQ
#7886: Enhancement: Charts : Pie Chart label placement distributes labels across quadrants more evenly
#8076: Bug: Charts: Chart not remembering position when swapping between 2D and 3D
#8205: Enhancement: Charts: Mouse over the Maximize Chart button in Maximized state the tooltip text now says "Restore Chart"
#8288: Enhancement: Query Analyzer Grid Results: Clicking on a cell will highlight background color of its row line number
#8336: Enhancement: Query Analyzer: Double clicking on a .sql file should launch the Query Analyzer
#8639: Bug: DB2 LUW: Groups scripting and Schema Browser nodes not using complete extraction tailored for specific DB2 version releases.
#8652: Enhancement: SQL Server 2005 Schema Browser: SQL Server - SQL Agent Logs node added and can be viewed with Detail View for SQL Server 2005 and above
#8671: Enhancement: Sybase ASE Schema Browser: Triggers will now display enabled/disabled icon depending on trigger status
#8687: Enhancement: DB2 iSeries Visual Editing: Alter a procedure or Script > Create a procedure, include the relevant SET OPTION commands specified for that procedure.
#8692: Enhancement: Import Tool: Right click popup menus "Shift Up" and "Shift Down" on File Column or Position to allow choosing a different column for Identity Row on Format tab
#8699: Enhancement: SQL Server DBA Tools: Session Manager displays string name instead of binary ID for Wait Type
#8709: Bug: SQL Server Query Analyzer: Cancel button taking a long time to completely cancel
#8718: Bug: Sybase IQ & Sybase Anywhere Server Registration: SET TEMPORARY OPTION should be used instead of SET OPTION for Quoted_Identifier and Query Temp Space limit
#8719: Bug: Table Data Editor: Copy a value that contains decimal separator of (,) and paste displays a (null)
#8721: Enhancement: Query Analyzer Grid Results: File > Options > Grid Results > "Persist quick filter across execution" retains wild cards, regular expressions etc. across execution
#8744: Enhancement: PostgreSQL Schema Browser: If Schema Grouping is enabled prevent display of schemas which begin with pg_temp or pg_toast in the Schema Browser
#8745: Bug: SQL Server Visual Editing: Create Index not displaying column details of the table in the Indexed Column area
#8747: Enhancement: Sybase ASE Schema Script Generator: for Sybase ASE, indexes on system objects will no longer be scripted via the schema script generator
#8750: Bug: Version Control - Subversion: SVN authentication out of sync with Tortoise SVN client when both are used on the same computer
#8761: Bug: Query Analyzer Grid Results: Drag across row numbers only highlighting a max of 2 rows
#8762: Bug: Query Analyzer Grid Results: Shift click on row numbers not keeping all selections
#8764: Bug: Query Analyzer Grid Results: Right clicking row numbers selected random number of rows
#8779: Bug: Query Analyzer Grid Results: Row selection by row number highlighting incorrectly
#8780: Bug: PostgreSQL and Greenplum Query Analyzer Grid Results: Serial and BigSerial were being declared as a Numeric and String
#8781: Bug: PostgreSQL Table Data Editor: Clone row should not include the value of a Serial and Bigserial column
#8790: Bug: Query Analyzer Grid Results: Paste to Windoow > UPDATE body - statement using incorrect columns, but correct data
#8796: Enhancement: SQL Server: Option to force line endings to CR+LF format via File > Options > Query Analyzer > SQL Server > Convert all line endings from LF to CR+LF
#8813: Bug: Sybase IQ Visual Explain: Click on lines between nodes gives a Null Pointer Exception
#8814: Bug: Sybase IQ Visual Explain: Move cursor near nodes gives Null Pointer Exception when generating tooltips
#8816: Bug: Sybase IQ Schema Browser: Error message generated while expanding Sybase IQ 15.4 Index node
NONE: Bug: Charts: Fit-to-image off center following swap between 2D and 3D
NONE: Bug: Sybase ASE: Triggers > enable/disable dialog fails on warning or after successful command tree node refreshes
NONE: Enhancement: MySQL Driver: Updated mysql.jar driver to version 5.1.24
NONE: Enhancement: SQLite Table Data Editor: Use SQLDataLengthCellEditor for variant type to make null, date, and number formatting work in Table Data Editor
NONE: Enhancement: Schema Browser ParAccel & Greenplum: Hide pg_toast* and pg_temp* schemas when grouped by schema is set to true
NONE: Bug: Copy and paste fix for text translation information

New in Aqua Data Studio 13.0.0 Build 31978 (Apr 20, 2013)

Bug: Auto Completion: Auto Completion parser correctly supports "from" when used inside of overlay, substring and trim functions for PostgreSQL related DBs
Bug: FIle Compare Results UI: Fix line number being cut-off in results compare
Bug: AquaScript: Can't insert > 4000 characters into Oracle CLOB 4000 field via aquascript
Bug: Bubble Chart: Bubble chart not generated when using the "View in excel viewer" option
Bug: Autocompletion: When autocomplete option is un-selected, "Please Wait..." message persists and does not go away
Bug: SQL Server Storage Manager: When changing DB state to online/offline in SQL Server, error message generated
Bug: File Options Statement Separator for ParAccel : Clicking inside File->Options->Scripts->ParAccel Analytic Platform->Statement Separator File generates java.lang.Object@18cb416
Bug: File Options Quoted Identifier for ParAccel : Specifying a Quoted Identifier in File->Options->Scripts->ParAccel Analytic Platform->Quoted Identifier Analytic Platform is not working for "Script to New Window" action
Bug: AquaScript : AQDataReader doesn't correctly parse files containing both newlines and double quotes
Enhancement: AquaScript: Introduced new methods in AQConstraint to support retrieving Primary Key, Foreign Key, Check and Unique Constraint information
Bug: Query Analyzer UI: Mouse drag makes selection appear to occur in Text Results - focus is actually still Query Analyzer Edit area
Bug: Auto Completion: Do not popup autocompletion when using virtual temporary tables
Bug: File->Open Recent: File->"Open Recent" doesn't load the file inside of query analyzer
Enhancement: Vertica Auto Completion : "Auto on all schemas" is now set to false by default
Bug: DB2 iSeries Stored Procedures: Missing DBINFO parameter on Alter and incorrect DEBUG MODE parameter on Alter
Bug: DB2 Query Analyzer: When including XML datatypes in select statement, class name being displayed instead of the XML string
Enhancement: Schema Script Generator: Increase the default size of Schema Script Generator dialog
Enhancement: Vetica Schema Grouping : Schema grouping is now turned on by default

New in Aqua Data Studio 12.0.19 (Apr 12, 2013)

New in Aqua Data Studio 13.0.0 RC 17 (Mar 13, 2013)

New in Aqua Data Studio 12.0.18 (Mar 12, 2013)

New in Aqua Data Studio 12.0.17 (Feb 15, 2013)

New in Aqua Data Studio 12.0.16 (Feb 5, 2013)

New in Aqua Data Studio 12.0.15 (Jan 19, 2013)

New in Aqua Data Studio 12.0.14 (Dec 20, 2012)

New in Aqua Data Studio 12.0.13 (Dec 14, 2012)

New in Aqua Data Studio 12.0.12 (Dec 7, 2012)

New in Aqua Data Studio 12.0.11 (Dec 6, 2012)

New in Aqua Data Studio 12.0.10 (Dec 3, 2012)

New in Aqua Data Studio 12.0.9 (Nov 20, 2012)

New in Aqua Data Studio 12.0.8 (Nov 16, 2012)

New in Aqua Data Studio 12.0.7 (Nov 15, 2012)

New in Aqua Data Studio 12.0.6 (Nov 8, 2012)

New in Aqua Data Studio 12.0.5 (Nov 5, 2012)

New in Aqua Data Studio 12.0.4 (Nov 2, 2012)

New in Aqua Data Studio 12.0.3 (Oct 29, 2012)

New in Aqua Data Studio 12.0.2 (Oct 25, 2012)

New in Aqua Data Studio 12.0.1 (Oct 24, 2012)

New in Aqua Data Studio 12.0.0 (Oct 22, 2012)

Final Translations - 20 languages
NONE : Bug : Import Tool : Creating new table would not set it in the import tool after creation
NONE : Bug : SQL Server 2008+ extraction of indexes with INCLUDE column information.
NONE : Bug : Postgres/Paraccel/Netezza table creation GUI was not properly using setting schema to null for temp tables only
NONE : Bug : Query Window : Describe - Informix should not use schema in extraction
NONE : Bug : FluidShell -> sqlimport & sqlexport -> man pages default date/time/datetime patterns needed to be corrected.
NONE : Bug : Postgres UUID should be treated as a string
NONE : Improvement : Add a "Disconnect" button to Query Window
NONE : Improvement : Added support to PostgreSQL for auto completion with Include Public Schema in Completion
#344 : Improvement : PostgreSQL: Add the ability to change the schema context.
#6291 : Improvement : Add support for percentages in the Pivot Grid, so a user can see the percentages just like in the AQReport
#7574 : Bug : Add pipe support for \exec command
#7608 : Bug : Open in Current Window a file into a Text Editor does not change to correct EOL
#7719 : Improvement : Add FluidShell command excel2csv
#7734 : Bug : Netezza auto completion extraction of tables and views needed to be able to tell one from the other
#7736 : Bug : Toggle Statement Comment with Ctrl-Alt-/ does not toggle in Text, Java, XML Editors
#7740 : Bug : Support line feed in shell PROMPT
#7743 : Bug : Comment // require space before to work
#7744 : Bug : Database property - there is a flicker in the way the dialogs appear different from 11.0
#7745 : Bug : Insert values for bit fields via Table Data Editor for MySQL DB fails
#7746 : Improvement : Add Preview Pane in "Preview SQL" tab of Table Data Editor
#7747 : Improvement : No syntax highlighting for SQL statements in the messages tab for View as Text
#7749 : Bug : Default profile of FluidShell
#7750 : Bug : Incorrect SQL selected in the query window for corresponding SQL in the messages tab
#7752 : Bug : RTF copy to clipboard is no longer working in editor
#7755 : Bug : Fixed default option for CompareOptions.Colors
#7759 : Improvement : Alias the help command so when I type "help", the "help -d" command is executed
#7769 : Bug : NPE for Multi-file opening for Query Analyzer Window (Ctrl+Shift-W)
#7771 : Bug : \sqldump -o file produces a double descriptive header
#7773 : Bug : \sqldump -TF (--table-script-full) option
#7774 : Bug : Cut is not working in the latest build
#7775 : Bug : Up/Down arrows don't scroll down to show the current prompt
#7777 : Bug : Parse Results now has 2 selected cell content preview
#7778 : Bug : sqldump -- doesn't handle bit fields correctly (mysql)
#7779 : Bug : sqldump -D, --ddl-drop BOOLEAN should be off by default
#7783 : Bug : Password prompted twice in Query Analyzer Window
#7784 : Bug : ~ support in autocomplete
#7786 : Bug : excel2csv -- support for a specific sheet w/ in an excel workbook
#7787 : Bug : Field Settings, Hide, Move etc missing in popup menu
#7788 : Bug : Fluidshell shortcut with no password stored prompts for password twice
#7790 : Bug : Problem with losing focus on the Servers tab and Query Window
#7791 : Bug : Failed to encode String: Pipe closed
#7792 : Bug : NPE on csv2excel and source and cannot quit command
#7795 : Bug : Unexpected error onToggle Statement Comment
#7798 : Bug : Flicker issue with dialogs when [Use floating windows for Visual Editing dialogs] = TRUE
#7799 : Bug : public schema was displaying tables twice in autocompletion when all schemas enabled.
#7801 : Bug : Java Editor locks application with large files after navigating the full file
#7807 : Improvement : Add option to excel2csv, -cs - Save cell content as shown
#7808 : Bug : Apply the CsvReader.java API to the commands csv2html, csv2json, csv2xml in Transformer.java
#7809 : Improvement : Add Csv options to commands csv2html, csv2json, csv2xml, csv2excel, excel2csv
#7810 : Bug : Default date/time/datetime pattern set to use AquaCsvOptions' default date/time/datetime pattern
#7811 : Bug : NPE on Restore Database in Storage Manager
#7813 : Bug : Postgres 8.1+ create user no longer allows setting SYSID
#7815 : Bug : Sybase ASE -> alter user -> code fixes
#7816 : Bug : Add Ctrl-C capabilities to csv2excel and excel2csv
#7818 : Improvement : sqlimport command needs to display warnings as the import is occuring
#7819 : Bug : Change the schema context using search_path and clone window with content
#7820 : Bug : Behavior in FluidShell after killing a connection
#7821 : Bug : Sybase ASE execution of cursored procedure call needs to execute the statement differently.
#7822 : Improvement : Speed up batch/thresold imports in the Import Tool and sqlimport command by 20%
#7828 : Bug : excel2csv seems to cause problems with japanese characters to console
#7830 : Bug : I don't think we need the -ED option in excel2csv as it doesn't change the behavior
#7831 : Bug : Reading rows from excel will skip blank leading cells
#7832 : Bug : excel2csv -NT option currectly has a default of false, but docs say default of true
#7834 : Bug : We will need to make the CsvReader date/time parser smarter
12.0.0-rc-23 (since 12.0.0-rc-22) - October 8th 2012
=============================================
#1647 : Bug : Matching brackets should ignore quoted strings in editor
#7526 : Improvement : Evaluate how to handle shell command lines that parser fails to recognize for autocompletion.
#7529 : Bug : Informix fluidshell shortcut for Server Name gives Database not found
#7589 : Bug : Block selection and Upper and Lower case
#7678 : Bug : Test cases where auto-completion failed
#7689 : Bug : Editor -> all -> Line Wrapping -> copy and paste not working correctly.
#7690 : Improvement : editor -> Text Editor -> working with line wrapping EXTREMELY slow
#7692 : Bug : NPE when using \more command on a file in batch mode
#7694 : Bug : Unexpected error if you Save As ... a AquaScript in a different location and Debug in Browser
#7695 : Bug : Autocompletion on files with special characters ? ; ! :
#7699 : Bug : NPE on opening a version controlled sql file and changing to a Connection Pooled Server
#7698 : Improvement : FluidShell & SSH shell -> high lighting -> file/folder names extra high lighting
#7700 : Bug : HTML editor doesn't provide the find bar indicator like Text and XML
#7702 : Improvement : Editor should allow for row highlighting even when mouse cursor is in "Diff" column
#7703 : Improvement : When I have inline diff disabled, there should be 1/2 a column width whitespace between ...
#7705 : Improvement : \more to support 'more prompt' if executed via \source command interactively
#7706 : Bug : Editor doesnt display entire characters with Enabling and Disabling Line Wrap and using scrollbar
#7707 : Bug : Export Data tab writes debug messages to standard output
#7708 : Bug : Inline Diff indicator menu goes out of the text area
#7710 : Bug : \more "next file" message with long filenames remains on screen and/or gets duplicated
#7711 : Improvement : Added DB2 system tables to keywords, and Apache Derby keywords
#7712 : Bug : DB2 LUW 7.2 : Statement.setFetchSize() errors need to be caught and ignored as not all drivers support this.
#7715 : Bug : Change Server Connection to a Connection Pooled Server doesnt disable Reconnect/Change Server
#7716 : Bug : Sybase Anywhere Views - Edit in Table Data Editor gives Truncation Error
#7720 : Improvement : Clarify "Email Excel Attachment" error message "Mail system is not enabled."
#7721 : Bug : Commit query using Ctrl+Shift+C is creating a query analyzer clone and not committing
#7722 : Bug : Grid Results - Ctrl-click a row header for a row which is selected should unselect
#7723 : Bug : Prompt's line after resize doesn't get entirely cleaned
#7724 : Bug : Floating window and change server does not change name of tab to new connection
#7726 : Improvement : Add option File->Options->Email->[Email Defaults : { From, Cc, Bcc]
#7727 : Bug : Full menu is missing from Query Window when you do a Script to new Window from Pivot Grid Tab
#7728 : Improvement : Investigate adding an option to have Visual Editing using Floating Tab Windows to mimick dialogs
#7731 : Bug : Drag Database node and create a FluidShell shortcut. Clicking on it gives Unexpected error
NONE : Added .xjs as extension for mime type JavaScript
NONE : Final Translations for 21 localizations
New features:
FluidShell - SQL Command Line Shell
Big Data Performance
Connection Pooling
Editor - Enhancements
New Visual Editing
Searchable Options
Subversion 1.7 Support
Excel Exporting - Enhancements
Updated Drivers
SQL Server - New Datatypes
More Powerful UI
Database Upgrades

New in Aqua Data Studio 12.0.0 RC 23 (Oct 19, 2012)

#1647 : Bug : Matching brackets should ignore quoted strings in editor
#7526 : Improvement : Evaluate how to handle shell command lines that parser fails to recognize for autocompletion.
#7529 : Bug : Informix fluidshell shortcut for Server Name gives Database not found
#7589 : Bug : Block selection and Upper and Lower case
#7678 : Bug : Test cases where auto-completion failed
#7689 : Bug : Editor -> all -> Line Wrapping -> copy and paste not working correctly.
#7690 : Improvement : editor -> Text Editor -> working with line wrapping EXTREMELY slow
#7692 : Bug : NPE when using \more command on a file in batch mode
#7694 : Bug : Unexpected error if you Save As ... a AquaScript in a different location and Debug in Browser
#7695 : Bug : Autocompletion on files with special characters ? ; ! :
#7699 : Bug : NPE on opening a version controlled sql file and changing to a Connection Pooled Server
#7698 : Improvement : FluidShell & SSH shell -> high lighting -> file/folder names extra high lighting
#7700 : Bug : HTML editor doesn't provide the find bar indicator like Text and XML
#7702 : Improvement : Editor should allow for row highlighting even when mouse cursor is in "Diff" column
#7703 : Improvement : When I have inline diff disabled, there should be 1/2 a column width whitespace between ...
#7705 : Improvement : \more to support 'more prompt' if executed via \source command interactively
#7706 : Bug : Editor doesnt display entire characters with Enabling and Disabling Line Wrap and using scrollbar
#7707 : Bug : Export Data tab writes debug messages to standard output
#7708 : Bug : Inline Diff indicator menu goes out of the text area
#7710 : Bug : \more "next file" message with long filenames remains on screen and/or gets duplicated
#7711 : Improvement : Added DB2 system tables to keywords, and Apache Derby keywords
#7712 : Bug : DB2 LUW 7.2 : Statement.setFetchSize() errors need to be caught and ignored as not all drivers support this.
#7715 : Bug : Change Server Connection to a Connection Pooled Server doesnt disable Reconnect/Change Server
#7716 : Bug : Sybase Anywhere Views - Edit in Table Data Editor gives Truncation Error
#7720 : Improvement : Clarify "Email Excel Attachment" error message "Mail system is not enabled."
#7721 : Bug : Commit query using Ctrl+Shift+C is creating a query analyzer clone and not committing
#7722 : Bug : Grid Results - Ctrl-click a row header for a row which is selected should unselect
#7723 : Bug : Prompt's line after resize doesn't get entirely cleaned
#7724 : Bug : Floating window and change server does not change name of tab to new connection
#7726 : Improvement : Add option File->Options->Email->[Email Defaults : { From, Cc, Bcc]
#7727 : Bug : Full menu is missing from Query Window when you do a Script to new Window from Pivot Grid Tab
#7728 : Improvement : Investigate adding an option to have Visual Editing using Floating Tab Windows to mimick dialogs
#7731 : Bug : Drag Database node and create a FluidShell shortcut. Clicking on it gives Unexpected error
NONE : Added .xjs as extension for mime type JavaScript
NONE : Final Translations for 21 localizations

New in Aqua Data Studio 11.0.14 (Oct 19, 2012)

New in Aqua Data Studio 11.0.8 (Jun 27, 2012)

New in Aqua Data Studio 11.0.7 (Jun 19, 2012)

New in Aqua Data Studio 11.0.6 (Jun 9, 2012)

New in Aqua Data Studio 11.0.3 (May 21, 2012)

New in Aqua Data Studio 10.0.10 (Apr 25, 2012)

New in Aqua Data Studio 10.0.9 (Apr 25, 2012)

New in Aqua Data Studio 10.0.8 (Mar 17, 2012)

New in Aqua Data Studio 10.0.7 (Feb 8, 2012)

New in Aqua Data Studio 10.0.6 (Feb 1, 2012)

New in Aqua Data Studio 10.0.5 (Jan 18, 2012)

New in Aqua Data Studio 10.0.0 (Sep 27, 2011)

New in Aqua Data Studio 9.0.16 (Aug 4, 2011)

New in Aqua Data Studio 9.0.14 (May 2, 2011)

New in Aqua Data Studio 9.0.12 (Feb 14, 2011)

New in Aqua Data Studio 9.0.5 (Nov 18, 2010)

New in Aqua Data Studio 9.0.4 (Oct 28, 2010)

New in Aqua Data Studio 9.0.3 (Oct 28, 2010)

New in Aqua Data Studio 9.0.2 (Oct 8, 2010)

New in Aqua Data Studio 9.0.1 (Oct 5, 2010)

New in Aqua Data Studio 9.0.0 (Oct 1, 2010)

New in Aqua Data Studio 9.0.0 RC1.00 (Sep 21, 2010)

New in Aqua Data Studio 9.0.0 Beta 3.06 (Sep 9, 2010)

New in Aqua Data Studio 9.0.0 Beta 3.04 (Aug 20, 2010)

New in Aqua Data Studio 9.0.0 Beta 3.02 (Aug 11, 2010)

New in Aqua Data Studio 9.0.0 Beta 3.01 (Aug 7, 2010)

New in Aqua Data Studio 8.0.23 (Aug 4, 2010)

New in Aqua Data Studio 8.0.22 (Jul 23, 2010)

New in Aqua Data Studio 8.0.21 (Jul 6, 2010)

New in Aqua Data Studio 8.0.19 (Jun 16, 2010)

New in Aqua Data Studio 8.0.18 (Jun 16, 2010)

New in Aqua Data Studio 8.0.17 (Jun 1, 2010)

New in Aqua Data Studio 8.0.16 (May 26, 2010)

New in Aqua Data Studio 8.0.15 (May 12, 2010)

New in Aqua Data Studio 8.0.14 (Apr 10, 2010)

New in Aqua Data Studio 8.0.13 (Mar 29, 2010)

New in Aqua Data Studio 8.0.10 (Feb 2, 2010)

New in Aqua Data Studio 8.0.9 (Jan 23, 2010)

New in Aqua Data Studio 8.0.8 (Jan 7, 2010)

New in Aqua Data Studio 8.0.7 (Dec 17, 2009)

New in Aqua Data Studio 8.0.6 (Dec 9, 2009)

New in Aqua Data Studio 8.0.5 (Nov 14, 2009)

New in Aqua Data Studio 8.0.4 (Nov 10, 2009)

New in Aqua Data Studio 8.0.3 (Nov 3, 2009)

New in Aqua Data Studio 8.0.2 (Oct 24, 2009)

New in Aqua Data Studio 8.0.1 (Oct 16, 2009)

New in Aqua Data Studio 8.0.0 (Oct 14, 2009)

New in Aqua Data Studio 8.0.0 RC 1 (Oct 6, 2009)

New in Aqua Data Studio 8.0.0 Beta 5 (Sep 23, 2009)

New in Aqua Data Studio 8.0.0 Beta 4 (Sep 22, 2009)

New in Aqua Data Studio 8.0.0 Beta 3 (Sep 16, 2009)

New in Aqua Data Studio 7.5.35 (Aug 31, 2009)

New in Aqua Data Studio 7.5.33 (Aug 18, 2009)

New in Aqua Data Studio 7.5.32 (Aug 15, 2009)

New in Aqua Data Studio 7.5.31 (Aug 11, 2009)

New in Aqua Data Studio 7.5.30 (Aug 5, 2009)

New in Aqua Data Studio 7.5.29 (Jul 29, 2009)

New in Aqua Data Studio 7.5.28 (Jul 23, 2009)

New in Aqua Data Studio 7.5.27 (Jul 22, 2009)

New in Aqua Data Studio 7.5.26 (Jul 14, 2009)

New in Aqua Data Studio 7.5.25 (Jul 11, 2009)

New in Aqua Data Studio 7.5.24 (Jul 7, 2009)

New in Aqua Data Studio 7.5.23 (Jul 1, 2009)

New in Aqua Data Studio 7.5.22 (Jul 1, 2009)

New in Aqua Data Studio 7.5.21 (Jul 1, 2009)

New in Aqua Data Studio 7.5.20 (Jun 17, 2009)

New in Aqua Data Studio 7.5.19 (Jun 11, 2009)

New in Aqua Data Studio 7.5.11 (May 14, 2009)

New in Aqua Data Studio 7.5.10 (May 14, 2009)

New in Aqua Data Studio 7.5.9 (May 14, 2009)

New in Aqua Data Studio 7.5.8 (May 10, 2009)

New in Aqua Data Studio 7.5.7 (May 10, 2009)

New in Aqua Data Studio 7.5.6 (May 10, 2009)

New in Aqua Data Studio 7.5.5 (May 6, 2009)

New in Aqua Data Studio 7.5.4 (May 6, 2009)

New in Aqua Data Studio 7.5.3 (May 5, 2009)

New in Aqua Data Studio 7.5.2 (May 4, 2009)

New in Aqua Data Studio 7.5.1 (May 4, 2009)

New in Aqua Data Studio 7.5.0 (Apr 27, 2009)

Memory Optimizations - Reduced Memory Footprint – now, Aqua Data Studio uses less memory(30% to 40% less) than previous versions at startup and when retrieving results of more than 65,000 rows.
New & Enhanced Editors - New Java and JavaScript Editors – edit JavaScript and Java with syntax highlighting and all of the other features you get from Aqua Data Studio's HTML, SQL, XML and text editors.
Enhanced clipboard, Bookmarks, Find and Replace allow you to copy source code and keep its syntax highlighting, navigate through documents with user-defined bookmarks, as well as find and replace with escape characters.
New & Enhanced Charts - New charting tools have been added to include more features developers and analysts need. You now have more control when manipulating the visualization of data including Clustered Column Charts, Stacked Column Charts, Clustered Bar Charts, Stacked Bar Charts and Stacked Line Charts. Columns in a column chart can now be swapped out with different basic shapes like cones and pyramids. Just like ADS 7.0, all options are scriptable and include support for pivot charts.
Subversion 1.5 Support - Subversion (SVN) 1.5 support is built into Aqua Data Studio 7.5, and ready for use with your preexisting Subversion 1.5 installations. We've even included a Relocate feature.
File Search Tool - We’ve added a powerful new File Search Tool into Aqua Data Studio 7.5 for use with your scripts directory and version control repositories. Use it to find, sort and filter files by their content, filename and more. You can include/exclude file types in your search and even search with regular expressions.
Visual Editing Enhancements - Aqua Data Studio 7.5 expands Visual Editing support to allow the visual renaming of schema objects.
ER Modeler Enhancements - The Entity-Relationship (ER) Modeler that is as powerful as even the best standalone database diagramming tools, now allows objects within an ER Model to be renamed. Relationship connectors can be rerouted within diagrams.
DBA Tools Enhancements - The Storage Manager has been greatly enhanced for Oracle, DB2, Microsoft SQL Server, Sybase and MySQL for tuning and monitoring of database storage. ADS 7.5 has enhanced views for Database Size, Table Size and Index Size. Now, DBAs can quickly visually evaluate storage issues for database tuning and performance enhancement.
The DBA Tools now allow you to save column positioning and width, keep filter settings between refreshes and quickly reconnect with the new reconnect button.
More Features in ADS 7.5 for More Databases - Aqua Data Studio 7.5 includes other enhancements and improvements.
Nine New Languages (21 Total) - Aqua Data Studio 7.5 now speaks 21 languages. If you read Chinese (Simplified), Chinese (Traditional), Czech, Danish, Dutch, English, Finnish, French, German, Greek, Hindi, Japanese, Korean, Norwegian, Polish, Portuguese, Portuguese (Brazilian), Russian, Spanish or Swedish, it speaks your language.

New in Aqua Data Studio 7.0.37 (Apr 23, 2009)

New in Aqua Data Studio 7.0.36 (Mar 15, 2009)

New in Aqua Data Studio 7.0.35 (Mar 15, 2009)

New in Aqua Data Studio 7.0.34 (Mar 15, 2009)

New in Aqua Data Studio 7.0.33 (Feb 10, 2009)

New in Aqua Data Studio 7.0.32 (Feb 10, 2009)

New in Aqua Data Studio 7.0.31 (Feb 10, 2009)

New in Aqua Data Studio 7.0.30 (Feb 10, 2009)

New in Aqua Data Studio 7.0.29 (Feb 10, 2009)

New in Aqua Data Studio 7.0.28 (Feb 10, 2009)

New in Aqua Data Studio 7.0.27 (Feb 10, 2009)

New in Aqua Data Studio 7.0.26 (Feb 10, 2009)

New in Aqua Data Studio 7.0.25 (Feb 10, 2009)

New in Aqua Data Studio 7.0.24 (Feb 10, 2009)

New in Aqua Data Studio 7.0.23 (Feb 10, 2009)

FIX: Auto-Describe now includes UNIQUE and CLUSTERED option in text description
FIX: Sybase ASE : Alter Table Dialog: Adding and Dropping columns at the same time would cause incorrect SQL statement. Adding columns or dropping columns in any single operation would be ok.
FIX: Table Data Editor: Would give a truncated data warning on paste when no truncation happend.
FIX: EXECUTE BIND for Oracle, no longer sets NULL value for user defined datatypes
FIX: Sybase ASE: Extracting procedures and functions in Sybase ASE on UTF-8 databases would add extra blank spaces.
FIX: Support for Table and Column comments in DB2 iSeries
FIX: Drag-n-Drop from cell of Grid results now uses displayed value instead of raw values for Numbers and Dates.
FIX: DB2 Session Manager: Didn't display current SQL for 9.0 and 9.5.
FIX: ER Modeler: Table Dialog: Delete key didn't DELETE row, now does.
FIX: Sybase ASE: Script Procedure CREATE. Certain procedures with over 15,000 lines on Sybase 12.0 server would be out of order.
FIX: Sybase ASE: Alter Database, recalculating size when changing size type was incorrect
OPTIMIZATION: Optimize free memory reallocation when executing queries and closing query windows. Also optimized memory on SVN Update and Commits.
FEATURE: Schema Script Generator: Added Inline Schema Script Comments option
FEATURE: Query Analyzer Results: Script Details: Added Server Execution Time
LOCALIZATION: Minor bug fixes
LOCALIZATION: Japanese Translation. Original translation was not good enough according to Japanese users. Now includes a complete and new translation which is very accurate and usable by users.
LOCALIZATION Update:
(Status: Review) : 100% : Spanish
(Status: Review) : 100% : French
(Status: Review) : 100% : Italian
(Status: Review) : 100% : Portuguese (Portugal)
(Status: Review) : 100% : Portuguese (Brazil)
(Status: Review) : 100% : German
(Status: Review) : 100% : Russian
(Status: Review) : 100% : Korean
(Status: Review) : 100% : Chinese (Traditional)
(Status: Review) : 100% : Chinese (Simplified)
(Status: Review) : 100% : Japanese