Up to [cvs.NetBSD.org] / pkgsrc / databases / sql-workbench
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
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.
databases: Replace RMD160 checksums with BLAKE2s checksums All checksums have been double-checked against existing RMD160 and SHA512 hashes The following distfiles could not be fetched (some may be only fetched conditionally): ./databases/cstore/distinfo D6.data.ros.gz ./databases/cstore/distinfo cstore0.2.tar.gz ./databases/cstore/distinfo data4.tar.gz
databases: Remove SHA1 distfile hashes
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
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)
Updated databases/sql-workbench to 122 Also some minor pkglint Build 122 (2017-02-04) Enhancements Conditional execution of Workbench commands now support -isDBMS and -isNotDBMS Added basic support for EXAsol Added support for SSH tunneling per connection profile When loading a SQL script it's now possible to automatically detect the encoding It's now possible to filter the output of WbVarList It's now possible to pin a result tab so that it doesn't get closed even if append mode is not enabled WbExport, WbImport, WbCopy and WbConfirm now support conditional execution WbTriggerSource now also supports writing the source to a file For Postgres, dependencies between triggers and tables are no shown in the DbExplorer and DbTree For Postgres, functions defined as "returns setof refcursor" are now processed correctly when using "select * from function()" For Postgres, it's now possible to import values into array columns if the source data is formatted as a Postgres array literal (WbImport and WbCopy) A new annotation (@WbCrossTab) is available to create simple crosstabs (aka "pivot") from query results. Improved editing of Postgres' hstore result columns. For SQL Server, the object dependencies now include named default constraints and custom data types Bug fixes For Oracle the DDL for tables using reference partitioning was not generated correctly In batch mode when specifying a connection profile using -profile, the setting to ignore drop errors from the profile was ignored The width of the DbTree was limited if the DbExplorer panel was also displayed For HSQLDB, BIT columns were not displayed correctly. For Oracle, the DEDUPLICATION option was not shown for LOB columns Auto completion did not overwrite a partial table (or column) name if that part was a SQL keyword. Activating the object list filter in the DbExplorer by using the toolbar button did not work reliably. Passing connection properties using -connectionProperties to WbCreateProfile did not work When using a profile specific macro file, opening a new window did not always work. When using an Oracle 12.x JDBC driver, materialized views were always reported as missing with WbSchemaDiff It was no longer possible to select "As Is" for the built-in SQL formatter Several features in the DbExplorer did not work for Amazon Redshift Feedback from connect scripts was not always shown in the message tab Error messages were not shown for errors that occurred in connect scripts For Postgres, the remarks for indexes were not retrieved correctly if indexes with the same name existed in different schemas The formatter did not treat the := operator properly for MySQL For Postgres, the source of a table was not shown when an old (unsupported) version of Postgres was used For SQL Server (and other DBMS supporting schemas and catalogs) the list of schemas was not properly refreshed when the database was changed in the DbExplorer's dropdowns For Oracle, value literals for RAW columns where not created correctly For Oracle, -clobAsFile for WbExport was not working for XML columns For Oracle, overloaded procedures inside packages where no longer displayed. For SQL Server, the source of procedures, functions and triggers was not displayed correctly in the DbExplorer for databases other then the default database of the connection. When using -configDir in console mode the connection profiles were still loaded from the default location. For Postgres, when generating scripts for tables and sequences the owner column for a sequence was not correctly generated. Build 121 (2016-07-31) Bug fixes Some DDL statements were not generated properly when changing tables or indexes in the DbExplorer For Oracle, columns defined as TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH LOCAL TIMEZONE where not displayed correctly It was no longer possible to use a timestamp format without time for WbImport When loading a new macro file, the macro menu was not updated.
Updated databases/sql-workbench to 120 Enhancements * It's now possible to delete variables using wildcards * It's now possible to test the connection from the profile dialog * For Postgres, the generated source code for functions and custom aggregates now contains the new PARALLEL settings for Postgres 9.6 * It's now possible to show a quick filter in the macro popup window * When searching for a JDBC driver class in the driver's jar file, available service registrations are used to speed up the searching. * It's now possible to disable icons in menus * For HSQLDB 2.3.4 synonyms are now displayed * It's now possible to configure the buttons on the toolbar * It's now possible to restore recently closed editor tabs * For Progress OpenEdge, squences and synonyms are now shown in the DbExplorer * It's now possible to associate variables with the connection profile and the workspace * For SAP HANA the source for synonyms are now shown * For SAP HANA dependency for tables, views, triggers, procedures and sequences are now shown in the DbExplorer and DbTree * A new command (WbGenerateFKScript) is available to generate the DDL for only the foreign key constraints. * For DB2 10.5 indexes based on expressions are now shown correctly Bug fixes * For SQL Server, the source code for user defined object types with columns was incorrect. * For DBMS supporting catalogs and schemas, auto completion for large schemas was slow. * Fixed a problem where in rare cases, closing an editor tab could hang the application. * Ignoring the "Max Rows" setting in the DbExplorer's table data did not work any more * WbListMacros, WbDeleteMacro and WbDefineMacro were always using the default macro file * Timestamps with microseconds (.SSSSSS in the format) where not imported correctly with WbImport * For Postgres, the LEAKPROOF attribute was not included in the generated source code for functions * WbSchemaDiff incorrectly combined all tables to be dropped in a single tag * For Postgres, the format of hstore literals was not correct when exporting data as SQL statements * For Postgres, hstore columns could not be edited in a query result * The ALTER TABLE OWNER TO statement for Postgres was not created correctly * It wasn't possible to use -mode=Upsert or -mode=InsertIgnore with WbCopy * Parsing of comments in SQL statements is now more lenient with invalid (nested) comments * When changing the position of SQL tabs with files loaded, the Workspace was not saved properly * For Progress OpenEdge, the SQL generated for sequences was invalid * For Postgres, the implizit index for an exclusion constraint was incorrectly added to the souce of the table * The format of a hstore and array literals was not correct for generated SQL statements * For Oracle procedures from packages that contained only procedures without parameters were not displayed. * Implemented a workaround for the MariaDB JDBC driver that returns invalid object type names for tables ("BASE TABLE" instead of "TABLE") * Generate "DROP script with dependencies" was no longer working in the DbExplorer or DbTree * When using SQL Workbench in batch mode, passing quoted parameters on the command line did not work properly * The DDL for tables was not displayed when using Amazon Redshift * Using sqlwbconsole.sh together with -command or -script on a headless system did not work * The display for LVARCHAR and DATE columns was not always correct for Informix * Warnings that were reported by the JDBC driver after establishing the connection were sometimes shown in the generated DDL in the DbTree * The DDL for sequences in Oracle did not reflect the values for CYCLE and ORDER * Running PL/SQL in Oracle did not work if the option "Remove comments" was enabled in the connection profile * When using "Create DDL script" in the DbExplorer, the source for materialized views was generated twice * With certain Oracle driver versions, TYPEs where displayed twice in the DbExplorer or the DbTree * When exporting to text files, values containing the line delimiter were not quoted properly * With SQL Server, it was not possible to drop indexes from within the DbTree * Passwords are no longer trimmed
Update to SQL Workbench/J build 119. Build 119 (2016-01-31) Enhancements * It's now possible to display the column's data type in the header of the result table * When importing all files from a directory, WbImport now provided pre-defined variables with the filename * It's now possible to configure auto-saving of external files independently from auto-saving the workspace. * A new command WbMessage to display a simple message is available. * It's not possible to search text in all open editors (Tools -> Search all tabs) * For some DBMS, the DbTree and DbExplorer now show the dependencies between objects * For DB2/iSeries table and column comments can now be retrieved from the system catalogs instead of using the JDBC driver. * For Postgres it is now possible to manually control transactions using BEGIN .. COMMIT when the connection is set to autocommit * The list of tables in the DbTree is now sorted to work around bugs in JDBC driver that do not properly sort the list of tables * For DBMS that support it, two new modes have been added to WbImport: -upsert and -insertIgnore using native "UPSERT" functionality if available * For Firebird the SQL source of external tables is now generated correctly. * An new command WbGenerateImpTable is available to infer the structure of a table from an import file * The command line parameter -vardef has been deprecated and replaced with -variable and -varFile * It's now possible to provide tags for each connection profile. The quickfilter will then use the defined tags for filtering the displayed profiles. * Connection parameters specified on the command line now have precedence over the properties defined through a Liquibase defaults file (specified through -lbDefaults) * It's now possible to enable the use of Oracle's DBMS_METADATA for source code retrieval for different types of objects * The tooltip shown for result tabs can now be configured (Options -> Data display) * For the internal SQL formatter, it's now possible to configure the case in which data type names are written * A new action to run all SQL statements up to the cursor position is available * The error dialog that is displayed when running a script can now be configured to also include the error message or the statement that failed * Improved display of packages in the DbTree for Oracle and Firebird Bug fixes * Showing rowcounts in the DbTree did not work for DB2 * "Generate Delete Script" for a selection of rows in the result did not display the generated script. * When reloading the whole DbTree while a node was selected, would show elements (e.g. tables) twice * CREATE TABLE statements were not formatted correctly if the name consisted of quoted and unquoted parts (e.g. unquoted schema and quoted table name) * The error dialog when running running multiple statements was not displayed on Linux if the option "Include error message" was selected in the "SQL Execution" options * Improved the performance when retrieving table definitions and table source for Oracle * For Postgres, rules defined on a table where shown twice in the generated DDL script * Retrieving additional column information in the DbExplorer failed on SQL Server if a non-standard database collation was used * The DDL for constraints or comments where identifiers required quoting was not correct * The formatter would not process statements correctly where a sub select using function calls in the WHERE clause was used in a JOIN condition * When using "Remove Comments" for a connection profile, the error position inside a statement was not shown correctly for some DBMS * For Oracle, when using "Trim CHAR data" and editing tables where the primary key column was defined as CHAR, updating the result did not work. * Toggle comment did not toggle correctly when some lines were already commented and some not * The messages shown when using conditional execution with WbInclude did not properly include the variable name or value * For Oracle the tablespace of materialized views was not shown in the generated SQL (Fix contributed by Franz Mayer) * It was not possible to work with SAVEPOINTs correctly * Table definitions for tables with VARCHAR columns were not displayed for Oracle * Disabling the check for read-only columns did not work for all JDBC drivers * WbCopy now stops with an error if -targetTable is specified and -sourceTable is used to specify multiple tables * For DB2 the names of PK constraints where not properly qualified with a schema if needed * Sometimes using "Execute current" would not correctly identify the current statement and run the first statement from the editor * WbImport using -insert,update did not work for multi-column primary keys when not all PK columns where part of the input file * When a variable value contained the prefix and the suffix of the variable pattern, using such a variable would result in SQL Workbench/J locking up * Reloading a trigger source in the DbExplorer's trigger panel did not work * For Oracle the source of a trigger that had a trailing space in the name was not retrieved * For Oracle the position of errors in regular (non-PL/SQL) DDL statements was not shown * When starting SQL Workbench on a headless system, using "java -jar" using the -script parameter did not work any longer * For SQL Server 2000, retrieving the source of a view did not work * For SQL Server, generating "dummy DML" for tables with "bit" columns did not work * For MySQL the option "on update" for a default value was not shown in the generated SQL source for a table Build 118 (2015-08-16) Enhancements * Added support to include computed columns for MySQL 5.7 in the generated CREATE TABLE source * The source and target connection for WbCopy, WbSchemaDiff and WbDataDiff can now be specified on the command line when starting the application. In that case it's not necessary to provide them to the respective commands * A new action to run all SQL statements in the editor starting from the cursor position is available * It's now possible to use OS environment variable or Java properties in the username of a connection profile. * For Postgres, "COPY .. FROM stdin" with the data after the statement is now supported * It's now possible to define external tools to format SQL * For decimal values WbExport now supports the parameters -fixedDigits and -maxDigits. * It's now possible to enable editing (and running) the generated SQL source code in the DbExplorer directly. * For Oracle, messages from dbms_output are now always shown if a procedure is started using EXECUTE regardless of the setting of "set serveroutput" * Added some basic support for SAP HANA. * For Excel imports, the option -stringDates=true retrieves Dates as formatted strings and converts them using the date/timestamp format specified in the WbImport command rathr then reading a converted value from the Excel file. * For Excel exports, the start location where the data should be written to in the excel file can now be specified using the -offset parameter * The application to be used for displaying the logfile can now be configured. * WbSchemaReport has a new (boolean) option -writeFullSource to write a valid CREATE VIEW statement to the XML output in case the DBMS does not store the complete SQL * Results can now automatically be refreshed either through an annotation or through the context menu of the result tab * The macros in a group can now be sorted alphabetically * The quoting of the null values for text exports can now be enabled through the option -quoteNulls * The quoting of the header for text exports can now be enabled through the option -quoteHeader * The statement at the cursor position can now be copied directly into the clipboard (Code Tools -> Copy current statement) * For Oracle, the partitions of a materialized view are now shown in the source code * WbImport and WbCopy (including the DataPumper) can now be used to insert data into a view * For tables without a primary key, unique indexes that contain nullable columns are no longer considered when generating DML statements * For Vertica tables and views from the schema "v_internal" are now show in the DbExplorer (contributed by Tatiana Saltykova) * It's now possible to define the terminator string for "Copy Code Snippet" through the config property "workbench.clipcreate.codeend" * Macros and macro groups can now be excluded from the popup window Bug fixes * The menu to select data from referenced/referencing tables in a result set was disabled when switching to the DbExplorer and back to the SQL panel * -syncDelete with WbCopy did not work if alternate key columns were specified using -keyColumns * Fixed retrieval of stored procedures for DB2 on AS/400 (thanks to Francesco) * Fixed detection of update columns for multi-table result sets when the name of the PK columns is not uniuqe in the result set * For Firebird the source code for procedures with multiple out parameters was not generated correctly. * For PostgreSQL, SQL statements to create the comment for functions with OUT parameters were not generated correctly. * When running a single command in batch mode, the error status was not returned correctly to the operating system * WbExport no longer uses the GUI defaults for decimal digits. The default is now to always export all digits, unless the new -maxDigits parameter is used * For MySQL, when multiple tables with the same name in different databases had triggers defined, all triggers where visible for each table in the DbExplorer * When importing multiple files using -usePgCopy and one file generated an error, the previous import was not committed * WbConnect would prompt for a password for profiles with an empty password even if "Save password" was enabled * No parameter prompt was shown for INOUT parameters when running procedures using WbCall * Implemented a workaround for an Informix driver bug where index information for the wrong table was returned * Double quotes in column values were not escaped properly when creating a JSON export * When switching between views and tables in the DbExplorer the foreign key tabs were no longer shown for SQL Server * Compile errors for Oracle's PL/SQL where not always shown correctly * Parameters for SQL Workbench commands with nested single and double quotes that included SQL comments were not evaluated properly * Fixed restoring of the window position when using multiple monitors * Generating the SQL source for computed columns did not work for SQL Server 2000 * The SQL source for inherited tables in Postgres was not generated correctly. * The SQL source for sequences for SQL Server was not generated correctly. * "Create DDL script" in the DbExplorer would generate the source code for sequnces twice * Nano (or micro) seconds from timestamp values where not displayed correctly * When opening a file, it is now checked if the selected encoding matches the one from the file * Each time when reloading a result that uses the @WbMacro annotation, the macro sub-menu would be added to the context menu again * For Informix, default clauses for columns were not generated properly in the DbExplorer * For Informix, index definitions were not always displayed correctly * Overloaded functions and procedures where not handled correctly by WbSchemaDiff * For Postgres the wrong DROP FUNCTION statement was generated if a function contained OUT parameter * Scripts that contained statements including character literals with a backslash were not always parsed correctly. * When WbImport did not find any matching columns, the error message did not include the (faulty) source file * Fixed the display of the profile tree with large fonts * The DataPumper did not work if source and destination had a different number of columns * The generated WbCopy command in the DataPumper was not correct when a query was used as the source * XLSX export did not work if the output file was specified without an extension * Fixed some issues with restoring the window position on multi-monitor systems * Fixed some issues where the alternate delimiter was incrrectly used when running scripts through WbInclude * When importing multiple Excel files with WbImport using the -sourceDir argument, only the first file was imported * The abbreviated WbInclude using @ only worked with Oracle * The minutes for columns of type "timestamp with time zone" where not always displayed correctly in Oracle * Oracle's autotrace did not work in console mode * Using pgpass for Postgres connections did not work in console or batch mode * WbProcSource would not show the code for a packaged procedure in Oracle * Fixed some problems in the SQL formatter that would lead to invalid SQL syntax * XSLT transformations failed when the output filename didn't include a directory * Disabling "Filter while typing" in the DbExplorer was not possible * -targetConnection and -referenceConnection for WbSchemaDiff and WbDataDiff were broken
Add SHA512 digests for distfiles for databases category Problems found with existing distfiles: distfiles/D6.data.ros.gz distfiles/cstore0.2.tar.gz distfiles/data4.tar.gz distfiles/sphinx-2.2.7-release.tar.gz No changes made to the cstore or mariadb55-client distinfo files. Otherwise, existing SHA1 digests verified and found to be the same on the machine holding the existing distfiles (morden). All existing SHA1 digests retained for now as an audit trail.
Import SQL Workbench/J build 117 as databases/sql-workbench. SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. Graphical query building or more advanced DBA tasks are not the focus and are not planned. Features: * Edit, insert and delete data directly in the query result. * Powerful export command to write text files (aka "CSV"), XML, HTML or SQL (including BLOB data). All user tables can be exported into a directory with a single command. Export files can be compressed "on-the-fly". * Powerful text, XML and spreadsheet import. A set of files (including compressed files) can be imported from a directory with a single command. Foreign key constraints are detected to insert the data in the correct order. * Compare two database schemas for differences. The XML output can be transformed into the approriate SQL ALTER statements using XSLT. * Compare the data of two database and generate the necessary SQL statements to migrate one to the other. * Supports running SQL scripts in batch mode. * Supports running in console mode. * Search text in procedure, view and other sources using a SQL command or a GUI. * Search for data across all columns in all tables using a SQL command or a GUI. * Reformatting (Pretty-Print) of SQL Statements. * Select rows from related tables according to their foreign key definitions. * Tooltips for INSERT statements to show the corresponding value or column. * Copy data directly between to database servers using a SQL command or a GUI. * Macros (aka aliases) for frequently used SQL statements. * Variable substitution in SQL statements including smart prompting for values (can be combined with macros). * Auto completion for tables and columns in SQL statements. * Display database objects and their definitions. * Display table source. * Display view, procedure and trigger source code. * Display foreign key constraints between tables. * Full support for BLOB data in query results, SQL statements, export and import. * SQLWorkbench/J is free for almost everyone (published under a modified the Apache 2.0 license).
Initial revision