Sun Dec 31 15:27:26 2023 UTC (159d)
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.
(abs)
diff -r1.8 -r1.9 pkgsrc/databases/sql-workbench/Makefile
diff -r1.5 -r1.6 pkgsrc/databases/sql-workbench/PLIST
diff -r1.9 -r1.10 pkgsrc/databases/sql-workbench/distinfo
--- pkgsrc/databases/sql-workbench/Makefile 2021/09/30 15:50:33 1.8
+++ pkgsrc/databases/sql-workbench/Makefile 2023/12/31 15:27:26 1.9
| @@ -1,37 +1,37 @@ | | | @@ -1,37 +1,37 @@ |
1 | # $NetBSD: Makefile,v 1.8 2021/09/30 15:50:33 abs Exp $ | | 1 | # $NetBSD: Makefile,v 1.9 2023/12/31 15:27:26 abs Exp $ |
2 | | | 2 | |
3 | DISTNAME= Workbench-Build127 | | 3 | DISTNAME= Workbench-Build130 |
4 | PKGNAME= sql-workbench-127 | | 4 | PKGNAME= sql-workbench-130 |
5 | CATEGORIES= databases | | 5 | CATEGORIES= databases |
6 | MASTER_SITES= http://www.sql-workbench.net/ | | 6 | MASTER_SITES= http://www.sql-workbench.net/ |
7 | EXTRACT_SUFX= .zip | | 7 | EXTRACT_SUFX= .zip |
8 | | | 8 | |
9 | MAINTAINER= asau@inbox.ru | | 9 | MAINTAINER= asau@inbox.ru |
10 | HOMEPAGE= http://www.sql-workbench.net/ | | 10 | HOMEPAGE= http://www.sql-workbench.net/ |
11 | COMMENT= JDBC-based cross-platform SQL query tool | | 11 | COMMENT= JDBC-based cross-platform SQL query tool |
12 | # Apache, except not granted to certain entities | | 12 | # Apache, except not granted to certain entities |
13 | LICENSE= generic-nonlicense | | 13 | LICENSE= generic-nonlicense |
14 | | | 14 | |
15 | RESTRICTED= Some entities are not permitted to use/download. | | 15 | RESTRICTED= Some entities are not permitted to use/download. |
16 | NO_BIN_ON_CDROM= ${RESTRICTED} | | 16 | NO_BIN_ON_CDROM= ${RESTRICTED} |
17 | NO_BIN_ON_FTP= ${RESTRICTED} | | 17 | NO_BIN_ON_FTP= ${RESTRICTED} |
18 | NO_SRC_ON_CDROM= ${RESTRICTED} | | 18 | NO_SRC_ON_CDROM= ${RESTRICTED} |
19 | NO_SRC_ON_FTP= ${RESTRICTED} | | 19 | NO_SRC_ON_FTP= ${RESTRICTED} |
20 | | | 20 | |
21 | EXTRACT_DIR= ${WRKSRC} | | 21 | EXTRACT_DIR= ${WRKSRC} |
22 | | | 22 | |
23 | USE_JAVA= run | | 23 | USE_JAVA= run |
24 | USE_JAVA2= 8 | | 24 | USE_JAVA2= 11 |
25 | USE_TOOLS+= pax | | 25 | USE_TOOLS+= pax |
26 | | | 26 | |
27 | INSTALLATION_DIRS= bin share/${PKGBASE} | | 27 | INSTALLATION_DIRS= bin share/${PKGBASE} |
28 | CHECK_INTERPRETER_SKIP= share/sql-workbench/sqlwbconsole.sh \ | | 28 | CHECK_INTERPRETER_SKIP= share/sql-workbench/sqlwbconsole.sh \ |
29 | share/sql-workbench/sqlworkbench.sh \ | | 29 | share/sql-workbench/sqlworkbench.sh \ |
30 | share/sql-workbench/download_jre.sh | | 30 | share/sql-workbench/download_jre.sh |
31 | | | 31 | |
32 | pre-extract: | | 32 | pre-extract: |
33 | mkdir -p ${WRKSRC} | | 33 | mkdir -p ${WRKSRC} |
34 | | | 34 | |
35 | do-build: | | 35 | do-build: |
36 | printf "#!/bin/sh\n${PKG_JAVA_HOME}/bin/java -Dvisualvm.display.name=SQLWorkbench -Xmx512m -jar ${PREFIX}/share/${PKGBASE}/sqlworkbench.jar \$${1:+\"\$$@\"}\n" > ${WRKDIR}/sqlworkbench.sh | | 36 | printf "#!/bin/sh\n${PKG_JAVA_HOME}/bin/java -Dvisualvm.display.name=SQLWorkbench -Xmx512m -jar ${PREFIX}/share/${PKGBASE}/sqlworkbench.jar \$${1:+\"\$$@\"}\n" > ${WRKDIR}/sqlworkbench.sh |
37 | | | 37 | |
--- pkgsrc/databases/sql-workbench/PLIST 2021/09/30 15:50:33 1.5
+++ pkgsrc/databases/sql-workbench/PLIST 2023/12/31 15:27:26 1.6
| @@ -1,24 +1,25 @@ | | | @@ -1,24 +1,25 @@ |
1 | @comment $NetBSD: PLIST,v 1.5 2021/09/30 15:50:33 abs Exp $ | | 1 | @comment $NetBSD: PLIST,v 1.6 2023/12/31 15:27:26 abs Exp $ |
2 | bin/sqlworkbench | | 2 | bin/sqlworkbench |
3 | share/sql-workbench/LICENSE | | 3 | share/sql-workbench/LICENSE |
4 | share/sql-workbench/SQLWorkbench.cfg.sample | | 4 | share/sql-workbench/SQLWorkbench.cfg.sample |
5 | share/sql-workbench/SQLWorkbench.exe | | 5 | share/sql-workbench/SQLWorkbench.exe |
6 | share/sql-workbench/SQLWorkbench64.exe | | 6 | share/sql-workbench/SQLWorkbench64.exe |
7 | share/sql-workbench/download_jre.cmd | | 7 | share/sql-workbench/download_jre.cmd |
8 | share/sql-workbench/download_jre.ps1 | | 8 | share/sql-workbench/download_jre.ps1 |
9 | share/sql-workbench/download_jre.sh | | 9 | share/sql-workbench/download_jre.sh |
10 | share/sql-workbench/ext/README_EXT | | 10 | share/sql-workbench/ext/README_EXT |
11 | share/sql-workbench/ext/flatlaf.jar | | 11 | share/sql-workbench/ext/flatlaf.jar |
| | | 12 | share/sql-workbench/ext/jsch.jar |
12 | share/sql-workbench/log4j-sample.xml | | 13 | share/sql-workbench/log4j-sample.xml |
13 | share/sql-workbench/manual/SQLWorkbench-Manual.pdf | | 14 | share/sql-workbench/manual/SQLWorkbench-Manual.pdf |
14 | share/sql-workbench/manual/annotations.html | | 15 | share/sql-workbench/manual/annotations.html |
15 | share/sql-workbench/manual/command-copy.html | | 16 | share/sql-workbench/manual/command-copy.html |
16 | share/sql-workbench/manual/command-export.html | | 17 | share/sql-workbench/manual/command-export.html |
17 | share/sql-workbench/manual/command-import.html | | 18 | share/sql-workbench/manual/command-import.html |
18 | share/sql-workbench/manual/commandline.html | | 19 | share/sql-workbench/manual/commandline.html |
19 | share/sql-workbench/manual/compare-commands.html | | 20 | share/sql-workbench/manual/compare-commands.html |
20 | share/sql-workbench/manual/console-mode.html | | 21 | share/sql-workbench/manual/console-mode.html |
21 | share/sql-workbench/manual/data-pumper.html | | 22 | share/sql-workbench/manual/data-pumper.html |
22 | share/sql-workbench/manual/db-tree.html | | 23 | share/sql-workbench/manual/db-tree.html |
23 | share/sql-workbench/manual/dbexplorer.html | | 24 | share/sql-workbench/manual/dbexplorer.html |
24 | share/sql-workbench/manual/dbms-problems.html | | 25 | share/sql-workbench/manual/dbms-problems.html |
--- pkgsrc/databases/sql-workbench/distinfo 2021/10/26 10:10:05 1.9
+++ pkgsrc/databases/sql-workbench/distinfo 2023/12/31 15:27:26 1.10
| @@ -1,5 +1,5 @@ | | | @@ -1,5 +1,5 @@ |
1 | $NetBSD: distinfo,v 1.9 2021/10/26 10:10:05 nia Exp $ | | 1 | $NetBSD: distinfo,v 1.10 2023/12/31 15:27:26 abs Exp $ |
2 | | | 2 | |
3 | BLAKE2s (Workbench-Build127.zip) = 148e11004b29a51f616f4ee5bccf4a15ac51e2edb68cf067b4b576c998c7ea63 | | 3 | BLAKE2s (Workbench-Build130.zip) = aa560c7f5f6b6180d646ccf23dae0554c7c29f4eb5606db1f9303ea5719e9137 |
4 | SHA512 (Workbench-Build127.zip) = 4d675136767d8d347ced22214fab036fb24c6e6c844bdef07c3290f6890c8f96a0555ae7dd00df639bc5832deb79ac79329fbc062f0f93f2a9b89d0a12c61156 | | 4 | SHA512 (Workbench-Build130.zip) = 580f7b0ac15a2388bb2e039de756e82cdb324d6c4acbc0402fd298607c60307bdb7a711ddff09311e473289fe8016a83a1ec485e05f5408dd7fe46e59c0b90e5 |
5 | Size (Workbench-Build127.zip) = 8275806 bytes | | 5 | Size (Workbench-Build130.zip) = 9563223 bytes |