Updated databases/sql-workbench to 124 Build 124 (2018-08-20) Enhancements - WbExport can now write .xlsm files ("XLSX with Macros") - In the auto-completion popup for columns, the column's data type is now displayed - For PostgreSQL, row-level policies created for a table are now shown in the generated DDL - Added auto-completion support for Oracle's SHOW command - Added auto-completion support for PostgreSQL's SHOW, SET and RESET commands - Added support for new features in PostgreSQL 11 - Improved support for Greenplum - It's now possible to lock a result not only through the GUI, but also through the annotation WbKeepResult - It's now possible to define global SSH hosts that can be selected for each connection profile - It's now possible to display the column's table in a query result if the JDBC driver provides that information - When importing Excel sheets it's now possible to disable the automatic re-calculation of formulas - It's now possible to use multiple profile files by specifying a directory through the -profileStorage parameter - It's now possible to define environment variables for the programs started through WbSysExec - For PostgreSQL, user defined collations are now shown in the DbExplorer and DbTree - For PostgreSQL, Oracle and SQL Server time zone information can now be displayed for columns that contain that information (TIMESTAMP WITH TIME ZONE or datetimeoffset) - For DB2 for I, variables are now shown in the DbExplorer and DbTree - For DB2 for I, the character set of columns (CCSID) is now shown in the generated DDL statements. - It's now possible to use the schema filter expressions from the connection profile as parameters to the JDBC API call to speed up schema retrieval. - It's now possible to define more flexible filters for the DbExplorer's table list Bug fixes - For Postgres, WbCopy was not able to write values into TIMESTAMPTZ column. - For Oracle versions 10 or lower, the source of materialized views was no longer displayed. - For Oracle, when displaying the procedures in the DbExplorer and choosing "*" for the schema, the procedure owner was no longer shown in the list of procedures. - For SQL Server, the DROP statement generated for sequences was not correct. - If the option "Always allow "Execute selected" was disabled, directly after opening the window "Execute Selected" would still run all statements. - Running a macro by using the macro's name did not work if there was a comment preceding the macro's name in the editor. - When a result was locked ("Keep result") subsequent new result tabs were not always activated automatically. - When connecting to a profile with a corrupted workspace, the main window was not usable any more. - Additional libraries were no longer loaded when starting SQL Workbench/J using "java -jar sqlworkbench.jar" - When multiple columns where selected in a result, the "Filter by value" was applied using only the first selected column. - The -commitEvery parameter for WbImport and WbCopy did not work - When using WbConnect with nested WbIncludes, the connection would not be closed if an error occurred - When using "Check foreign keys" in the dialog to drop multiple objects, non-table objects were removed. - "Save As" did not use the profile's default directory - The default directory of the profile was not used when opening files - Implemented a workaround for SQLite, so that invalid DATE values could be read from columns defined as DATE. - When using "quoteCharEscaping=duplicate" with WbImport, empty strings or strings that only contained a single (escaped) quote character were not imported correctly. - In case of an error, the cursor in the editor was no longer moved to the error position. - For PostgreSQL, the generated DDL for foreign servers was incorrect - For Oracle, NUMBER columns without precision were exported with a decimal separator to Excel files. - Showing rowcounts in the DbExplorer did not work. - For Oracle, the result of functions returning a refcursor was not displayed correctly. Build 123 (2017-09-25) Enhancements - It's now possible to jump between statements in the editor. - For Postgres global objects are now shown in the DbTree and DbExplorer - WbExport now supports specifying a format pattern when exporting numbers to text files. - Expandable macros now also support placeholders for the selected text and statement. - WbDataDiff can now optionally create INSERT statements for tables that do not exist in the target database. - Added support for new Postgres 10 features (partitioning, identity columns) - For Firebird, DOMAINs are now included in the dependency display - WbImport now also supports the -skipTargetCheck option - It's now possible to define a default directory for a connection profile that is used e.g. for WbInclude or WbExport - The default encoding used for files in the editor can now be changed in the options dialog - WbImport and WbExport now support the -locale parameter to define the locale used for parsing and formatting dates and timestamps - For Postgres, the type of an index (btree, brin, gist, gin, ...) is now shown in the DbExplorer - For Postgres, TYPEs are now included in the dependency display - The formatting of numbers can now be controlled in more detail - For SQL Server and MySQL the USE command now supports code-completion - Generated DDL scripts now only contain commit statements if the current connection is not set to auto-commit (and the DBMS supports transactional DDL) - For Postgres, a tablespace other then pg_default will now be displayed in the generated source for tables and indexes Bug fixes - SQL Workbench could not be started with Java 9 - BLOB and NVARCHAR literals were not handled correctly when formatting a statement - Replacing variables inside other variables did not always work - WbSchemaDiff did not handle multiple indexes on the same column list correctly - It was no longer possible to connect to a SAP DB - Navigating foreign keys from the result set did not work for non-numeric data types - Made saving of Workspaces more robust against errors. - For SQL Server, if integratedSecurity=true was used, SQL Workbench still prompted for a password - Made the SQL formatter more robust against useless parentheses around sub-selects - When an expandable macros was invoked through the menu, the cursor position was not correct when using ${c} - It was not possible to change the statement/query timeout in GUI mode using SET TIMEOUT - Detaching a result was longer possible in build 122.2 - The option "Remove comments" was not working with databases are using non-standard characters to quote identifiers - For Oracle, the display format for timestamps was not used for "timestamp with time zone" values - SSH tunneling did not work with Oracle when using a service name in the JDBC URL - If the MacroPopup was open and a profile with a different macro file was loaded, the macros in the popup weren't re-loaded - Fixed the handling of long column names in the dialog to select columns - WbCopy did not work if there was another object (e.g. a sequence or view) in the source database with the same name as the table specified with -sourceTable - The dialog to select columns for copying them to the clipboard did not display all options on Mac OSX. - Changing between connection profiles that had a non-standard macro file and profiles using the standard macro file could lead to a situation where the standard macros were no longer available. - "Put SELECT into Clipboard" did not work any longer in the DbTree or DbExplorer - Using -sourceDir to import multiple files into a single table did not work if -fileColumns was not specified - WbDataDiff failed when using -includeDeletes=true and the comparison was done between two DBMS that stored object names differently (e.g. UPPER vs. lowercase) - The parameter -varFile did not work anymore - For Oracle, the "realplan" option for autotrace did not work for queries starting with a common table expression (WITH)diff -r1.4 -r1.5 pkgsrc/databases/sql-workbench/Makefile
(abs)
@@ -1,31 +1,31 @@ | @@ -1,31 +1,31 @@ | |||
1 | # $NetBSD: Makefile,v 1.4 2017/06/12 12:07:39 abs Exp $ | 1 | # $NetBSD: Makefile,v 1.5 2018/12/11 15:29:31 abs Exp $ | |
2 | 2 | |||
3 | DISTNAME= Workbench-Build122 | 3 | DISTNAME= Workbench-Build124 | |
4 | PKGNAME= sql-workbench-122 | 4 | PKGNAME= sql-workbench-124 | |
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 | 12 | |||
13 | EXTRACT_DIR= ${WRKSRC} | 13 | EXTRACT_DIR= ${WRKSRC} | |
14 | 14 | |||
15 | USE_JAVA= run | 15 | USE_JAVA= run | |
16 | USE_JAVA2= 8 | 16 | USE_JAVA2= 8 | |
17 | PKG_JVMS_ACCEPTED= oracle-jdk8 openjdk8 | 17 | PKG_JVMS_ACCEPTED= oracle-jdk8 openjdk8 | |
18 | USE_TOOLS+= pax | 18 | USE_TOOLS+= pax | |
19 | 19 | |||
20 | INSTALLATION_DIRS= bin share/${PKGBASE} | 20 | INSTALLATION_DIRS= bin share/${PKGBASE} | |
21 | 21 | |||
22 | pre-extract: | 22 | pre-extract: | |
23 | mkdir -p ${WRKSRC} | 23 | mkdir -p ${WRKSRC} | |
24 | 24 | |||
25 | do-build: | 25 | do-build: | |
26 | 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 | 26 | 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 | |
27 | 27 | |||
28 | do-install: | 28 | do-install: | |
29 | cd ${WRKSRC} && pax -rwpm . ${DESTDIR}${PREFIX}/share/${PKGBASE} | 29 | cd ${WRKSRC} && pax -rwpm . ${DESTDIR}${PREFIX}/share/${PKGBASE} | |
30 | ${INSTALL_SCRIPT} ${WRKDIR}/sqlworkbench.sh ${DESTDIR}${PREFIX}/bin/sqlworkbench | 30 | ${INSTALL_SCRIPT} ${WRKDIR}/sqlworkbench.sh ${DESTDIR}${PREFIX}/bin/sqlworkbench | |
31 | 31 |
@@ -1,18 +1,17 @@ | @@ -1,18 +1,17 @@ | |||
1 | @comment $NetBSD: PLIST,v 1.3 2016/08/23 14:49:23 abs Exp $ | 1 | @comment $NetBSD: PLIST,v 1.4 2018/12/11 15:29:31 abs Exp $ | |
2 | bin/sqlworkbench | 2 | bin/sqlworkbench | |
3 | share/sql-workbench/LICENSE | 3 | share/sql-workbench/LICENSE | |
4 | share/sql-workbench/SQLWorkbench-Manual.pdf | 4 | share/sql-workbench/SQLWorkbench-Manual.pdf | |
5 | share/sql-workbench/SQLWorkbench.desktop | |||
6 | share/sql-workbench/SQLWorkbench.exe | 5 | share/sql-workbench/SQLWorkbench.exe | |
7 | share/sql-workbench/SQLWorkbench.vbs | 6 | share/sql-workbench/SQLWorkbench.vbs | |
8 | share/sql-workbench/SQLWorkbench64.exe | 7 | share/sql-workbench/SQLWorkbench64.exe | |
9 | share/sql-workbench/history.html | 8 | share/sql-workbench/history.html | |
10 | share/sql-workbench/log4j-sample.xml | 9 | share/sql-workbench/log4j-sample.xml | |
11 | share/sql-workbench/manual/annotations.html | 10 | share/sql-workbench/manual/annotations.html | |
12 | share/sql-workbench/manual/command-copy.html | 11 | share/sql-workbench/manual/command-copy.html | |
13 | share/sql-workbench/manual/command-export.html | 12 | share/sql-workbench/manual/command-export.html | |
14 | share/sql-workbench/manual/command-import.html | 13 | share/sql-workbench/manual/command-import.html | |
15 | share/sql-workbench/manual/commandline.html | 14 | share/sql-workbench/manual/commandline.html | |
16 | share/sql-workbench/manual/compare-commands.html | 15 | share/sql-workbench/manual/compare-commands.html | |
17 | share/sql-workbench/manual/console-mode.html | 16 | share/sql-workbench/manual/console-mode.html | |
18 | share/sql-workbench/manual/data-pumper.html | 17 | share/sql-workbench/manual/data-pumper.html | |
@@ -60,26 +59,27 @@ share/sql-workbench/manual/using.html | @@ -60,26 +59,27 @@ share/sql-workbench/manual/using.html | |||
60 | share/sql-workbench/manual/wb-commands.html | 59 | share/sql-workbench/manual/wb-commands.html | |
61 | share/sql-workbench/manual/wb-grep-commands.html | 60 | share/sql-workbench/manual/wb-grep-commands.html | |
62 | share/sql-workbench/manual/wb-info-commands.html | 61 | share/sql-workbench/manual/wb-info-commands.html | |
63 | share/sql-workbench/manual/wb-macro-commands.html | 62 | share/sql-workbench/manual/wb-macro-commands.html | |
64 | share/sql-workbench/manual/wb-var-commands.html | 63 | share/sql-workbench/manual/wb-var-commands.html | |
65 | share/sql-workbench/manual/workbench-manual-single.html | 64 | share/sql-workbench/manual/workbench-manual-single.html | |
66 | share/sql-workbench/manual/workbench-manual.html | 65 | share/sql-workbench/manual/workbench-manual.html | |
67 | share/sql-workbench/manual/workspace-usage.html | 66 | share/sql-workbench/manual/workspace-usage.html | |
68 | share/sql-workbench/sqlwbconsole.cmd | 67 | share/sql-workbench/sqlwbconsole.cmd | |
69 | share/sql-workbench/sqlwbconsole.exe | 68 | share/sql-workbench/sqlwbconsole.exe | |
70 | share/sql-workbench/sqlwbconsole.sh | 69 | share/sql-workbench/sqlwbconsole.sh | |
71 | share/sql-workbench/sqlwbconsole64.exe | 70 | share/sql-workbench/sqlwbconsole64.exe | |
72 | share/sql-workbench/sqlworkbench.cmd | 71 | share/sql-workbench/sqlworkbench.cmd | |
72 | share/sql-workbench/sqlworkbench.desktop | |||
73 | share/sql-workbench/sqlworkbench.jar | 73 | share/sql-workbench/sqlworkbench.jar | |
74 | share/sql-workbench/sqlworkbench.sh | 74 | share/sql-workbench/sqlworkbench.sh | |
75 | share/sql-workbench/workbench32.png | 75 | share/sql-workbench/workbench32.png | |
76 | share/sql-workbench/xslt/jdbctypes2oracle.xslt | 76 | share/sql-workbench/xslt/jdbctypes2oracle.xslt | |
77 | share/sql-workbench/xslt/liquibase_common.xslt | 77 | share/sql-workbench/xslt/liquibase_common.xslt | |
78 | share/sql-workbench/xslt/wbdiff2derby.xslt | 78 | share/sql-workbench/xslt/wbdiff2derby.xslt | |
79 | share/sql-workbench/xslt/wbdiff2html.xslt | 79 | share/sql-workbench/xslt/wbdiff2html.xslt | |
80 | share/sql-workbench/xslt/wbdiff2liquibase.xslt | 80 | share/sql-workbench/xslt/wbdiff2liquibase.xslt | |
81 | share/sql-workbench/xslt/wbdiff2mssql.xslt | 81 | share/sql-workbench/xslt/wbdiff2mssql.xslt | |
82 | share/sql-workbench/xslt/wbdiff2oracle.xslt | 82 | share/sql-workbench/xslt/wbdiff2oracle.xslt | |
83 | share/sql-workbench/xslt/wbdiff2pg.xslt | 83 | share/sql-workbench/xslt/wbdiff2pg.xslt | |
84 | share/sql-workbench/xslt/wbdiff2simple_html.xslt | 84 | share/sql-workbench/xslt/wbdiff2simple_html.xslt | |
85 | share/sql-workbench/xslt/wbexport2dbunit.xslt | 85 | share/sql-workbench/xslt/wbexport2dbunit.xslt |
@@ -1,6 +1,6 @@ | @@ -1,6 +1,6 @@ | |||
1 | $NetBSD: distinfo,v 1.5 2017/06/12 12:07:39 abs Exp $ | 1 | $NetBSD: distinfo,v 1.6 2018/12/11 15:29:31 abs Exp $ | |
2 | 2 | |||
3 | SHA1 (Workbench-Build122.zip) = c9cd1a2230997855be3ab7d7b5a422c5b61180fa | 3 | SHA1 (Workbench-Build124.zip) = e0f8eb4625e8c11de0b3c4440a1c64da98dc78aa | |
4 | RMD160 (Workbench-Build122.zip) = d9063222d487db1a94e8ea1681fa2723cace0295 | 4 | RMD160 (Workbench-Build124.zip) = 5780052b1ba96119320270b57a897da39fad7de3 | |
5 | SHA512 (Workbench-Build122.zip) = 97a7c5628c0f18ffcdbd624d932f25e28db1901cb6dcd1d6468d8311089777fe64e157fab44fae64b14fa98c503210471fe60b93348c5977f1a61ea653bf6d2e | 5 | SHA512 (Workbench-Build124.zip) = 82dc66199ad8f13fde96a6b2126ac54bd8108af8f15212daf10d2359fff1400607c557caca1a917ae93e3a5ab66791a0f6f57fa21f19814958d64822acb84026 | |
6 | Size (Workbench-Build122.zip) = 6569442 bytes | 6 | Size (Workbench-Build124.zip) = 6868177 bytes |