CVS commit: pkgsrc/databases/sql-workbench

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

Module Name:    pkgsrc
Committed By:   abs
Date:           Sun Dec 31 15:27:26 UTC 2023

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

Log Message:
Updated databases/sql-workbench to 130

Email MAINTAINER but no response since 19th November

Build 128 (2021-11-01)

Enhancements

 - SQL Workbench/J now requires Java 11 or later.
 - It's now possible to filter the list of shortcuts in the "Configure shortcuts" dialog.
 - For DB2i it's now possible to enable retrieving of "system names" for tables.
 - Then new "Copy as text" dialog now detects selected columns.
 - For XSLX, XLS and ODS exports it's now possible to specify column names that should be treated as formulas rather than "plain" values.
 - Added support for new features in PostgreSQL 14
 - WbImport now allows to specify a grouping character for importing numbers formatted with one
 - For Informix, unique and check constraint are not correctly included in the generated DDL.
 - WbImport can now read directly from GZipped files.
 - "Copy to clipboard" now uses the same dialog as "Save Data As" to allow full customization of the copied data
 - Improved compatibility with the FlatLaf look and feel.
 - It's now possible to dynamically change the statement delimiter using the WbDelimiter command.
 - When code completion for tables is shown, "table functions" (aka "set returning functions") are now included for DBMS that support them.
 - It's now possible to define macros that can be run from the context menu in the DbExplorer. Currently this is limited to table and column nodes.
 - A new command, WbRunResult to run the result of a query as a SQL script is available.
 - WbDataDiff now supports a parameter to control the way identity/autoincrement columns are handled in the generated INSERT statements
 - The console now supports basic auto-completion
 - When using WbInclude or running SQL scripts in batch mode, the last error is now available in SQL Workbench variables
 - The text and background color for the line numbers in the editor can now be configured
 - For WbExport, it's now possible to specify the literals to be used for boolean values
 - When using "Save data as..." it's now possible to include column comments the way -enableComments is working for WbExport
 - It's now possible to use an external pager when running in console mode

Bug fixes

 - For Postgres, the source of DOMAIN definitions was not generated correctly if check constraints were included.
 - Fixed a regression introduced in 127.5 that made -clobAsFile=true no longer work for some DBMS.
 - When printing results with NULL values, the layout of the printed table was not correct.
 - For Oracle, when using WbImport with -mode=upsert and -columnConstantValues, a wrong SQL statement was generated
 - For Postgres, when using WbImport with -mode=upsert and -columnConstantValues, the columns for the constant values were not included in the UPDATE part of the INSERT statement
 - When Using an Oracle connection without a username, displaying the table definition or the table's source resulted in an error
 - For some fonts, "Optimize column widths" did calculate the width incorrectly
 - Improved the performance for retrieving the list of procedures and functions in Oracle
 - For SQL Server, the DROP statements for multiple sequences wasn't generated correctly.
 - For Oracle, the COMPRESS attribute wasn't generated properly for tables and materialized views
 - Using WbImport with -columnExpression (to call functions on column values) wasn't working any more
 - Fixed cursor positioning problem on HiDPI displays for Windows
 - When using the properties based profiles, passwords that end with a backslash weren't loaded properly
 - Setting a (new) master password did not work if global SSH passwords were defined
 - For Oracle, using the alternate delimiter sometimes didn't work.
 - Fixed startup problems with the Windows launcher and Java 16.
 - Resetting a "separate connection" in a panel of the main window did not longer work if the DbTree was enabled.
 - When using "Save Data As" to generate MERGE statements, the column selection wasn't used.
 - When using -singleFile with WbDataDiff, values with empty lines weren't properly written to the output file.
 - When exporting data into an XLS Spreadsheet, existing number formatting wasn't always preserved.
 - Depending on the configuration, reading a NULL value for BLOB columns could result in an NullPointerException.
 - For Oracle, identifiers with leading underscores were not quoted correctly.
 - "Create VALUES list" did not always detect numbers correctly.
 - For WbExport and WbImport, using -quoteEscape=escape did not work correctly
 - For Oracle, the DDL for tables using sub-partioning templates wasn't correct.
 - For PostgreSQL, MariaDB and MySQL the precision of timestamp (datetime) columns was not shown.
 - For MySQL, the DbExplorer did not correctly show stored procedures.
 - For PostgreSQL, WbDataDiff did not work if the primary key contained citext columns
 - "Copy to clipboard" failed if any value contained a tab character.
 - When using "Show PDF Manual" the manual was expected in the wrong location.
 - When using "Separate connection per tab", the window title wasn't updated correctly when switching tabs

Build 129 (2022-10-23)

Enhancements

 - Double clicking on the grid line of a header column now adjusts the column width.
 - For DB2 for i, PostgreSQL and SQL Server additional connection properties are now shown in the "Connection Info"
 - It's now possible to configure the behaviour when closing a tab with a modified external file.
 - For PostgreSQL and Oracle, GRANTs for sequences are now shown in the generated SQL source
 - It's now possible to add multiple directories to the file system tree
 - When definining a JDBC driver, the jar file can now be downloaded from Maven central if available
 - It's now possible to assign a second, alternate keyboard shortcut for menu items
 - It's now possible to have a different set of variables per window.
 - Using FlatLaf themes is now supported.
 - The DbTree, Macro list and the new file browser can now be displayed at the same time as side panels.
 - It's now possible to search for tables or procedures from within the source panel of the DbExplorer.
 - It's now possible to jump to the corresponding table from within the trigger list.
 - In the DbTree, table nodes for "Uses", Used by", "References" and "Referenced by" can now be expanded to show the table details.

Bug fixes

 - When copying a result as SQL to the clipboard, timestamptz values for Postgres were not formatted correctly.
 - Some Workbench specific commands did not work if preceded with a comment containing quotes
 - Sorting results (by clicking on the header) did not work correctly for array columns (e.g. int[] in Postgres)
 - When importing from Excel sheet, make sure numbers formatted as strings are read as strings
 - For PostgreSQL, WbDataDiff didn't compare array columns correctly.
 - When copying data as text to the clipboard, columns with NULL or empty values were not copied correctly.
 - WbImport failed when using -quoteCharEscaping=duplicate and the first column of the input file contained a quoted empty string (e.g. "")
 - Setting a different background color for the editor was no longer working
 - For PostgreSQL, the source of trigger definitions wasn't generated properly if the same trigger existed in multiple schemas
 - For PostgreSQL, pg_get_constraintdef() is now used to generate the DDL for foreign keys
 - It was not possible to configure the color of the table grid lines for the FlatLaf Look & Feel
 - For PostgreSQL, the format for time columns wasn't used
 - For PostgreSQL, domains with multiple constraints weren't retrieved or displayed correctly.
 - It wasn't possible to assign keyboard shortcuts to "Indent" and "Un-Indent"
 - When changing the font size in the editor, the scrollbars weren't updated correctly
 - Zooming fonts with the mouse wheel did not work any longer.
 - The option to copy connection properties to system properties was not saved when the properties storage for connection profiles was used.
 - For PostgreSQL, implicit sequences (identity, serial) where not shown in the dependency of a table
 - When exporting to Excel (XLS, XLSX), SQL Workbench/J tries to cleanup invalid date/time formats
 - The "Save As" dialog wouldn't work, if the previously an XLS export was used, but the POI libraries aren't available
 - OpenDocument spreadsheets (.ods) where not generated correctly
 - For DB2 for i, the procedure GENERATE_SQL is now used for most objects to re-generate the DDL
 - The option "Use as retrieval filter" was not saved when connection profiles were stored as XML.
 - Fixed problems when moving the application between different HiDPI screens on Windows.
 - For DB2i, improved the performance when loading system names or remarks in the DbExplorer.
 - Removed the hard-coded alternate shortcut F9 for "Execute selected".
 - In the "Copy data to clipboard" dialog, the "Selected rows" option wasn't always enabled correctly.
 - If no backup directory was defined, opening of the "Backup" options wasn't possible.

Build 130 (2023-11-19)

Enhancements

 - It's now possible to search the settings dialog for specific labels.
 - Storing a workspace in a directory, rather than a ZIP archive (.wksp) is now supported.
 - Storing macros as SQL scripts in a directory, rather than an XML file is now supported.
 - For DB2 (LUW), tablespace information is now included in the generated DDL for tables.
 - WbSchemaDiff now writes a drop-constraint tag for indexes supporting unique constraints.
 - For DB2 (LUW), the table for a trigger was not shown in the DbExplorer's trigger list
 - For PostgreSQL, COPY ... FROM STDIN did not work if no row data was provided
 - POI 5.2 introduced new memory limits when reading XLSX. The built-in limits have been increased and can now be configured.
 - It's now possible to include column comments in the HTML output of "Save Data As" and "Copy data to clipboad".
 - Code completion now shows comments for tables and columns.
 - Connection profile groups can now be nested.
 - WbExport will now generate a unique sheet name when exporting to an Excel sheet and using -append and no sheet name was specified.

Bug fixes

 - The space for the execution time in the status bar was incorrectly calculated with some fonts
 - If macros where filtered when saving them, only the filtered ones were saved (regression from 129.6)
 - The parameter -ignoreMissingColumns was not honored by WbImport when importing Excel files
 - Selected rows were no longer highligted in a result grid (regression from 129.5)
 - Connection profiles could not be loaded if the stored list of expanded groups contained a non-existing group.
 - Column comments were always retrieved for queries, even if disabled.
 - On Linux, external formatters could not be called due to incorrect quoting of the executable (Issue #39)
 - For PostgreSQL, columns with the data type time could not be exported or copied
 - Variables defined through WbVarDef in a "after connect" script were not set when using "Separate variables per window"
 - The SQL formatter did not treat CREATE OR REPLACE statements properly
 - Formatting statements using CREATE OR REPLACE TABLE was not correct
 - Loading of profiles did not work if the last profile selected contained a / in its name.
 - The macro popup window did not show the macros any more.
 - For MySQL, the DDL for columns with the data type binary(n) was not generated correctly
 - For PostgreSQL, partitioned tables could not be dropped through the DbExplorer or DbTree
 - Loading of old profiles didn't work if some (or all) were still using the "Default Group"
 - When using real tabs in the editor, the position of the following characters wasn't calculated correctly
 - The statements in the script from "Show script" when using the DROP dialog in the DbExplorer were not terminated with a semicolon.
 - Table names that contain a dot (e.g. "some.table") were not handled correctly when generating queries for them.
 - For PostgreSQL, retrieving event triggers did not work any more.


To generate a diff of this commit:
cvs rdiff -u -r1.8 -r1.9 pkgsrc/databases/sql-workbench/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/sql-workbench/PLIST
cvs rdiff -u -r1.9 -r1.10 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.8 pkgsrc/databases/sql-workbench/Makefile:1.9
--- pkgsrc/databases/sql-workbench/Makefile:1.8 Thu Sep 30 15:50:33 2021
+++ pkgsrc/databases/sql-workbench/Makefile     Sun Dec 31 15:27:26 2023
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.8 2021/09/30 15:50:33 abs Exp $
+# $NetBSD: Makefile,v 1.9 2023/12/31 15:27:26 abs Exp $
 
-DISTNAME=      Workbench-Build127
-PKGNAME=       sql-workbench-127
+DISTNAME=      Workbench-Build130
+PKGNAME=       sql-workbench-130
 CATEGORIES=    databases
 MASTER_SITES=  http://www.sql-workbench.net/
 EXTRACT_SUFX=  .zip
@@ -21,7 +21,7 @@ NO_SRC_ON_FTP=                ${RESTRICTED}
 EXTRACT_DIR=   ${WRKSRC}
 
 USE_JAVA=              run
-USE_JAVA2=             8
+USE_JAVA2=             11
 USE_TOOLS+=            pax
 
 INSTALLATION_DIRS=     bin share/${PKGBASE}

Index: pkgsrc/databases/sql-workbench/PLIST
diff -u pkgsrc/databases/sql-workbench/PLIST:1.5 pkgsrc/databases/sql-workbench/PLIST:1.6
--- pkgsrc/databases/sql-workbench/PLIST:1.5    Thu Sep 30 15:50:33 2021
+++ pkgsrc/databases/sql-workbench/PLIST        Sun Dec 31 15:27:26 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2021/09/30 15:50:33 abs Exp $
+@comment $NetBSD: PLIST,v 1.6 2023/12/31 15:27:26 abs Exp $
 bin/sqlworkbench
 share/sql-workbench/LICENSE
 share/sql-workbench/SQLWorkbench.cfg.sample
@@ -9,6 +9,7 @@ share/sql-workbench/download_jre.ps1
 share/sql-workbench/download_jre.sh
 share/sql-workbench/ext/README_EXT
 share/sql-workbench/ext/flatlaf.jar
+share/sql-workbench/ext/jsch.jar
 share/sql-workbench/log4j-sample.xml
 share/sql-workbench/manual/SQLWorkbench-Manual.pdf
 share/sql-workbench/manual/annotations.html

Index: pkgsrc/databases/sql-workbench/distinfo
diff -u pkgsrc/databases/sql-workbench/distinfo:1.9 pkgsrc/databases/sql-workbench/distinfo:1.10
--- pkgsrc/databases/sql-workbench/distinfo:1.9 Tue Oct 26 10:10:05 2021
+++ pkgsrc/databases/sql-workbench/distinfo     Sun Dec 31 15:27:26 2023
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.9 2021/10/26 10:10:05 nia Exp $
+$NetBSD: distinfo,v 1.10 2023/12/31 15:27:26 abs Exp $
 
-BLAKE2s (Workbench-Build127.zip) = 148e11004b29a51f616f4ee5bccf4a15ac51e2edb68cf067b4b576c998c7ea63
-SHA512 (Workbench-Build127.zip) = 4d675136767d8d347ced22214fab036fb24c6e6c844bdef07c3290f6890c8f96a0555ae7dd00df639bc5832deb79ac79329fbc062f0f93f2a9b89d0a12c61156
-Size (Workbench-Build127.zip) = 8275806 bytes
+BLAKE2s (Workbench-Build130.zip) = aa560c7f5f6b6180d646ccf23dae0554c7c29f4eb5606db1f9303ea5719e9137
+SHA512 (Workbench-Build130.zip) = 580f7b0ac15a2388bb2e039de756e82cdb324d6c4acbc0402fd298607c60307bdb7a711ddff09311e473289fe8016a83a1ec485e05f5408dd7fe46e59c0b90e5
+Size (Workbench-Build130.zip) = 9563223 bytes