[pkgsrc/trunk]: pkgsrc/databases/sql-workbench Updated databases/sql-workbenc...

[abs <abs%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/44173ad4a9f2
branches:  trunk
changeset: 350552:44173ad4a9f2
user:      abs <abs%pkgsrc.org@localhost>
date:      Fri Jul 29 11:43:36 2016 +0000

description:
Updated databases/sql-workbench to 120

Enhancements

* It's now possible to delete variables using wildcards
* It's now possible to test the connection from the profile dialog
* For Postgres, the generated source code for functions and custom aggregates now contains the new PARALLEL settings for Postgres 9.6
* It's now possible to show a quick filter in the macro popup window
* When searching for a JDBC driver class in the driver's jar file, available service registrations are used to speed up the searching.
* It's now possible to disable icons in menus
* For HSQLDB 2.3.4 synonyms are now displayed
* It's now possible to configure the buttons on the toolbar
* It's now possible to restore recently closed editor tabs
* For Progress OpenEdge, squences and synonyms are now shown in the DbExplorer
* It's now possible to associate variables with the connection profile and the workspace
* For SAP HANA the source for synonyms are now shown
* For SAP HANA dependency for tables, views, triggers, procedures and sequences are now shown in the DbExplorer and DbTree
* A new command (WbGenerateFKScript) is available to generate the DDL for only the foreign key constraints.
* For DB2 10.5 indexes based on expressions are now shown correctly

Bug fixes

* For SQL Server, the source code for user defined object types with columns was incorrect.
* For DBMS supporting catalogs and schemas, auto completion for large schemas was slow.
* Fixed a problem where in rare cases, closing an editor tab could hang the application.
* Ignoring the "Max Rows" setting in the DbExplorer's table data did not work any more
* WbListMacros, WbDeleteMacro and WbDefineMacro were always using the default macro file
* Timestamps with microseconds (.SSSSSS in the format) where not imported correctly with WbImport
* For Postgres, the LEAKPROOF attribute was not included in the generated source code for functions
* WbSchemaDiff incorrectly combined all tables to be dropped in a single tag
* For Postgres, the format of hstore literals was not correct when exporting data as SQL statements
* For Postgres, hstore columns could not be edited in a query result
* The ALTER TABLE OWNER TO statement for Postgres was not created correctly
* It wasn't possible to use -mode=Upsert or -mode=InsertIgnore with WbCopy
* Parsing of comments in SQL statements is now more lenient with invalid (nested) comments
* When changing the position of SQL tabs with files loaded, the Workspace was not saved properly
* For Progress OpenEdge, the SQL generated for sequences was invalid
* For Postgres, the implizit index for an exclusion constraint was incorrectly added to the souce of the table
* The format of a hstore and array literals was not correct for generated SQL statements
* For Oracle procedures from packages that contained only procedures without parameters were not displayed.
* Implemented a workaround for the MariaDB JDBC driver that returns invalid object type names for tables ("BASE TABLE" instead of "TABLE")
* Generate "DROP script with dependencies" was no longer working in the DbExplorer or DbTree
* When using SQL Workbench in batch mode, passing quoted parameters on the command line did not work properly
* The DDL for tables was not displayed when using Amazon Redshift
* Using sqlwbconsole.sh together with -command or -script on a headless system did not work
* The display for LVARCHAR and DATE columns was not always correct for Informix
* Warnings that were reported by the JDBC driver after establishing the connection were sometimes shown in the generated DDL in the DbTree
* The DDL for sequences in Oracle did not reflect the values for CYCLE and ORDER
* Running PL/SQL in Oracle did not work if the option "Remove comments" was enabled in the connection profile
* When using "Create DDL script" in the DbExplorer, the source for materialized views was generated twice
* With certain Oracle driver versions, TYPEs where displayed twice in the DbExplorer or the DbTree
* When exporting to text files, values containing the line delimiter were not quoted properly
* With SQL Server, it was not possible to drop indexes from within the DbTree
* Passwords are no longer trimmed

diffstat:

 databases/sql-workbench/Makefile |   6 +++---
 databases/sql-workbench/distinfo |  10 +++++-----
 2 files changed, 8 insertions(+), 8 deletions(-)

diffs (29 lines):

diff -r 3ae3d54874cb -r 44173ad4a9f2 databases/sql-workbench/Makefile
--- a/databases/sql-workbench/Makefile  Fri Jul 29 11:41:28 2016 +0000
+++ b/databases/sql-workbench/Makefile  Fri Jul 29 11:43:36 2016 +0000
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.2 2016/03/03 17:43:45 asau Exp $
+# $NetBSD: Makefile,v 1.3 2016/07/29 11:43:36 abs Exp $
 
-PKGNAME=       sql-workbench-119
-DISTNAME=      Workbench-Build119
+PKGNAME=       sql-workbench-120
+DISTNAME=      Workbench-Build120
 CATEGORIES=    databases
 MASTER_SITES=  http://www.sql-workbench.net/
 EXTRACT_SUFX=  .zip
diff -r 3ae3d54874cb -r 44173ad4a9f2 databases/sql-workbench/distinfo
--- a/databases/sql-workbench/distinfo  Fri Jul 29 11:41:28 2016 +0000
+++ b/databases/sql-workbench/distinfo  Fri Jul 29 11:43:36 2016 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.3 2016/03/03 17:43:45 asau Exp $
+$NetBSD: distinfo,v 1.4 2016/07/29 11:43:36 abs Exp $
 
-SHA1 (Workbench-Build119.zip) = ad30bc5c4cc712c664c8df21c0ea6bb5ed30f8c7
-RMD160 (Workbench-Build119.zip) = 894ceff8e0038bdd633e55f46bc3dba2ea101758
-SHA512 (Workbench-Build119.zip) = aaca639ba5f1d82ad8d51950708c97cde419a0ec49b95f3971834f15817bf5467400f86c93d66b676807cfa1c1596ec5cd3e68dfdb018c3843b36c08be121135
-Size (Workbench-Build119.zip) = 6057652 bytes
+SHA1 (Workbench-Build120.zip) = f54a651716a5f53006f3204612aec40068966b38
+RMD160 (Workbench-Build120.zip) = ac910996d8b7862c01a4b6b068e04defa5d6f3d8
+SHA512 (Workbench-Build120.zip) = 42e90880f2c2b61fefafb4eeb40fd73dce92265c9a771a8e72ba33678b6d28f3818e150e7122d0c6674bc559089724bf9aaca61f70620bfc77cd4c89bf2787b0
+Size (Workbench-Build120.zip) = 6203585 bytes