---
- branch: MAIN
  date: Fri Jul 29 11:43:36 UTC 2016
  files:
  - new: '1.3'
    old: '1.2'
    path: pkgsrc/databases/sql-workbench/Makefile
    pathrev: pkgsrc/databases/sql-workbench/Makefile@1.3
    type: modified
  - new: '1.4'
    old: '1.3'
    path: pkgsrc/databases/sql-workbench/distinfo
    pathrev: pkgsrc/databases/sql-workbench/distinfo@1.4
    type: modified
  id: 20160729T114336Z.05b93db1656c9399b7fbcc8fc88bcab9a5e8217d
  log: |
    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
  module: pkgsrc
  subject: 'CVS commit: pkgsrc/databases/sql-workbench'
  unixtime: '1469792616'
  user: abs