diff options
author | abs <abs@pkgsrc.org> | 2021-09-30 15:50:33 +0000 |
---|---|---|
committer | abs <abs@pkgsrc.org> | 2021-09-30 15:50:33 +0000 |
commit | f592453940ba0fa1216f230c205ef6ce51637ef2 (patch) | |
tree | ed4ac449bb90e112ce5b392cb9e5ebcc4a4a86af /databases | |
parent | 92f4d641059317a5e2b5ce3951c7c1d80dc61af6 (diff) | |
download | pkgsrc-f592453940ba0fa1216f230c205ef6ce51637ef2.tar.gz |
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 work
Diffstat (limited to 'databases')
-rw-r--r-- | databases/sql-workbench/Makefile | 20 | ||||
-rw-r--r-- | databases/sql-workbench/PLIST | 15 | ||||
-rw-r--r-- | databases/sql-workbench/distinfo | 10 |
3 files changed, 24 insertions, 21 deletions
diff --git a/databases/sql-workbench/Makefile b/databases/sql-workbench/Makefile index 5408fbca0ed..6cb46c621f7 100644 --- a/databases/sql-workbench/Makefile +++ b/databases/sql-workbench/Makefile @@ -1,7 +1,7 @@ -# $NetBSD: Makefile,v 1.7 2019/11/02 15:38:11 rillig Exp $ +# $NetBSD: Makefile,v 1.8 2021/09/30 15:50:33 abs Exp $ -DISTNAME= Workbench-Build124 -PKGNAME= sql-workbench-124 +DISTNAME= Workbench-Build127 +PKGNAME= sql-workbench-127 CATEGORIES= databases MASTER_SITES= http://www.sql-workbench.net/ EXTRACT_SUFX= .zip @@ -9,23 +9,25 @@ EXTRACT_SUFX= .zip MAINTAINER= asau@inbox.ru HOMEPAGE= http://www.sql-workbench.net/ COMMENT= JDBC-based cross-platform SQL query tool - # Apache, except not granted to certain entities -LICENSE= generic-nonlicense +LICENSE= generic-nonlicense + RESTRICTED= Some entities are not permitted to use/download. -NO_SRC_ON_FTP= ${RESTRICTED} +NO_BIN_ON_CDROM= ${RESTRICTED} NO_BIN_ON_FTP= ${RESTRICTED} NO_SRC_ON_CDROM= ${RESTRICTED} -NO_BIN_ON_CDROM= ${RESTRICTED} +NO_SRC_ON_FTP= ${RESTRICTED} EXTRACT_DIR= ${WRKSRC} USE_JAVA= run USE_JAVA2= 8 -PKG_JVMS_ACCEPTED= oracle-jdk8 openjdk8 USE_TOOLS+= pax INSTALLATION_DIRS= bin share/${PKGBASE} +CHECK_INTERPRETER_SKIP= share/sql-workbench/sqlwbconsole.sh \ + share/sql-workbench/sqlworkbench.sh \ + share/sql-workbench/download_jre.sh pre-extract: mkdir -p ${WRKSRC} @@ -34,7 +36,7 @@ do-build: 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 do-install: - cd ${WRKSRC} && pax -rwpm . ${DESTDIR}${PREFIX}/share/${PKGBASE} + cd ${WRKSRC} && ${PAX} -rwpm -s /\.orig$$// . ${DESTDIR}${PREFIX}/share/${PKGBASE} ${INSTALL_SCRIPT} ${WRKDIR}/sqlworkbench.sh ${DESTDIR}${PREFIX}/bin/sqlworkbench .include "../../mk/java-vm.mk" diff --git a/databases/sql-workbench/PLIST b/databases/sql-workbench/PLIST index 16e2f7eb253..9a713812b49 100644 --- a/databases/sql-workbench/PLIST +++ b/databases/sql-workbench/PLIST @@ -1,12 +1,16 @@ -@comment $NetBSD: PLIST,v 1.4 2018/12/11 15:29:31 abs Exp $ +@comment $NetBSD: PLIST,v 1.5 2021/09/30 15:50:33 abs Exp $ bin/sqlworkbench share/sql-workbench/LICENSE -share/sql-workbench/SQLWorkbench-Manual.pdf +share/sql-workbench/SQLWorkbench.cfg.sample share/sql-workbench/SQLWorkbench.exe -share/sql-workbench/SQLWorkbench.vbs share/sql-workbench/SQLWorkbench64.exe -share/sql-workbench/history.html +share/sql-workbench/download_jre.cmd +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/log4j-sample.xml +share/sql-workbench/manual/SQLWorkbench-Manual.pdf share/sql-workbench/manual/annotations.html share/sql-workbench/manual/command-copy.html share/sql-workbench/manual/command-export.html @@ -65,11 +69,8 @@ share/sql-workbench/manual/workbench-manual-single.html share/sql-workbench/manual/workbench-manual.html share/sql-workbench/manual/workspace-usage.html share/sql-workbench/sqlwbconsole.cmd -share/sql-workbench/sqlwbconsole.exe share/sql-workbench/sqlwbconsole.sh -share/sql-workbench/sqlwbconsole64.exe share/sql-workbench/sqlworkbench.cmd -share/sql-workbench/sqlworkbench.desktop share/sql-workbench/sqlworkbench.jar share/sql-workbench/sqlworkbench.sh share/sql-workbench/workbench32.png diff --git a/databases/sql-workbench/distinfo b/databases/sql-workbench/distinfo index e7b520a2e73..6f1abd74bcf 100644 --- a/databases/sql-workbench/distinfo +++ b/databases/sql-workbench/distinfo @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.6 2018/12/11 15:29:31 abs Exp $ +$NetBSD: distinfo,v 1.7 2021/09/30 15:50:33 abs Exp $ -SHA1 (Workbench-Build124.zip) = e0f8eb4625e8c11de0b3c4440a1c64da98dc78aa -RMD160 (Workbench-Build124.zip) = 5780052b1ba96119320270b57a897da39fad7de3 -SHA512 (Workbench-Build124.zip) = 82dc66199ad8f13fde96a6b2126ac54bd8108af8f15212daf10d2359fff1400607c557caca1a917ae93e3a5ab66791a0f6f57fa21f19814958d64822acb84026 -Size (Workbench-Build124.zip) = 6868177 bytes +SHA1 (Workbench-Build127.zip) = 4a389a1515f9751c67ba7ea327a528271075a0f0 +RMD160 (Workbench-Build127.zip) = 7deaf40efd26fca2bebe20712e027dbf390649f4 +SHA512 (Workbench-Build127.zip) = 4d675136767d8d347ced22214fab036fb24c6e6c844bdef07c3290f6890c8f96a0555ae7dd00df639bc5832deb79ac79329fbc062f0f93f2a9b89d0a12c61156 +Size (Workbench-Build127.zip) = 8275806 bytes |