Updated databases/sql-workbench to 127 Build 127 (2020-08-22) Bug fixes - It was no longer possible to run GRANT or REVOKE statements. Build 126 (2020-08-09) Enhancements - WbExport will now abort if a text export is started without a quote character but a quote character would be needed. - For PostgreSQL, subscriptions and publications for logical replication are now shown in the DbTree and DbExplorer. - For PostgreSQL, the attribute of IDENTITY REPLICA is now shown in the generated DDL. - "Make uppercase" and "Make lowercase" now also work if no text is selected. In that case, (only) the character at the cursor is changed - Passwords can now securely be encrypted using a master password. The old password encryption is no longer supported. - The properties base profile storage (wb-profiles.properties) is now the default. The old XML format is still supported. - WbVarDef now supports conditional execution. - WbCopy now supports views as the source by using -includeViews=true. - The result panel is now automatically displayed if it was minimized before running a statement. - It's now possible to configure italic and bold for syntax highlighting - For SQL Server, partitioning information about a table is now included in the generated DDL - WbImport can now import all sheets of a spreadsheet into the same table when -sheetName=* is specified together with -table - The annotation @WbResultAsText can now be used to turn the "text mode" display on for multiple statements - For PostgreSQL, the "match mode" of foreign key constraints is now displayed and included in the generated DDL - A new Windows launcher is available that removes the need for a separate 64 and 32 bit executables and can optionally download a JRE - It's now possible to optionally open the saved file when using "Save As" - It's now possible to use a special variable in WbImport to assign the input file's line number to a column. - It's now possible to cycle through the result tabs using a keyboard shortcut. - When exporting a single table from the table list (Database Explorer or DbTree) it's now possible to select the columns to export. - It's now possible to display results in GUI mode as "text" in the messages area. - It's now possible to define a SQL expression to be used in the INSERT statement that WbImport uses to apply SQL functions on the input value. - Selecting foreign key values is now also supported for DELETE statements. - The list of shortcut keys can now be exported (with the usual "Save As" formats) - Invoking code completion in the WHERE clause without a column now displays all columns of all used tables of the query - For MySQL and MariaDB versions that support them, check constraints are now shown in the generated DDL - Recently opened files are now accessible through the "File" menu. - For PostgreSQL, default values on columns of views are now shown in the generated DDL - For HSQLDB 2.5, the new options for temporal tables are now shown in the generated DDL - Added new command WbSetSchema to change the current schema using the driver's JDBC API - For PostgreSQL 12, the new computed columns are now shown in the generated DDL - The tooltip of a column header now always includes the table name if available Bug fixes - For Redshift, tables sources were not always displayed - When using WbImport with mode=upsert and a table that has a multi-column primary key, the wrong MERGE statement was generated for SQL Server, HSQLDB and DB2 - When exporting to ODS, the generated files could not be opened with Microsoft Excel. - Using nested WbIncludes failed with an exception - When invoking code-completion in the ON part of a JOIN, not tables where shown. - When selecting a global SSH configuration for a connection profile, it was no longer possible to revert to a "non-global" configuration - When specifying a SSH Tunnel without a password and no keyfile, SQL Workbench did not prompt for the password - For WbCopy, when using -createTarget=true together with -targetSchema the new table was created in the wrong schema - Fixed an issue when loading the SQL Server JDBC driver with certain versions of OpenJDK - For SQL Server, when including the CREATE TABLE statement in the output when exporting data as SQL the export failed - WbDataDiff did not work properly if the key columns contained NULL values. - When exporting or saving data, it was not possible to enter the filename manually into the dialog. - Month names were case sensitive when using -dateFormat or -timestampFormat with WbImport - For Oracle 18c and later, index information wasn't displayed correctly. - For Oracle 18c and later, DDL for identity columns wasn't generated correctly. - For Oracle, the generated IGNORE_DUP_KEY hint was incorrect if the order of the PK columns was different to the column order of the table. - Assigning multiple variables with WbVarDef was not possible if -variable was used. - For Redshift, finding tables on the search path was no longer working. - For PostgreSQL, using the JDBC driver 42.2.11, the value for columns defined as "timestamp with time zone" could not be retrieved any longer. - The cursor position wasn't calculated correctly, if real tabs where used in the editor (regression from 125.6) - Sorting columns defined as arrays in the result did not work properly. - The new Windows launcher (introduced in 125.5) did not work if run from a directory with spaces in the name - Fixed some problems with the cursor position in the editor with High-DPI displays (on Windows) - For PostgreSQL, the DDL for partitioned tables with sub-partitions was not generated correctly - Using WbImport with temp tables as the target did not work with PostgreSQL and SQL Server - When using UCanAccess certain types of "linked columns" are now displayed correctly. - For DB2 on AS/400 the CSID attribute was also generated for data types where it wasn't relevant. - Individual statements were not detected correctly in the editor if the text started with a semicolon. - "Create SQL List" did not work properly if only a part of the first or last line was selected. - For PostgreSQL, the dependency display of trigger functions wasn't working any more. - When using Page Down when the editor text was shorter than the number of lines, the display was corrupted. - When closing the macro dialog while macros were filtered, only the visible macros were saved. - For PostgreSQL, check constraints and default values were no longer displayed correctly in the generated DDL - For XLSX exports, using -infoSheet did not work any longer - When using -endRow with WbImport, the following rows weren't exported, but the input file was still read until the end - Filtering the list of macros did no longer work correctly. - For SQLite, all values are now retrieved as strings to workaround problems with the lack of explicit data types. - Common table expressions containing DML are now correctly identified when the "Read Only" option is selected in the connection profile. - The XML file generated by WbSchemaDiff was incorrect when multiple views need to be dropped. - The SQL formatter removed trailing semicolons if only a single statement was formatted. - Fractional seconds were not correcly formatted in timestamp literals in generated SQL statements. - When editing a result with columns from multiple tables where the columns were not fully qualified, an exception occurred rather than a usable error message. - Conditional execution of Workbench commands using -ifDefined and -ifNotDefined behaved the same as -ifEmpty and -ifNotEmpty - For Postgres, infinity values for timestamp with time zone could not be read from the database. - If the JDBC driver returned LocalDateTime or LocalDate values, those weren't formatted properly in SQL statements or text files. Build 125 (2019-05-08) Enhancements - All additional libraries are now expected in the directory "ext". - In the DbExplorer, using "Show Rowcounts", now displays the row counts as a new column in the table list. - WbDataDiff now also supports -clobAsFile when generating SQL statements - For WbExport and WbDataDiff -clobFileThreshold has been added - For MariaDB 10.3, sequences are now displayed in the DbExplorer - The "Manage Macros" dialog now also supports filtering of the macros. - For Oracle, the generated DDL for tables now contains the definitions of extended column statistics. - It's now possible to control the behaviour of WbDefineVar when NULL values are retrieved through a SQL query - It's now possible to specify a message with WbEcho that is displayed even if verbose logging was turned off (e.g. using -verbose=false for WbInclude) - For WbExport and WbImport, it's now possible to define the values for -quoteChar and -delimiter using unicode escape notation (e.g. \0008) - WbDefineVar now supports the -silent option so suppress the details about the defined variable - For conditional execution of some SQL Workbench/J commands, checking for the (non) existence of files or tables is now supported - For Postgres, comments on foreign key constraints are now displayed in the DbExplorer and the generated DDL source - Confirmation to close "Other tabs" can now be configured separately. Bug fixes - For SQL Server, DateTime values were not displayed correctly - For Oracle the source of materialized views using ON PREBUILT TABLE was incorrect. - Relative file names were treated differently by the SQL Workbench commands and the ifFileExists check. - For MySQL, the source of triggers wasn't displayed. - Copy to clipboard did not use the format string for decimal values - For Oracle, using -mode=upsert with CLOB columns did not work for WbImport - For some JDBC drivers, the console did not display the column's alias, but the real column name in a result - For Postgres, nesting dollar quoted strings did not work. - When retrieving XML columns using a driver that supports the JDBC API getXML() NULL values would result in an error. - For Postgres, the generated source for an extension in the DbExplorer was not correct. - The detection of the DB2 version was no long working correctly - Numbers that can't be stored in Excel's file format are now exported as strings rather than numbers - For Oracle, certain timestamp values were incorrectly exported. - For Oracle 12, statements using "WITH FUNCTION" or "/*+ WITH_PLSQL */" to create inline PL/SQL functions could not be executed. - WbCall did not display values for OUT parameters for all data types. - For Oracle, the status of foreign keys (enabled, validated) was no longer displayed in the DbExplorer. - For PostgreSQL, retrieving the policies for row level security was not working for versions prior to 10 any more. - When using -profileStorage wih a filename without a path, files located in the config directory where not found - Generating a SQL script using WbDataDiff on tables with timestamptz columns in Postgres did not workdiff -r1.7 -r1.8 pkgsrc/databases/sql-workbench/Makefile
(abs)
@@ -1,41 +1,43 @@ | @@ -1,41 +1,43 @@ | |||
1 | # $NetBSD: Makefile,v 1.7 2019/11/02 15:38:11 rillig Exp $ | 1 | # $NetBSD: Makefile,v 1.8 2021/09/30 15:50:33 abs Exp $ | |
2 | 2 | |||
3 | DISTNAME= Workbench-Build124 | 3 | DISTNAME= Workbench-Build127 | |
4 | PKGNAME= sql-workbench-124 | 4 | PKGNAME= sql-workbench-127 | |
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 | ||||
13 | # Apache, except not granted to certain entities | 12 | # Apache, except not granted to certain entities | |
14 | LICENSE= generic-nonlicense | 13 | LICENSE= generic-nonlicense | |
14 | ||||
15 | RESTRICTED= Some entities are not permitted to use/download. | 15 | RESTRICTED= Some entities are not permitted to use/download. | |
16 | NO_SRC_ON_FTP= ${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_BIN_ON_CDROM= ${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= 8 | |
25 | PKG_JVMS_ACCEPTED= oracle-jdk8 openjdk8 | |||
26 | USE_TOOLS+= pax | 25 | USE_TOOLS+= pax | |
27 | 26 | |||
28 | INSTALLATION_DIRS= bin share/${PKGBASE} | 27 | INSTALLATION_DIRS= bin share/${PKGBASE} | |
28 | CHECK_INTERPRETER_SKIP= share/sql-workbench/sqlwbconsole.sh \ | |||
29 | share/sql-workbench/sqlworkbench.sh \ | |||
30 | share/sql-workbench/download_jre.sh | |||
29 | 31 | |||
30 | pre-extract: | 32 | pre-extract: | |
31 | mkdir -p ${WRKSRC} | 33 | mkdir -p ${WRKSRC} | |
32 | 34 | |||
33 | do-build: | 35 | do-build: | |
34 | 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 | |
35 | 37 | |||
36 | do-install: | 38 | do-install: | |
37 | cd ${WRKSRC} && pax -rwpm . ${DESTDIR}${PREFIX}/share/${PKGBASE} | 39 | cd ${WRKSRC} && ${PAX} -rwpm -s /\.orig$$// . ${DESTDIR}${PREFIX}/share/${PKGBASE} | |
38 | ${INSTALL_SCRIPT} ${WRKDIR}/sqlworkbench.sh ${DESTDIR}${PREFIX}/bin/sqlworkbench | 40 | ${INSTALL_SCRIPT} ${WRKDIR}/sqlworkbench.sh ${DESTDIR}${PREFIX}/bin/sqlworkbench | |
39 | 41 | |||
40 | .include "../../mk/java-vm.mk" | 42 | .include "../../mk/java-vm.mk" | |
41 | .include "../../mk/bsd.pkg.mk" | 43 | .include "../../mk/bsd.pkg.mk" |
@@ -1,22 +1,26 @@ | @@ -1,22 +1,26 @@ | |||
1 | @comment $NetBSD: PLIST,v 1.4 2018/12/11 15:29:31 abs Exp $ | 1 | @comment $NetBSD: PLIST,v 1.5 2021/09/30 15:50:33 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.cfg.sample | |
5 | share/sql-workbench/SQLWorkbench.exe | 5 | share/sql-workbench/SQLWorkbench.exe | |
6 | share/sql-workbench/SQLWorkbench.vbs | |||
7 | share/sql-workbench/SQLWorkbench64.exe | 6 | share/sql-workbench/SQLWorkbench64.exe | |
8 | share/sql-workbench/history.html | 7 | share/sql-workbench/download_jre.cmd | |
8 | share/sql-workbench/download_jre.ps1 | |||
9 | share/sql-workbench/download_jre.sh | |||
10 | share/sql-workbench/ext/README_EXT | |||
11 | share/sql-workbench/ext/flatlaf.jar | |||
9 | share/sql-workbench/log4j-sample.xml | 12 | share/sql-workbench/log4j-sample.xml | |
13 | share/sql-workbench/manual/SQLWorkbench-Manual.pdf | |||
10 | share/sql-workbench/manual/annotations.html | 14 | share/sql-workbench/manual/annotations.html | |
11 | share/sql-workbench/manual/command-copy.html | 15 | share/sql-workbench/manual/command-copy.html | |
12 | share/sql-workbench/manual/command-export.html | 16 | share/sql-workbench/manual/command-export.html | |
13 | share/sql-workbench/manual/command-import.html | 17 | share/sql-workbench/manual/command-import.html | |
14 | share/sql-workbench/manual/commandline.html | 18 | share/sql-workbench/manual/commandline.html | |
15 | share/sql-workbench/manual/compare-commands.html | 19 | share/sql-workbench/manual/compare-commands.html | |
16 | share/sql-workbench/manual/console-mode.html | 20 | share/sql-workbench/manual/console-mode.html | |
17 | share/sql-workbench/manual/data-pumper.html | 21 | share/sql-workbench/manual/data-pumper.html | |
18 | share/sql-workbench/manual/db-tree.html | 22 | share/sql-workbench/manual/db-tree.html | |
19 | share/sql-workbench/manual/dbexplorer.html | 23 | share/sql-workbench/manual/dbexplorer.html | |
20 | share/sql-workbench/manual/dbms-problems.html | 24 | share/sql-workbench/manual/dbms-problems.html | |
21 | share/sql-workbench/manual/dbms-specific.html | 25 | share/sql-workbench/manual/dbms-specific.html | |
22 | share/sql-workbench/manual/editor-bookmarks.html | 26 | share/sql-workbench/manual/editor-bookmarks.html | |
@@ -55,31 +59,28 @@ share/sql-workbench/manual/understand-al | @@ -55,31 +59,28 @@ share/sql-workbench/manual/understand-al | |||
55 | share/sql-workbench/manual/using-fk.html | 59 | share/sql-workbench/manual/using-fk.html | |
56 | share/sql-workbench/manual/using-scripting.html | 60 | share/sql-workbench/manual/using-scripting.html | |
57 | share/sql-workbench/manual/using-variables.html | 61 | share/sql-workbench/manual/using-variables.html | |
58 | share/sql-workbench/manual/using.html | 62 | share/sql-workbench/manual/using.html | |
59 | share/sql-workbench/manual/wb-commands.html | 63 | share/sql-workbench/manual/wb-commands.html | |
60 | share/sql-workbench/manual/wb-grep-commands.html | 64 | share/sql-workbench/manual/wb-grep-commands.html | |
61 | share/sql-workbench/manual/wb-info-commands.html | 65 | share/sql-workbench/manual/wb-info-commands.html | |
62 | share/sql-workbench/manual/wb-macro-commands.html | 66 | share/sql-workbench/manual/wb-macro-commands.html | |
63 | share/sql-workbench/manual/wb-var-commands.html | 67 | share/sql-workbench/manual/wb-var-commands.html | |
64 | share/sql-workbench/manual/workbench-manual-single.html | 68 | share/sql-workbench/manual/workbench-manual-single.html | |
65 | share/sql-workbench/manual/workbench-manual.html | 69 | share/sql-workbench/manual/workbench-manual.html | |
66 | share/sql-workbench/manual/workspace-usage.html | 70 | share/sql-workbench/manual/workspace-usage.html | |
67 | share/sql-workbench/sqlwbconsole.cmd | 71 | share/sql-workbench/sqlwbconsole.cmd | |
68 | share/sql-workbench/sqlwbconsole.exe | |||
69 | share/sql-workbench/sqlwbconsole.sh | 72 | share/sql-workbench/sqlwbconsole.sh | |
70 | share/sql-workbench/sqlwbconsole64.exe | |||
71 | share/sql-workbench/sqlworkbench.cmd | 73 | share/sql-workbench/sqlworkbench.cmd | |
72 | share/sql-workbench/sqlworkbench.desktop | |||
73 | share/sql-workbench/sqlworkbench.jar | 74 | share/sql-workbench/sqlworkbench.jar | |
74 | share/sql-workbench/sqlworkbench.sh | 75 | share/sql-workbench/sqlworkbench.sh | |
75 | share/sql-workbench/workbench32.png | 76 | share/sql-workbench/workbench32.png | |
76 | share/sql-workbench/xslt/jdbctypes2oracle.xslt | 77 | share/sql-workbench/xslt/jdbctypes2oracle.xslt | |
77 | share/sql-workbench/xslt/liquibase_common.xslt | 78 | share/sql-workbench/xslt/liquibase_common.xslt | |
78 | share/sql-workbench/xslt/wbdiff2derby.xslt | 79 | share/sql-workbench/xslt/wbdiff2derby.xslt | |
79 | share/sql-workbench/xslt/wbdiff2html.xslt | 80 | share/sql-workbench/xslt/wbdiff2html.xslt | |
80 | share/sql-workbench/xslt/wbdiff2liquibase.xslt | 81 | share/sql-workbench/xslt/wbdiff2liquibase.xslt | |
81 | share/sql-workbench/xslt/wbdiff2mssql.xslt | 82 | share/sql-workbench/xslt/wbdiff2mssql.xslt | |
82 | share/sql-workbench/xslt/wbdiff2oracle.xslt | 83 | share/sql-workbench/xslt/wbdiff2oracle.xslt | |
83 | share/sql-workbench/xslt/wbdiff2pg.xslt | 84 | share/sql-workbench/xslt/wbdiff2pg.xslt | |
84 | share/sql-workbench/xslt/wbdiff2simple_html.xslt | 85 | share/sql-workbench/xslt/wbdiff2simple_html.xslt | |
85 | share/sql-workbench/xslt/wbexport2dbunit.xslt | 86 | share/sql-workbench/xslt/wbexport2dbunit.xslt |
@@ -1,6 +1,6 @@ | @@ -1,6 +1,6 @@ | |||
1 | $NetBSD: distinfo,v 1.6 2018/12/11 15:29:31 abs Exp $ | 1 | $NetBSD: distinfo,v 1.7 2021/09/30 15:50:33 abs Exp $ | |
2 | 2 | |||
3 | SHA1 (Workbench-Build124.zip) = e0f8eb4625e8c11de0b3c4440a1c64da98dc78aa | 3 | SHA1 (Workbench-Build127.zip) = 4a389a1515f9751c67ba7ea327a528271075a0f0 | |
4 | RMD160 (Workbench-Build124.zip) = 5780052b1ba96119320270b57a897da39fad7de3 | 4 | RMD160 (Workbench-Build127.zip) = 7deaf40efd26fca2bebe20712e027dbf390649f4 | |
5 | SHA512 (Workbench-Build124.zip) = 82dc66199ad8f13fde96a6b2126ac54bd8108af8f15212daf10d2359fff1400607c557caca1a917ae93e3a5ab66791a0f6f57fa21f19814958d64822acb84026 | 5 | SHA512 (Workbench-Build127.zip) = 4d675136767d8d347ced22214fab036fb24c6e6c844bdef07c3290f6890c8f96a0555ae7dd00df639bc5832deb79ac79329fbc062f0f93f2a9b89d0a12c61156 | |
6 | Size (Workbench-Build124.zip) = 6868177 bytes | 6 | Size (Workbench-Build127.zip) = 8275806 bytes |