Log Message:
Updated databases/sql-workbench to 127

Build 127 (2020-08-22)
Bug fixes

 - It was no longer possible to run GRANT or REVOKE statements.

Build 126 (2020-08-09)
Enhancements

 - WbExport will now abort if a text export is started without a quote character \ 
but a quote character would be needed.
 - For PostgreSQL, subscriptions and publications for logical replication are \ 
now shown in the DbTree and DbExplorer.
 - For PostgreSQL, the attribute of IDENTITY REPLICA is now shown in the \ 
generated DDL.
 - "Make uppercase" and "Make lowercase" now also work if no \ 
text is selected. In that case, (only) the character at the cursor is changed
 - Passwords can now securely be encrypted using a master password. The old \ 
password encryption is no longer supported.
 - The properties base profile storage (wb-profiles.properties) is now the \ 
default. The old XML format is still supported.
 - WbVarDef now supports conditional execution.
 - WbCopy now supports views as the source by using -includeViews=true.
 - The result panel is now automatically displayed if it was minimized before \ 
running a statement.
 - It's now possible to configure italic and bold for syntax highlighting
 - For SQL Server, partitioning information about a table is now included in the \ 
generated DDL
 - WbImport can now import all sheets of a spreadsheet into the same table when \ 
-sheetName=* is specified together with -table
 - The annotation @WbResultAsText can now be used to turn the "text \ 
mode" display on for multiple statements
 - For PostgreSQL, the "match mode" of foreign key constraints is now \ 
displayed and included in the generated DDL
 - A new Windows launcher is available that removes the need for a separate 64 \ 
and 32 bit executables and can optionally download a JRE
 - It's now possible to optionally open the saved file when using "Save As"
 - It's now possible to use a special variable in WbImport to assign the input \ 
file's line number to a column.
 - It's now possible to cycle through the result tabs using a keyboard shortcut.
 - When exporting a single table from the table list (Database Explorer or \ 
DbTree) it's now possible to select the columns to export.
 - It's now possible to display results in GUI mode as "text" in the \ 
messages area.
 - It's now possible to define a SQL expression to be used in the INSERT \ 
statement that WbImport uses to apply SQL functions on the input value.
 - Selecting foreign key values is now also supported for DELETE statements.
 - The list of shortcut keys can now be exported (with the usual "Save \ 
As" formats)
 - Invoking code completion in the WHERE clause without a column now displays \ 
all columns of all used tables of the query
 - For MySQL and MariaDB versions that support them, check constraints are now \ 
shown in the generated DDL
 - Recently opened files are now accessible through the "File" menu.
 - For PostgreSQL, default values on columns of views are now shown in the \ 
generated DDL
 - For HSQLDB 2.5, the new options for temporal tables are now shown in the \ 
generated DDL
 - Added new command WbSetSchema to change the current schema using the driver's \ 
JDBC API
 - For PostgreSQL 12, the new computed columns are now shown in the generated DDL
 - The tooltip of a column header now always includes the table name if available

Bug fixes

 - For Redshift, tables sources were not always displayed
 - When using WbImport with mode=upsert and a table that has a multi-column \ 
primary key, the wrong MERGE statement was generated for SQL Server, HSQLDB and \ 
DB2
 - When exporting to ODS, the generated files could not be opened with Microsoft \ 
Excel.
 - Using nested WbIncludes failed with an exception
 - When invoking code-completion in the ON part of a JOIN, not tables where shown.
 - When selecting a global SSH configuration for a connection profile, it was no \ 
longer possible to revert to a "non-global" configuration
 - When specifying a SSH Tunnel without a password and no keyfile, SQL Workbench \ 
did not prompt for the password
 - For WbCopy, when using -createTarget=true together with -targetSchema the new \ 
table was created in the wrong schema
 - Fixed an issue when loading the SQL Server JDBC driver with certain versions \ 
of OpenJDK
 - For SQL Server, when including the CREATE TABLE statement in the output when \ 
exporting data as SQL the export failed
 - WbDataDiff did not work properly if the key columns contained NULL values.
 - When exporting or saving data, it was not possible to enter the filename \ 
manually into the dialog.
 - Month names were case sensitive when using -dateFormat or -timestampFormat \ 
with WbImport
 - For Oracle 18c and later, index information wasn't displayed correctly.
 - For Oracle 18c and later, DDL for identity columns wasn't generated correctly.
 - For Oracle, the generated IGNORE_DUP_KEY hint was incorrect if the order of \ 
the PK columns was different to the column order of the table.
 - Assigning multiple variables with WbVarDef was not possible if -variable was used.
 - For Redshift, finding tables on the search path was no longer working.
 - For PostgreSQL, using the JDBC driver 42.2.11, the value for columns defined \ 
as "timestamp with time zone" could not be retrieved any longer.
 - The cursor position wasn't calculated correctly, if real tabs where used in \ 
the editor (regression from 125.6)
 - Sorting columns defined as arrays in the result did not work properly.
 - The new Windows launcher (introduced in 125.5) did not work if run from a \ 
directory with spaces in the name
 - Fixed some problems with the cursor position in the editor with High-DPI \ 
displays (on Windows)
 - For PostgreSQL, the DDL for partitioned tables with sub-partitions was not \ 
generated correctly
 - Using WbImport with temp tables as the target did not work with PostgreSQL \ 
and SQL Server
 - When using UCanAccess certain types of "linked columns" are now \ 
displayed correctly.
 - For DB2 on AS/400 the CSID attribute was also generated for data types where \ 
it wasn't relevant.
 - Individual statements were not detected correctly in the editor if the text \ 
started with a semicolon.
 - "Create SQL List" did not work properly if only a part of the first \ 
or last line was selected.
 - For PostgreSQL, the dependency display of trigger functions wasn't working \ 
any more.
 - When using Page Down when the editor text was shorter than the number of \ 
lines, the display was corrupted.
 - When closing the macro dialog while macros were filtered, only the visible \ 
macros were saved.
 - For PostgreSQL, check constraints and default values were no longer displayed \ 
correctly in the generated DDL
 - For XLSX exports, using -infoSheet did not work any longer
 - When using -endRow with WbImport, the following rows weren't exported, but \ 
the input file was still read until the end
 - Filtering the list of macros did no longer work correctly.
 - For SQLite, all values are now retrieved as strings to workaround problems \ 
with the lack of explicit data types.
 - Common table expressions containing DML are now correctly identified when the \ 
"Read Only" option is selected in the connection profile.
 - The XML file generated by WbSchemaDiff was incorrect when multiple views need \ 
to be dropped.
 - The SQL formatter removed trailing semicolons if only a single statement was \ 
formatted.
 - Fractional seconds were not correcly formatted in timestamp literals in \ 
generated SQL statements.
 - When editing a result with columns from multiple tables where the columns \ 
were not fully qualified, an exception occurred rather than a usable error \ 
message.
 - Conditional execution of Workbench commands using -ifDefined and \ 
-ifNotDefined behaved the same as -ifEmpty and -ifNotEmpty
 - For Postgres, infinity values for timestamp with time zone could not be read \ 
from the database.
 - If the JDBC driver returned LocalDateTime or LocalDate values, those weren't \ 
formatted properly in SQL statements or text files.

Build 125 (2019-05-08)
Enhancements

 - All additional libraries are now expected in the directory "ext".
 - In the DbExplorer, using "Show Rowcounts", now displays the row \ 
counts as a new column in the table list.
 - WbDataDiff now also supports -clobAsFile when generating SQL statements
 - For WbExport and WbDataDiff -clobFileThreshold has been added
 - For MariaDB 10.3, sequences are now displayed in the DbExplorer
 - The "Manage Macros" dialog now also supports filtering of the macros.
 - For Oracle, the generated DDL for tables now contains the definitions of \ 
extended column statistics.
 - It's now possible to control the behaviour of WbDefineVar when NULL values \ 
are retrieved through a SQL query
 - It's now possible to specify a message with WbEcho that is displayed even if \ 
verbose logging was turned off (e.g. using -verbose=false for WbInclude)
 - For WbExport and WbImport, it's now possible to define the values for \ 
-quoteChar and -delimiter using unicode escape notation (e.g. \0008)
 - WbDefineVar now supports the -silent option so suppress the details about the \ 
defined variable
 - For conditional execution of some SQL Workbench/J commands, checking for the \ 
(non) existence of files or tables is now supported
 - For Postgres, comments on foreign key constraints are now displayed in the \ 
DbExplorer and the generated DDL source
 - Confirmation to close "Other tabs" can now be configured separately.

Bug fixes

 - For SQL Server, DateTime values were not displayed correctly
 - For Oracle the source of materialized views using ON PREBUILT TABLE was incorrect.
 - Relative file names were treated differently by the SQL Workbench commands \ 
and the ifFileExists check.
 - For MySQL, the source of triggers wasn't displayed.
 - Copy to clipboard did not use the format string for decimal values
 - For Oracle, using -mode=upsert with CLOB columns did not work for WbImport
 - For some JDBC drivers, the console did not display the column's alias, but \ 
the real column name in a result
 - For Postgres, nesting dollar quoted strings did not work.
 - When retrieving XML columns using a driver that supports the JDBC API \ 
getXML() NULL values would result in an error.
 - For Postgres, the generated source for an extension in the DbExplorer was not \ 
correct.
 - The detection of the DB2 version was no long working correctly
 - Numbers that can't be stored in Excel's file format are now exported as \ 
strings rather than numbers
 - For Oracle, certain timestamp values were incorrectly exported.
 - For Oracle 12, statements using "WITH FUNCTION" or "/*+ \ 
WITH_PLSQL */" to create inline PL/SQL functions could not be executed.
 - WbCall did not display values for OUT parameters for all data types.
 - For Oracle, the status of foreign keys (enabled, validated) was no longer \ 
displayed in the DbExplorer.
 - For PostgreSQL, retrieving the policies for row level security was not \ 
working for versions prior to 10 any more.
 - When using -profileStorage wih a filename without a path, files located in \ 
the config directory where not found
 - Generating a SQL script using WbDataDiff on tables with timestamptz columns \ 
in Postgres did not work