./databases/sql-workbench, JDBC-based cross-platform SQL query tool

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 130, Package name: sql-workbench-130, Maintainer: asau

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL
query tool. It is written in Java and should run on any
operating system that provides a Java Runtime Environment.

Its main focus is on running SQL scripts (either interactively
or as a batch) and export/import features. Graphical query
building or more advanced DBA tasks are not the focus and are
not planned.


Required to run:
[lang/openjdk8]

Required to build:
[pkgtools/cwrappers]

Master sites:

Filesize: 9339.085 KB

Version history: (Expand)


CVS history: (Expand)


   2023-12-31 16:27:26 by David Brownlee | Files touched by this commit (3) | Package updated
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.
   2021-10-26 12:10:08 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched
conditionally):

./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz
   2021-10-07 15:35:53 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Remove SHA1 distfile hashes
   2021-09-30 17:50:33 by David Brownlee | Files touched by this commit (3)
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
   2019-11-02 16:38:12 by Roland Illig | Files touched by this commit (115)
Log message:
databases: align variable assignments

pkglint -Wall -F --only aligned -r

No manual corrections.
   2019-10-10 15:32:04 by Greg Troxel | Files touched by this commit (1)
Log message:
databases/sql-alchemy: Mark as non-Free

License is boutique and not in licenses/, so set to generic-nonlicense
for now.  Set RESTRICTED due to entity use restrictions, and because
at least some entities/people may not distribute, set NO_*_ON_*.
(I hope this is what the package authors intended...)
   2018-12-11 16:29:31 by David Brownlee | Files touched by this commit (3)
Log message:
Updated databases/sql-workbench to 124

Build 124 (2018-08-20)

Enhancements

 - WbExport can now write .xlsm files ("XLSX with Macros")
 - In the auto-completion popup for columns, the column's data type is now displayed
 - For PostgreSQL, row-level policies created for a table are now shown in the \ 
generated DDL
 - Added auto-completion support for Oracle's SHOW command
 - Added auto-completion support for PostgreSQL's SHOW, SET and RESET commands
 - Added support for new features in PostgreSQL 11
 - Improved support for Greenplum
 - It's now possible to lock a result not only through the GUI, but also through \ 
the annotation WbKeepResult
 - It's now possible to define global SSH hosts that can be selected for each \ 
connection profile
 - It's now possible to display the column's table in a query result if the JDBC \ 
driver provides that information
 - When importing Excel sheets it's now possible to disable the automatic \ 
re-calculation of formulas
 - It's now possible to use multiple profile files by specifying a directory \ 
through the -profileStorage parameter
 - It's now possible to define environment variables for the programs started \ 
through WbSysExec
 - For PostgreSQL, user defined collations are now shown in the DbExplorer and DbTree
 - For PostgreSQL, Oracle and SQL Server time zone information can now be \ 
displayed for columns that contain that information (TIMESTAMP WITH TIME ZONE or \ 
datetimeoffset)
 - For DB2 for I, variables are now shown in the DbExplorer and DbTree
 - For DB2 for I, the character set of columns (CCSID) is now shown in the \ 
generated DDL statements.
 - It's now possible to use the schema filter expressions from the connection \ 
profile as parameters to the JDBC API call to speed up schema retrieval.
 - It's now possible to define more flexible filters for the DbExplorer's table list

Bug fixes

 - For Postgres, WbCopy was not able to write values into TIMESTAMPTZ column.
 - For Oracle versions 10 or lower, the source of materialized views was no \ 
longer displayed.
 - For Oracle, when displaying the procedures in the DbExplorer and choosing \ 
"*" for the schema, the procedure owner was no longer shown in the \ 
list of procedures.
 - For SQL Server, the DROP statement generated for sequences was not correct.
 - If the option "Always allow "Execute selected" was disabled, \ 
directly after opening the window "Execute Selected" would still run \ 
all statements.
 - Running a macro by using the macro's name did not work if there was a comment \ 
preceding the macro's name in the editor.
 - When a result was locked ("Keep result") subsequent new result tabs \ 
were not always activated automatically.
 - When connecting to a profile with a corrupted workspace, the main window was \ 
not usable any more.
 - Additional libraries were no longer loaded when starting SQL Workbench/J \ 
using "java -jar sqlworkbench.jar"
 - When multiple columns where selected in a result, the "Filter by \ 
value" was applied using only the first selected column.
 - The -commitEvery parameter for WbImport and WbCopy did not work
 - When using WbConnect with nested WbIncludes, the connection would not be \ 
closed if an error occurred
 - When using "Check foreign keys" in the dialog to drop multiple \ 
objects, non-table objects were removed.
 - "Save As" did not use the profile's default directory
 - The default directory of the profile was not used when opening files
 - Implemented a workaround for SQLite, so that invalid DATE values could be \ 
read from columns defined as DATE.
 - When using "quoteCharEscaping=duplicate" with WbImport, empty \ 
strings or strings that only contained a single (escaped) quote character were \ 
not imported correctly.
 - In case of an error, the cursor in the editor was no longer moved to the \ 
error position.
 - For PostgreSQL, the generated DDL for foreign servers was incorrect
 - For Oracle, NUMBER columns without precision were exported with a decimal \ 
separator to Excel files.
 - Showing rowcounts in the DbExplorer did not work.
 - For Oracle, the result of functions returning a refcursor was not displayed \ 
correctly.

Build 123 (2017-09-25)

Enhancements

 - It's now possible to jump between statements in the editor.
 - For Postgres global objects are now shown in the DbTree and DbExplorer
 - WbExport now supports specifying a format pattern when exporting numbers to \ 
text files.
 - Expandable macros now also support placeholders for the selected text and \ 
statement.
 - WbDataDiff can now optionally create INSERT statements for tables that do not \ 
exist in the target database.
 - Added support for new Postgres 10 features (partitioning, identity columns)
 - For Firebird, DOMAINs are now included in the dependency display
 - WbImport now also supports the -skipTargetCheck option
 - It's now possible to define a default directory for a connection profile that \ 
is used e.g. for WbInclude or WbExport
 - The default encoding used for files in the editor can now be changed in the \ 
options dialog
 - WbImport and WbExport now support the -locale parameter to define the locale \ 
used for parsing and formatting dates and timestamps
 - For Postgres, the type of an index (btree, brin, gist, gin, ...) is now shown \ 
in the DbExplorer
 - For Postgres, TYPEs are now included in the dependency display
 - The formatting of numbers can now be controlled in more detail
 - For SQL Server and MySQL the USE command now supports code-completion
 - Generated DDL scripts now only contain commit statements if the current \ 
connection is not set to auto-commit (and the DBMS supports transactional DDL)
 - For Postgres, a tablespace other then pg_default will now be displayed in the \ 
generated source for tables and indexes

Bug fixes

 - SQL Workbench could not be started with Java 9
 - BLOB and NVARCHAR literals were not handled correctly when formatting a statement
 - Replacing variables inside other variables did not always work
 - WbSchemaDiff did not handle multiple indexes on the same column list correctly
 - It was no longer possible to connect to a SAP DB
 - Navigating foreign keys from the result set did not work for non-numeric data \ 
types
 - Made saving of Workspaces more robust against errors.
 - For SQL Server, if integratedSecurity=true was used, SQL Workbench still \ 
prompted for a password
 - Made the SQL formatter more robust against useless parentheses around sub-selects
 - When an expandable macros was invoked through the menu, the cursor position \ 
was not correct when using ${c}
 - It was not possible to change the statement/query timeout in GUI mode using \ 
SET TIMEOUT
 - Detaching a result was longer possible in build 122.2
 - The option "Remove comments" was not working with databases are \ 
using non-standard characters to quote identifiers
 - For Oracle, the display format for timestamps was not used for \ 
"timestamp with time zone" values
 - SSH tunneling did not work with Oracle when using a service name in the JDBC URL
 - If the MacroPopup was open and a profile with a different macro file was \ 
loaded, the macros in the popup weren't re-loaded
 - Fixed the handling of long column names in the dialog to select columns
 - WbCopy did not work if there was another object (e.g. a sequence or view) in \ 
the source database with the same name as the table specified with -sourceTable
 - The dialog to select columns for copying them to the clipboard did not \ 
display all options on Mac OSX.
 - Changing between connection profiles that had a non-standard macro file and \ 
profiles using the standard macro file could lead to a situation where the \ 
standard macros were no longer available.
 - "Put SELECT into Clipboard" did not work any longer in the DbTree \ 
or DbExplorer
 - Using -sourceDir to import multiple files into a single table did not work if \ 
-fileColumns was not specified
 - WbDataDiff failed when using -includeDeletes=true and the comparison was done \ 
between two DBMS that stored object names differently (e.g. UPPER vs. lowercase)
 - The parameter -varFile did not work anymore
 - For Oracle, the "realplan" option for autotrace did not work for \ 
queries starting with a common table expression (WITH)
   2017-06-12 14:07:39 by David Brownlee | Files touched by this commit (3) | Package updated
Log message:
Updated databases/sql-workbench to 122

Also some minor pkglint

Build 122 (2017-02-04)
Enhancements

    Conditional execution of Workbench commands now support -isDBMS and -isNotDBMS
    Added basic support for EXAsol
    Added support for SSH tunneling per connection profile
    When loading a SQL script it's now possible to automatically detect the encoding
    It's now possible to filter the output of WbVarList
    It's now possible to pin a result tab so that it doesn't get closed even if \ 
append mode is not enabled
    WbExport, WbImport, WbCopy and WbConfirm now support conditional execution
    WbTriggerSource now also supports writing the source to a file
    For Postgres, dependencies between triggers and tables are no shown in the \ 
DbExplorer and DbTree
    For Postgres, functions defined as "returns setof refcursor" are \ 
now processed correctly when using "select * from function()"
    For Postgres, it's now possible to import values into array columns if the \ 
source data is formatted as a Postgres array literal (WbImport and WbCopy)
    A new annotation (@WbCrossTab) is available to create simple crosstabs (aka \ 
"pivot") from query results.
    Improved editing of Postgres' hstore result columns.
    For SQL Server, the object dependencies now include named default \ 
constraints and custom data types

Bug fixes

    For Oracle the DDL for tables using reference partitioning was not generated \ 
correctly
    In batch mode when specifying a connection profile using -profile, the \ 
setting to ignore drop errors from the profile was ignored
    The width of the DbTree was limited if the DbExplorer panel was also displayed
    For HSQLDB, BIT columns were not displayed correctly.
    For Oracle, the DEDUPLICATION option was not shown for LOB columns
    Auto completion did not overwrite a partial table (or column) name if that \ 
part was a SQL keyword.
    Activating the object list filter in the DbExplorer by using the toolbar \ 
button did not work reliably.
    Passing connection properties using -connectionProperties to WbCreateProfile \ 
did not work
    When using a profile specific macro file, opening a new window did not \ 
always work.
    When using an Oracle 12.x JDBC driver, materialized views were always \ 
reported as missing with WbSchemaDiff
    It was no longer possible to select "As Is" for the built-in SQL \ 
formatter
    Several features in the DbExplorer did not work for Amazon Redshift
    Feedback from connect scripts was not always shown in the message tab
    Error messages were not shown for errors that occurred in connect scripts
    For Postgres, the remarks for indexes were not retrieved correctly if \ 
indexes with the same name existed in different schemas
    The formatter did not treat the := operator properly for MySQL
    For Postgres, the source of a table was not shown when an old (unsupported) \ 
version of Postgres was used
    For SQL Server (and other DBMS supporting schemas and catalogs) the list of \ 
schemas was not properly refreshed when the database was changed in the \ 
DbExplorer's dropdowns
    For Oracle, value literals for RAW columns where not created correctly
    For Oracle, -clobAsFile for WbExport was not working for XML columns
    For Oracle, overloaded procedures inside packages where no longer displayed.
    For SQL Server, the source of procedures, functions and triggers was not \ 
displayed correctly in the DbExplorer for databases other then the default \ 
database of the connection.
    When using -configDir in console mode the connection profiles were still \ 
loaded from the default location.
    For Postgres, when generating scripts for tables and sequences the owner \ 
column for a sequence was not correctly generated.

Build 121 (2016-07-31)
Bug fixes

    Some DDL statements were not generated properly when changing tables or \ 
indexes in the DbExplorer
    For Oracle, columns defined as TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH \ 
LOCAL TIMEZONE where not displayed correctly
    It was no longer possible to use a timestamp format without time for WbImport
    When loading a new macro file, the macro menu was not updated.