Changes from build 110 to build 111
Enhancements
- A new commandline argument is available (-connectionName) to define the connection name to be displayed in the window title if the application is started without a profile (but with a full connection definition)
- The internal cache used for auto-completion is now updated when tables or table definitions are retrieved in the DbExplorer.
- Displaying the SQL of a view for SolidDB is now supported (contributed by Jason).
- Retrieving the dependency tree for foreign keys in the DbExplorer is now cancelled when switching to a different tab.
- External tools now have a seperate property for commandline arguments
- The filter in the DbExplorer's table list can now be set to "Filter as you type"
- Foreign keys referencing unique constraints are now displayed for Oracle (this is a workaround for a bug in the Oracle JDBC Driver)
- WbImport now accepts multi-character delimiters (e.g. \t\t)
- The suffix for escaping variables can now be defined as "empty", so that e.g. &val can be used as variable name
- For PostgreSQL 9.1 and Oracle, the trigger panel in the DbExplorer is now also shown for Views
- For MySQL and SQL Server column level collation and character set definitions are now shown
- Support for new features in PostgreSQL 9.1 has been added. The SQL source in the DbExplorer will now show FOREIGN and UNLOGGED tables correctly as well as column level collations
- In the DbExplorer's table list, a new option has been added to generate an "empty" UPDATE statement (in addition to the INSERT and SELECT statements)
- When using -mode=insert,update for WbCopy or WbImport only real primary key violations are now ignored (previously all errors during insert were ignored)
- The list of triggers in the DbExplorer now contains an additional column to show the status of the trigger for Oracle and Postgres
- The order of the columns in the DbExplorer's table list is now saved in the workspace
- WbDeleteProfile and WbSaveProfile are now also supported in batch mode.
- WbSaveProfile now supports a parameter whether the password should be stored or not (in that case the new -name parameter must be used to specify the profile's name)
- For simple INSERT statements a tooltip can now be show (Ctrl-#) that displays the corresponding column name or column value.
- The matching bracket highlighting can now be configured
- When converting boolean values to numeric values during WbImport, the numeric values to be used can now be specified using the new parameters -numericFalse and -numericTrue
- For Oracle, WbSchemaReport and WbSchemaDiff now includes the information about partitioned tables and indexes
- The generated table source in the DbExplorer now includes the new exclusion constraints from PostgreSQL 9.0
Bug fixes
- For Oracle unique constraints that were backed by a non-unique index were not displayed.
- The DataPumper did not commit the SQL statements when batch mode was used together with the "commit every" option.
- The dependency display in the DbExplorer did not work with unique constraints in Oracle
- The source for XMLTYPE columns was generated incorrectly for Oracle
- The correct source code for unique constraints is now shown in the DbExplorer for Oracle, PostgreSQL, DB2 and SQL Server 2005+
- Table names with non-standard upper/lowercase usage where not quoted in the code completion.
- Code completion used the wrong value to insert into the editor when the current word limited the list to a specific schema.
- Empty strings where not treated as NULL values for boolean or bit columns when importing text files using WbImport
- When compiling several procedures from within the DbExplorer's procedure list, Oracle packages are now only compiled once (contributed by Andreas)
- WbCall did not handle overloaded package procedures in Oracle
- The SQL Formatter did not properly format function calls that do not have parameters in e.g the VALUES list
- Copy Selected was not respecting re-ordered columns in the result set
- WbStoreProfile did not correctly register the used driver in WbDrivers.xml
- WbDataDiff did not always write correct XML files for update statements
- For MySQL retrieving the table definition of tables in a database where the database name contained underscores did not work
- When selecting * in the schema dropdown of the DbExplorer no triggers where displayed in the trigger panel
- WbSchemaDiff did not compare indexes and check constraints correctly
- Code completion was not always working properly if the table name ended with an underscore
- WbSchemaDiff did not process materialized views correctly.
- When choosing not to save a modified file when closing the application, the file was saved nevertheless.
- When recompiling an Oracle function or procedure using ALTER ... COMPILE, compilation warnings where not shown.
- Fixed a bug where that caused the code completion to be extremely slow.
- In the DbExplorer the columns for tables that had "similar" names (according to a LIKE expression with underscores) were not displayed correctly.
- Fixed a problem with schema display in the auto-completion for SQL Server
- Fixed a problem with schema detection in the DbExplorer when the JDBC driver did not support all metadata calls (e.g. DB2 for host systems)
- In Oracle, compilation errors for a TYPE BODY were not displayed
- In Oracle, the source for a primary key index that had a different name than the primary key was not shown in the DbExplorer
- Retrieving of column comments for queries did not work when the table had an alias
The full release history is available at the SQL Workbench/J homepage