Changes from build 117 to build 118
Enhancements
- Added support to include computed columns for MySQL 5.7 in the generated CREATE TABLE source
- The source and target connection for WbCopy, WbSchemaDiff and WbDataDiff can now be specified on the command line when starting the application. In that case it's not necessary to provide them to the respective commands
- A new action to run all SQL statements in the editor starting from the cursor position is available
- It's now possible to use OS environment variable or Java properties in the username of a connection profile.
- For Postgres, "COPY .. FROM stdin" with the data after the statement is now supported
- It's now possible to define external tools to format SQL
- For decimal values WbExport now supports the parameters -fixedDigits and -maxDigits.
- It's now possible to enable editing (and running) the generated SQL source code in the DbExplorer directly.
- For Oracle, messages from dbms_output are now always shown if a procedure is started using EXECUTE regardless of the setting of "set serveroutput"
- Added some basic support for SAP HANA.
- For Excel imports, the option -stringDates=true retrieves Dates as formatted strings and converts them using the date/timestamp format specified in the WbImport command rathr then reading a converted value from the Excel file.
- For Excel exports, the start location where the data should be written to in the excel file can now be specified using the -offset parameter
- The application to be used for displaying the logfile can now be configured.
- WbSchemaReport has a new (boolean) option -writeFullSource to write a valid CREATE VIEW statement to the XML output in case the DBMS does not store the complete SQL
- Results can now automatically be refreshed either through an annotation or through the context menu of the result tab
- The macros in a group can now be sorted alphabetically
- The quoting of the null values for text exports can now be enabled through the option -quoteNulls
- The quoting of the header for text exports can now be enabled through the option -quoteHeader
- The statement at the cursor position can now be copied directly into the clipboard (Code Tools -> Copy current statement)
- For Oracle, the partitions of a materialized view are now shown in the source code
- WbImport and WbCopy (including the DataPumper) can now be used to insert data into a view
- For tables without a primary key, unique indexes that contain nullable columns are no longer considered when generating DML statements
- For Vertica tables and views from the schema "v_internal" are now show in the DbExplorer (contributed by Tatiana Saltykova)
- It's now possible to define the terminator string for "Copy Code Snippet" through the config property "workbench.clipcreate.codeend"
- Macros and macro groups can now be excluded from the popup window
Bug fixes
- The menu to select data from referenced/referencing tables in a result set was disabled when switching to the DbExplorer and back to the SQL panel
- -syncDelete with WbCopy did not work if alternate key columns were specified using -keyColumns
- Fixed retrieval of stored procedures for DB2 on AS/400 (thanks to Francesco)
- Fixed detection of update columns for multi-table result sets when the name of the PK columns is not uniuqe in the result set
- For Firebird the source code for procedures with multiple out parameters was not generated correctly.
- For PostgreSQL, SQL statements to create the comment for functions with OUT parameters were not generated correctly.
- When running a single command in batch mode, the error status was not returned correctly to the operating system
- WbExport no longer uses the GUI defaults for decimal digits. The default is now to always export all digits, unless the new -maxDigits parameter is used
- For MySQL, when multiple tables with the same name in different databases had triggers defined, all triggers where visible for each table in the DbExplorer
- When importing multiple files using -usePgCopy and one file generated an error, the previous import was not committed
- WbConnect would prompt for a password for profiles with an empty password even if "Save password" was enabled
- No parameter prompt was shown for INOUT parameters when running procedures using WbCall
- Implemented a workaround for an Informix driver bug where index information for the wrong table was returned
- Double quotes in column values were not escaped properly when creating a JSON export
- When switching between views and tables in the DbExplorer the foreign key tabs were no longer shown for SQL Server
- Compile errors for Oracle's PL/SQL where not always shown correctly
- Parameters for SQL Workbench commands with nested single and double quotes that included SQL comments were not evaluated properly
- Fixed restoring of the window position when using multiple monitors
- Generating the SQL source for computed columns did not work for SQL Server 2000
- The SQL source for inherited tables in Postgres was not generated correctly.
- The SQL source for sequences for SQL Server was not generated correctly.
- "Create DDL script" in the DbExplorer would generate the source code for sequnces twice
- Nano (or micro) seconds from timestamp values where not displayed correctly
- When opening a file, it is now checked if the selected encoding matches the one from the file
- Each time when reloading a result that uses the @WbMacro annotation, the macro sub-menu would be added to the context menu again
- For Informix, default clauses for columns were not generated properly in the DbExplorer
- For Informix, index definitions were not always displayed correctly
- Overloaded functions and procedures where not handled correctly by WbSchemaDiff
- For Postgres the wrong DROP FUNCTION statement was generated if a function contained OUT parameter
- Scripts that contained statements including character literals with a backslash were not always parsed correctly.
- When WbImport did not find any matching columns, the error message did not include the (faulty) source file
- Fixed the display of the profile tree with large fonts
- The DataPumper did not work if source and destination had a different number of columns
- The generated WbCopy command in the DataPumper was not correct when a query was used as the source
- XLSX export did not work if the output file was specified without an extension
- Fixed some issues with restoring the window position on multi-monitor systems
- Fixed some issues where the alternate delimiter was incrrectly used when running scripts through WbInclude
- When importing multiple Excel files with WbImport using the -sourceDir argument, only the first file was imported
- The abbreviated WbInclude using @ only worked with Oracle
- The minutes for columns of type "timestamp with time zone" where not always displayed correctly in Oracle
- Oracle's autotrace did not work in console mode
- Using pgpass for Postgres connections did not work in console or batch mode
- WbProcSource would not show the code for a packaged procedure in Oracle
- Fixed some problems in the SQL formatter that would lead to invalid SQL syntax
- XSLT transformations failed when the output filename didn't include a directory
- Disabling "Filter while typing" in the DbExplorer was not possible
- -targetConnection and -referenceConnection for WbSchemaDiff and WbDataDiff were broken
The full release history is available at the SQL Workbench/J homepage