Changes from build 108 to build 109
Enhancements
- The context menu of the procedure list now has a new item "Put WbCall into..." (similar to the "Put SELECT into") for tables. Thanks Andreas for contributing this.
- When exporting LOB data into external files using WbExport, the generated LOB files can now be distributed over several directories to avoid directories with too many files
- WbExport now supports two new literal formats for PostgreSQL when exporting SQL statements using binary data (pgDecode and pgEscape)
- For MySQL table comments can now be shown in the DbExplorer by setting the property workbench.db.mysql.tablecomments.retrieve=true in workbench.settings
- WbDataDiff now outputs differences for foreign key in their own tag listing all FK columns instead of listing the foreign key as a modification for each column.
- A new option in the DataPumper is available to automatically select a matching entry in the target table dropdown when the source table is changed
- Changesets for WbRunLB can now also be selected by specifying an author (not only the ID)
- WbExport now only exports TABLEs (views, synonyms and similar objects where included by default until now). To include other types than tables, a new parameter -types has been added.
- When editing a value in the result set, the value can now be set to NULL (either through the popup menu or a shortcut)
- Sequences and UDTs in Derby 10.6 are now supported
- A new editor option to disable "Execute selected" when no text is selected is available.
- A new commandline option (-lbDefaults) is available to read connection information from an existing Liquibase defaults file
- Commandline options (e.g. for batch mode) can now also be stored in a properties file. A new option -arguments defines the file to be used
- For WbImport, select statements (referencing columns from the input file) can be defined in the -columnConstants argument. See the manual for details
- A new option (includeColumnComments) for WbExport is available to include column comments in the output (all formats except text files)
- A new command WbRunLB to extract and run the SQL statements from a Liquibase changeSet (<sql> or <createProcedure> tags) is available
- Window sizes and position are now stored separately per screen resolution
- When displaying the SQL for a view or table in PostgreSQL, associated RULEs are not included
- The quickfilter in the DbExplorer can now be changed to accept "normal" wildcards instead of regular expressions
- WbSchemaDiff now detects renamed foreign keys and indexes
- When using -continueOnError WbImport does not treat missing or empty files as an error, it only shows a warning.
- MySQL's syntax for changing autocommit mode is now also supported (SET AUTOCOMMIT = 1 instead of SET AUTOCOMMIT ON)
- A new command WbFetchSize is available to change the default fetch size of the current connection without the need to change the connection profile
- Workspaces loaded with "Workspace -> Load Workspace" are now added to a "Recent Workspaces" menu
- When an import with multiple files fails, the error message now includes the parameter to skip the successfully imported files, when re-running the WbImport command
- A new option to exclude tables for WbExport using -excludeTables is available.
Bug fixes
- The panel selection for "Put SELECT into" in the DbExplorer included DbExplorer panels if the DbExplorer was not at the end.
- For Oracle, overloaded procedures and functions (in packages) are now displayed correctly in the DbExplorer.
- For PostgreSQL 8.4 and above the source for procedures without parameters was no longer displayed.
- DESCRIBE did not longer work for Informix
- Fixed sequence, view and procedure display in the DbExplorer for DB2 on iSeries (AS/400)
- The source code for Postgres TYPEs was not show correctly.
- The source code for Postgres functions returning SETOF or TABLEs was not show correctly.
- WbDataDiff failed with no clear error message when the columns from the source table were missing in the target table.
- WbSchemaDiff did not work when indexes were included (-includeIndex=true)
- When the maximum number of backups for workspaces was reached, the newest backup was overwritten instead of the oldest
- Auto completion of column names did not work for table or column names that contained spaces (and thus needed qutoes)
- The width of the header was not evaluated correctly for all look and feels when optimizing column widths
- When initiating editing a column that is rendered as multiline column by using the DELETE key, a non-printable character was inserted into the text field
- When exporting text columns from PostgreSQL, they are now properly recognized as CLOB columns (e.g. for the -clobAsFile parameter)
- The SQL console did not start if a profile was passed (using -profile) on the commandline that did not exist
- Fixed some initialization problems with the DbExplorer which caused errors when using SQL Server with the Microsoft Driver
- The generated WbCopy command in the DataPumper was wrong, if * was selected as the schema
- Values of TIME columns were exported (incl. copy to clipboard) as dates
- When entering an invalid expression in the quickfilter of the DbExplorer, the filter was no longer working
- Postgres rules with the name _RETURN were not displayed in the DbExplorer
- For Oracle, WbCall did not work for stored procedures with ref cursors that were accessible only through a synonym
- Fixed a problem with an endless loop when displaying foreign key references when multiple FK constrained built a cycles
- Tried to make detection of Oracle packaged procedures more robust in WbCall
- The reverse engineered source code for views contained a wrongly placed semicolon
- Cancelling a connect due to an unsaved file did not work
- WbRun was always using the alternate delimiter to parse the file
- The tooltip for a column heder was not displaying the correct information if the column order was changed using drag and drop
- WbCall did not work with Oracle functions returning a REF CURSOR
- When the option "Confirm tab close" was enabled, no confirmation was needed when using "Close other tabs"
- The display of trigger functions in Postgres that did not have a comment was not working
- Specifying a config directory using -configDir that needed quoting did not work
- Statements with character literals and embedded single quotes (e.g. ' test ''') were not formatted correctly
- Oracle Package functions were no longer displayed in the procedure tab of the DbExplorer
- The "Object Info" function did not display information about TYPEs (e.g. Oracle, Postgres)
- For Oracle object TYPEs, member variables declared with the data type "NUMBER" where not displayed correctly
The full release history is available at the SQL Workbench/J homepage