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)

3 files changed, 14 insertions, 14 deletions

diff --git a/databases/sql-workbench/Makefile b/databases/sql-workbench/Makefile
index 4d5805cffe3..1973c15c7d2 100644
--- a/databases/sql-workbench/Makefile
+++ b/databases/sql-workbench/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.4 2017/06/12 12:07:39 abs Exp $
+# $NetBSD: Makefile,v 1.5 2018/12/11 15:29:31 abs Exp $
 
-DISTNAME=	Workbench-Build122
-PKGNAME=	sql-workbench-122
+DISTNAME=	Workbench-Build124
+PKGNAME=	sql-workbench-124
 CATEGORIES=	databases
 MASTER_SITES=	http://www.sql-workbench.net/
 EXTRACT_SUFX=	.zip
@@ -12,10 +12,10 @@ COMMENT=	JDBC-based cross-platform SQL query tool
 
 EXTRACT_DIR=	${WRKSRC}
 
-USE_JAVA=	run
-USE_JAVA2=	8
-PKG_JVMS_ACCEPTED=  oracle-jdk8 openjdk8
-USE_TOOLS+=	pax
+USE_JAVA=		run
+USE_JAVA2=		8
+PKG_JVMS_ACCEPTED=	oracle-jdk8 openjdk8
+USE_TOOLS+=		pax
 
 INSTALLATION_DIRS=	bin share/${PKGBASE}
 
diff --git a/databases/sql-workbench/PLIST b/databases/sql-workbench/PLIST
index 1a7a457bfe7..16e2f7eb253 100644
--- a/databases/sql-workbench/PLIST
+++ b/databases/sql-workbench/PLIST
@@ -1,8 +1,7 @@
-@comment $NetBSD: PLIST,v 1.3 2016/08/23 14:49:23 abs Exp $
+@comment $NetBSD: PLIST,v 1.4 2018/12/11 15:29:31 abs Exp $
 bin/sqlworkbench
 share/sql-workbench/LICENSE
 share/sql-workbench/SQLWorkbench-Manual.pdf
-share/sql-workbench/SQLWorkbench.desktop
 share/sql-workbench/SQLWorkbench.exe
 share/sql-workbench/SQLWorkbench.vbs
 share/sql-workbench/SQLWorkbench64.exe
@@ -70,6 +69,7 @@ share/sql-workbench/sqlwbconsole.exe
 share/sql-workbench/sqlwbconsole.sh
 share/sql-workbench/sqlwbconsole64.exe
 share/sql-workbench/sqlworkbench.cmd
+share/sql-workbench/sqlworkbench.desktop
 share/sql-workbench/sqlworkbench.jar
 share/sql-workbench/sqlworkbench.sh
 share/sql-workbench/workbench32.png
diff --git a/databases/sql-workbench/distinfo b/databases/sql-workbench/distinfo
index 33cb789fe0e..e7b520a2e73 100644
--- a/databases/sql-workbench/distinfo
+++ b/databases/sql-workbench/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.5 2017/06/12 12:07:39 abs Exp $
+$NetBSD: distinfo,v 1.6 2018/12/11 15:29:31 abs Exp $
 
-SHA1 (Workbench-Build122.zip) = c9cd1a2230997855be3ab7d7b5a422c5b61180fa
-RMD160 (Workbench-Build122.zip) = d9063222d487db1a94e8ea1681fa2723cace0295
-SHA512 (Workbench-Build122.zip) = 97a7c5628c0f18ffcdbd624d932f25e28db1901cb6dcd1d6468d8311089777fe64e157fab44fae64b14fa98c503210471fe60b93348c5977f1a61ea653bf6d2e
-Size (Workbench-Build122.zip) = 6569442 bytes
+SHA1 (Workbench-Build124.zip) = e0f8eb4625e8c11de0b3c4440a1c64da98dc78aa
+RMD160 (Workbench-Build124.zip) = 5780052b1ba96119320270b57a897da39fad7de3
+SHA512 (Workbench-Build124.zip) = 82dc66199ad8f13fde96a6b2126ac54bd8108af8f15212daf10d2359fff1400607c557caca1a917ae93e3a5ab66791a0f6f57fa21f19814958d64822acb84026
+Size (Workbench-Build124.zip) = 6868177 bytes