Changelog for Build 111.12

Enhancements

(111.12) The notification about a finished (long running) script can now optionally be done using the system tray.
(111.11) Enhanced the behaviour of the editor when when typing while a rectangular selection is active.
(111.11) Implemented a workaround for Firebird JDBC driver which does not return function based indexes (and thus they were not shown in the DbExplorer)
(111.11) Code completion now honors the setting of the "search_path" in PostgreSQL
(111.10) The schema and catalog filters in a connection profile can not be defined as "inclusion" filters that define the list of names to be displayed (rather than a list of names to be excluded)
(111.10) For Oracle and Postgres a check for uncommitted changes can be enabled in the connection profile (for Oracle this requires the SELECT privileges on V$TRANSACTION)
(111.10) For Oracle, the "autotrace" mode from SQL*Plus is now supported. It is enabled with "SET AUTOTRACE" the same as in SQL*Plus (and requires the PLUSTRACE role like SQL*Plus)
(111.9) A new option to generate a script to drop a table and all incoming (referencing) foreign keys is available in the DbExplorer. This functionality is also available through the WbGenerateDrop command
(111.9) If enabled, the formatting of internally generated SQL statements is now done by the SQL formatter (and thus uses the same settings as the formatter)
(111.9) The dependency tree in the DbExplorer can now be limited to the direct children only.
(111.8) A new option for WbDataDiff is available to define alternat key columns for each table. See the manual for details.
(111.8) "Help -> Show DBMS Manual" now displays the online manual corresponding to the version of the DBMS
(111.8) For Oracle a subset of the SQL*Plus SHOW command is now supported
(111.8) A new option is available to automatically save connection profiles if the connect dialog is closed with OK.
(111.8) Enhanced entering variables in the variable dialog. The ENTER key automatically advances to the next variable and closes the dialog after the last one.
(111.8) When using WbVarDef with -contentFile, variables in the source file are now replaced. This can be disabled using the parameter -replaceVars=false
(111.6) The save button to update the database can now be set to be always enabled by setting the property workbench.gui.savebutton.always.enabled=true in workbench.settings
(111.6) A new option has been added to highlight columns that have been changed.
(111.5) The contents for a variable can now be read from an external file (using WbVarDef -variable=foo -contentFile=bar.txt)
(111.5) A new option to enable a connection to Oracle using the role SYSDBA has been added to the connection profile. This removes the need to specify an extended property.
(111.5) The dependency tree in the DbExplorer can now be retrieved independently from the list of foreign keys. Additionally the automatic retrieval of the tree can now be disabled in the options dialog.
(111.3) A new command "WbSysExec" has been added to run external programs.
(111.3) For H2 the (SQL) source for linked tables is now correctly shown in the DbExplorer.
(111.1) A new option for WbImport is available to control the behaviour with empty files
(111.1) For Postgres the generated CREATE TABLE statements now includes storage and tablespace information

Bug fixes

(111.12) No columns were shown in the DbExplorer for Vertica when the table or view name contained an underscore.
(111.10) For DB2, the source code for views created using CREATE OR REPLACE was not shown correctly.
(111.10) Adding a new column in the DbExplorer was not working for DBMS that do not support renaming of columns.
(111.9) A CASE statement with a column alias not using the AS keyword word was not always formatted correctly.
(111.8) When specifying a non-existing table using -sourceTable for WbExport no proper error message was shown.
(111.8) Fixed a problem with displaying the menus if the editor tabs ran over more than one line
(111.7) Implemented a workaround for the Vertica JDBC driver to allow running DML statements.
(111.6) WbSchemaDiff did not work when the table names needed quoting because of special characters or mixed case names
(111.4) The ACTION part for foreign key definitions was displayed incorrectly in the generated SQL source and the "References Tab" of DbExplorer
(111.3) Running more than one DataPumper or WbCopy command in parallel did not work.
(111.2) Displaying the source code for functions did not always work properly in PostgreSQL
(111.1) Copy as SQL UPDATE did not work properly
(111.1) If more than one statement was selected reformatting the SQL would remove the delimiter
(111.1) Implemented a workaround for a bug in old MySQL drivers that would cause an error when processing the result of a SELECT statement