CVS commit: pkgsrc/databases/sql-workbench

["David Brownlee" <abs%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   abs
Date:           Fri Jul 29 11:43:36 UTC 2016

Modified Files:
        pkgsrc/databases/sql-workbench: Makefile distinfo

Log Message:
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


To generate a diff of this commit:
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/sql-workbench/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/sql-workbench/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/sql-workbench/Makefile
diff -u pkgsrc/databases/sql-workbench/Makefile:1.2 pkgsrc/databases/sql-workbench/Makefile:1.3
--- pkgsrc/databases/sql-workbench/Makefile:1.2 Thu Mar  3 17:43:45 2016
+++ pkgsrc/databases/sql-workbench/Makefile     Fri Jul 29 11:43:36 2016
@@ -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

Index: pkgsrc/databases/sql-workbench/distinfo
diff -u pkgsrc/databases/sql-workbench/distinfo:1.3 pkgsrc/databases/sql-workbench/distinfo:1.4
--- pkgsrc/databases/sql-workbench/distinfo:1.3 Thu Mar  3 17:43:45 2016
+++ pkgsrc/databases/sql-workbench/distinfo     Fri Jul 29 11:43:36 2016
@@ -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