Log Message:
Updated databases/sql-workbench to 130

Email MAINTAINER but no response since 19th November

Build 128 (2021-11-01)

Enhancements

 - SQL Workbench/J now requires Java 11 or later.
 - It's now possible to filter the list of shortcuts in the "Configure \ 
shortcuts" dialog.
 - For DB2i it's now possible to enable retrieving of "system names" \ 
for tables.
 - Then new "Copy as text" dialog now detects selected columns.
 - For XSLX, XLS and ODS exports it's now possible to specify column names that \ 
should be treated as formulas rather than "plain" values.
 - Added support for new features in PostgreSQL 14
 - WbImport now allows to specify a grouping character for importing numbers \ 
formatted with one
 - For Informix, unique and check constraint are not correctly included in the \ 
generated DDL.
 - WbImport can now read directly from GZipped files.
 - "Copy to clipboard" now uses the same dialog as "Save Data \ 
As" to allow full customization of the copied data
 - Improved compatibility with the FlatLaf look and feel.
 - It's now possible to dynamically change the statement delimiter using the \ 
WbDelimiter command.
 - When code completion for tables is shown, "table functions" (aka \ 
"set returning functions") are now included for DBMS that support \ 
them.
 - It's now possible to define macros that can be run from the context menu in \ 
the DbExplorer. Currently this is limited to table and column nodes.
 - A new command, WbRunResult to run the result of a query as a SQL script is \ 
available.
 - WbDataDiff now supports a parameter to control the way identity/autoincrement \ 
columns are handled in the generated INSERT statements
 - The console now supports basic auto-completion
 - When using WbInclude or running SQL scripts in batch mode, the last error is \ 
now available in SQL Workbench variables
 - The text and background color for the line numbers in the editor can now be \ 
configured
 - For WbExport, it's now possible to specify the literals to be used for \ 
boolean values
 - When using "Save data as..." it's now possible to include column \ 
comments the way -enableComments is working for WbExport
 - It's now possible to use an external pager when running in console mode

Bug fixes

 - For Postgres, the source of DOMAIN definitions was not generated correctly if \ 
check constraints were included.
 - Fixed a regression introduced in 127.5 that made -clobAsFile=true no longer \ 
work for some DBMS.
 - When printing results with NULL values, the layout of the printed table was \ 
not correct.
 - For Oracle, when using WbImport with -mode=upsert and -columnConstantValues, \ 
a wrong SQL statement was generated
 - For Postgres, when using WbImport with -mode=upsert and \ 
-columnConstantValues, the columns for the constant values were not included in \ 
the UPDATE part of the INSERT statement
 - When Using an Oracle connection without a username, displaying the table \ 
definition or the table's source resulted in an error
 - For some fonts, "Optimize column widths" did calculate the width \ 
incorrectly
 - Improved the performance for retrieving the list of procedures and functions \ 
in Oracle
 - For SQL Server, the DROP statements for multiple sequences wasn't generated \ 
correctly.
 - For Oracle, the COMPRESS attribute wasn't generated properly for tables and \ 
materialized views
 - Using WbImport with -columnExpression (to call functions on column values) \ 
wasn't working any more
 - Fixed cursor positioning problem on HiDPI displays for Windows
 - When using the properties based profiles, passwords that end with a backslash \ 
weren't loaded properly
 - Setting a (new) master password did not work if global SSH passwords were defined
 - For Oracle, using the alternate delimiter sometimes didn't work.
 - Fixed startup problems with the Windows launcher and Java 16.
 - Resetting a "separate connection" in a panel of the main window did \ 
not longer work if the DbTree was enabled.
 - When using "Save Data As" to generate MERGE statements, the column \ 
selection wasn't used.
 - When using -singleFile with WbDataDiff, values with empty lines weren't \ 
properly written to the output file.
 - When exporting data into an XLS Spreadsheet, existing number formatting \ 
wasn't always preserved.
 - Depending on the configuration, reading a NULL value for BLOB columns could \ 
result in an NullPointerException.
 - For Oracle, identifiers with leading underscores were not quoted correctly.
 - "Create VALUES list" did not always detect numbers correctly.
 - For WbExport and WbImport, using -quoteEscape=escape did not work correctly
 - For Oracle, the DDL for tables using sub-partioning templates wasn't correct.
 - For PostgreSQL, MariaDB and MySQL the precision of timestamp (datetime) \ 
columns was not shown.
 - For MySQL, the DbExplorer did not correctly show stored procedures.
 - For PostgreSQL, WbDataDiff did not work if the primary key contained citext \ 
columns
 - "Copy to clipboard" failed if any value contained a tab character.
 - When using "Show PDF Manual" the manual was expected in the wrong \ 
location.
 - When using "Separate connection per tab", the window title wasn't \ 
updated correctly when switching tabs

Build 129 (2022-10-23)

Enhancements

 - Double clicking on the grid line of a header column now adjusts the column width.
 - For DB2 for i, PostgreSQL and SQL Server additional connection properties are \ 
now shown in the "Connection Info"
 - It's now possible to configure the behaviour when closing a tab with a \ 
modified external file.
 - For PostgreSQL and Oracle, GRANTs for sequences are now shown in the \ 
generated SQL source
 - It's now possible to add multiple directories to the file system tree
 - When definining a JDBC driver, the jar file can now be downloaded from Maven \ 
central if available
 - It's now possible to assign a second, alternate keyboard shortcut for menu items
 - It's now possible to have a different set of variables per window.
 - Using FlatLaf themes is now supported.
 - The DbTree, Macro list and the new file browser can now be displayed at the \ 
same time as side panels.
 - It's now possible to search for tables or procedures from within the source \ 
panel of the DbExplorer.
 - It's now possible to jump to the corresponding table from within the trigger list.
 - In the DbTree, table nodes for "Uses", Used by", \ 
"References" and "Referenced by" can now be expanded to show \ 
the table details.

Bug fixes

 - When copying a result as SQL to the clipboard, timestamptz values for \ 
Postgres were not formatted correctly.
 - Some Workbench specific commands did not work if preceded with a comment \ 
containing quotes
 - Sorting results (by clicking on the header) did not work correctly for array \ 
columns (e.g. int[] in Postgres)
 - When importing from Excel sheet, make sure numbers formatted as strings are \ 
read as strings
 - For PostgreSQL, WbDataDiff didn't compare array columns correctly.
 - When copying data as text to the clipboard, columns with NULL or empty values \ 
were not copied correctly.
 - WbImport failed when using -quoteCharEscaping=duplicate and the first column \ 
of the input file contained a quoted empty string (e.g. "")
 - Setting a different background color for the editor was no longer working
 - For PostgreSQL, the source of trigger definitions wasn't generated properly \ 
if the same trigger existed in multiple schemas
 - For PostgreSQL, pg_get_constraintdef() is now used to generate the DDL for \ 
foreign keys
 - It was not possible to configure the color of the table grid lines for the \ 
FlatLaf Look & Feel
 - For PostgreSQL, the format for time columns wasn't used
 - For PostgreSQL, domains with multiple constraints weren't retrieved or \ 
displayed correctly.
 - It wasn't possible to assign keyboard shortcuts to "Indent" and \ 
"Un-Indent"
 - When changing the font size in the editor, the scrollbars weren't updated \ 
correctly
 - Zooming fonts with the mouse wheel did not work any longer.
 - The option to copy connection properties to system properties was not saved \ 
when the properties storage for connection profiles was used.
 - For PostgreSQL, implicit sequences (identity, serial) where not shown in the \ 
dependency of a table
 - When exporting to Excel (XLS, XLSX), SQL Workbench/J tries to cleanup invalid \ 
date/time formats
 - The "Save As" dialog wouldn't work, if the previously an XLS export \ 
was used, but the POI libraries aren't available
 - OpenDocument spreadsheets (.ods) where not generated correctly
 - For DB2 for i, the procedure GENERATE_SQL is now used for most objects to \ 
re-generate the DDL
 - The option "Use as retrieval filter" was not saved when connection \ 
profiles were stored as XML.
 - Fixed problems when moving the application between different HiDPI screens on \ 
Windows.
 - For DB2i, improved the performance when loading system names or remarks in \ 
the DbExplorer.
 - Removed the hard-coded alternate shortcut F9 for "Execute selected".
 - In the "Copy data to clipboard" dialog, the "Selected \ 
rows" option wasn't always enabled correctly.
 - If no backup directory was defined, opening of the "Backup" options \ 
wasn't possible.

Build 130 (2023-11-19)

Enhancements

 - It's now possible to search the settings dialog for specific labels.
 - Storing a workspace in a directory, rather than a ZIP archive (.wksp) is now \ 
supported.
 - Storing macros as SQL scripts in a directory, rather than an XML file is now \ 
supported.
 - For DB2 (LUW), tablespace information is now included in the generated DDL \ 
for tables.
 - WbSchemaDiff now writes a drop-constraint tag for indexes supporting unique \ 
constraints.
 - For DB2 (LUW), the table for a trigger was not shown in the DbExplorer's \ 
trigger list
 - For PostgreSQL, COPY ... FROM STDIN did not work if no row data was provided
 - POI 5.2 introduced new memory limits when reading XLSX. The built-in limits \ 
have been increased and can now be configured.
 - It's now possible to include column comments in the HTML output of "Save \ 
Data As" and "Copy data to clipboad".
 - Code completion now shows comments for tables and columns.
 - Connection profile groups can now be nested.
 - WbExport will now generate a unique sheet name when exporting to an Excel \ 
sheet and using -append and no sheet name was specified.

Bug fixes

 - The space for the execution time in the status bar was incorrectly calculated \ 
with some fonts
 - If macros where filtered when saving them, only the filtered ones were saved \ 
(regression from 129.6)
 - The parameter -ignoreMissingColumns was not honored by WbImport when \ 
importing Excel files
 - Selected rows were no longer highligted in a result grid (regression from 129.5)
 - Connection profiles could not be loaded if the stored list of expanded groups \ 
contained a non-existing group.
 - Column comments were always retrieved for queries, even if disabled.
 - On Linux, external formatters could not be called due to incorrect quoting of \ 
the executable (Issue #39)
 - For PostgreSQL, columns with the data type time could not be exported or copied
 - Variables defined through WbVarDef in a "after connect" script were \ 
not set when using "Separate variables per window"
 - The SQL formatter did not treat CREATE OR REPLACE statements properly
 - Formatting statements using CREATE OR REPLACE TABLE was not correct
 - Loading of profiles did not work if the last profile selected contained a / \ 
in its name.
 - The macro popup window did not show the macros any more.
 - For MySQL, the DDL for columns with the data type binary(n) was not generated \ 
correctly
 - For PostgreSQL, partitioned tables could not be dropped through the \ 
DbExplorer or DbTree
 - Loading of old profiles didn't work if some (or all) were still using the \ 
"Default Group"
 - When using real tabs in the editor, the position of the following characters \ 
wasn't calculated correctly
 - The statements in the script from "Show script" when using the DROP \ 
dialog in the DbExplorer were not terminated with a semicolon.
 - Table names that contain a dot (e.g. "some.table") were not handled \ 
correctly when generating queries for them.
 - For PostgreSQL, retrieving event triggers did not work any more.