Subject: CVS commit: pkgsrc/databases/sql-workbench
From: David Brownlee
Date: 2016-07-29 13:43:36
Message id: 20160729114336.664A5FBB5@cvs.NetBSD.org

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

Files:
RevisionActionfile
1.3modifypkgsrc/databases/sql-workbench/Makefile
1.4modifypkgsrc/databases/sql-workbench/distinfo