16.0.13 (since 16.0.10) - January 22 2016
=============================================
14211 : Bug : ADS : Shortcut - Launch "Choose Server or Database" dialog via shortcut generates a ClassCastException
14203 : Bug : ADS : Teradata - 13.10 -> SetMaxResults -> jdbc FetchSize should not be limited to MaxResults
14195 : Bug : ADS : ER Modeler - "Create view script" generates incorrect script when statement does not start with "create"
14166 : Bug : ADS : MS SQL Server 2014 : Execution plan not displayed in result set and throws NullPointerException in view log After clicking on Execute Explain icon.
13973 : Enhancement : ADS : Sybase ASE - Working with temp dbs when no permissions allowed via server connection properties now allows working on all temp dbs
13958 : Enhancement : ADS : Redshift -> Add Interleaved Sort Key Option
13928 : Enhancement : ADS : Oracle 11g -> Virtual Column support
13901 : Bug : MongoShell ^- Character not working
13212 : Bug : ADS : Generic JDBC - NullPointerException occurs when database (catalog) is null
NONE : Bug : ADS : Generic JDBC - Minor error check for Generic JDBC connection type
16.0.10 (since 16.0.9) - December 1 2015
=============================================
13904 : Bug : ADS : Hive - Cloudera Impala schema browser has NPE with large amount of tables
13855 : Bug : ADS : MongoDB SSL option now allows invalid certificates - Implementing support for the 'sslAllowInvalidCertificates' JDBC property.
13839 : Bug : ADS : Sybase ASE -> Extract Parameters -> Status2 now extracted and used to determine IN/OUT value of the parameter
13810 : Bug : ADS : Export tool for PostgreSQL is not escaping "\" in strings. Fix for export tool - requiresEscapeBackslash was not properly been passed to method
13777 : Bug : ADS : Sybase ASE -> Datatypes UNSIGNED BIGINT, UNSIGNED INT & UNSIGNED SMALLINT need driver return name mapped correctly
13772 : Bug : ADS : Query Builder : Query Builder execute edit fails on cross database table queries
13770 : Bug : ADS : MongoDB -> Table Data Editor turns an array field to a string field for MongoDB
NONE : Bug : Visual Analytics : Data is not displayed in View data if we load dataset from same Query Analyser window instance
16.0.9 (since 16.0.7) - October 8 2015
=============================================
13773 : Bug : Procedure Editor : Fix for Procedure Editor with the ; statement separator
13771 : Bug : FluidShell : FluidShell connect command fails when USER HOME path uses UNC
13769 : Bug : Sybase : Procedure debugger window does not show parameters with [n][var]char() variables declared
13762 : Bug : SQL History : Cap maximum number of entries in SQL history to 1000 and load maximum of 1000 entries in SQL History dialog
13756 : Bug : Netezza : Netezza -> Synonyms -> related to issue 13655, set catalog is new to 7.0.3 and objectname most be qualified with quotes
13755 : Bug : Netezza : Netezza -> Synonyms -> target object database will be scripted and GUI modifications to allow for out of database target object.
16.0.7 (since 16.0.5) - September 23 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
16.0.5 (since 16.0.4) - April 30 2015
=============================================
13280 : Bug : ADS : Vertica Bigint Datatypes are displayed as negative numbers in QA Grid Results
13269 : Bug : ADS : Query Analyzer : Autocomplete: When disconnected, autocomplete should not update its schema cache
13268 : Bug : ADS : View as spreadsheet - invalid filename
13263 : Enhancement : ADS : Table Data Editor : Execute Edit -> Support Primary Key detection on views
13262 : Bug : ADS : Query Analyzer : NPE when switching from Show Grid to Show Text option
13256 : Bug : ADS : SQL Server Jobs: Cannot create a new schedule in Italian language
13120 : Bug : ADS : bulk.getOperations() command doesn't show result in ADS MongoShell
NONE : Bug : Visual Analytics : Mismatch in Trend line
NONE : Bug : Visual Analytics : Trend line is not displayed for Shape Chart in some cases when used together with Parameter
NONE : Bug : Visual Analytics : The Trend Line Details window does not display information, even when Slope & Intercept values are displayed in tooltip
NONE : Bug : Visual Analytics : Color=(null) is displayed in trendline tooltip, if we change color deck field to measure in any individual accordian of Combo Chart
NONE : Bug : Visual Analytics : NPE when trend line is enabled and Dimension field is removed from deck
NONE : Bug : Visual Analytics : Undo-Redo operation gives IndexOutOfBounds Exception
16.0.4 (since 16.0.3) - April 17 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 : <All_Schemas> 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
16.0.3 (since 16.0.1) - March 31 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
16.0.1 (since 16.0.0) - March 20 2015
=============================================
13164 : Bug : MongoDB : MongoShell : explain() command displays error message
12924 : Enhancement : Object Title in Window now supported for Indexes, Constraints and Triggers
NONE : Visual Analytics : DATE() function returns "null"on re-saving this cal.field on different locale
NONE : Visual Analytics : Table : Total column sum value get displayed instead of count value,even if we have selected "Total All Using > Count" option.
NONE : Visual Analytics : Charts : Throws"java.util.ConcurrentModificationException" after selecting the multiple shape from chart properties deck and do undo/redo.
NONE : Visual Analytics : Charts : Exception in Undo/Redo when making changes to Price Chart
NONE : Visual Analytics : Calculated Fields : Expression gets changed when we create by using DATENAME() function and again open it
NONE : Visual Analytics : Calculated Fields : DATEDIFF() function gives incorrect result
NONE : Visual Analytics : Parameters : Invalid layout inside the 'Create Parameter' window
NONE : Visual Analytics : Field Format : Keep "Numeric" option selected by default in Format window for Minute and Second
NONE : Visual Analytics : Field Format : Date and DateTime instances are not displayed according to user chosen locale format inside Create Parameter Dialog
NONE : Visual Analytics : Extract : Duplicate fields are created if we rename measure field and add new field with same name from excel
16.0.0 - ( New Features since 15.0.x )