The NetBSD Project

CVS log for pkgsrc/databases/sql-workbench/distinfo

[BACK] Up to [] / pkgsrc / databases / sql-workbench

Request diff between arbitrary revisions

Default branch: MAIN

Revision 1.9 / (download) - annotate - [select for diffs], Tue Oct 26 10:10:05 2021 UTC (2 years, 1 month ago) by nia
Branch: MAIN
CVS Tags: pkgsrc-2023Q3-base, pkgsrc-2023Q3, pkgsrc-2023Q2-base, pkgsrc-2023Q2, pkgsrc-2023Q1-base, pkgsrc-2023Q1, pkgsrc-2022Q4-base, pkgsrc-2022Q4, pkgsrc-2022Q3-base, pkgsrc-2022Q3, pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1, pkgsrc-2021Q4-base, pkgsrc-2021Q4, HEAD
Changes since 1.8: +2 -2 lines
Diff to previous 1.8 (colored)

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

./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz

Revision 1.8 / (download) - annotate - [select for diffs], Thu Oct 7 13:35:50 2021 UTC (2 years, 2 months ago) by nia
Branch: MAIN
Changes since 1.7: +1 -2 lines
Diff to previous 1.7 (colored)

databases: Remove SHA1 distfile hashes

Revision 1.7 / (download) - annotate - [select for diffs], Thu Sep 30 15:50:33 2021 UTC (2 years, 2 months ago) by abs
Branch: MAIN
Changes since 1.6: +5 -5 lines
Diff to previous 1.6 (colored)

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)

 - 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 ( 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)

 - 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

Revision 1.6 / (download) - annotate - [select for diffs], Tue Dec 11 15:29:31 2018 UTC (5 years ago) by abs
Branch: MAIN
CVS Tags: pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2, pkgsrc-2021Q1-base, pkgsrc-2021Q1, pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3, pkgsrc-2020Q2-base, pkgsrc-2020Q2, pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3, pkgsrc-2019Q2-base, pkgsrc-2019Q2, pkgsrc-2019Q1-base, pkgsrc-2019Q1, pkgsrc-2018Q4-base, pkgsrc-2018Q4
Changes since 1.5: +5 -5 lines
Diff to previous 1.5 (colored)

Updated databases/sql-workbench to 124

Build 124 (2018-08-20)


 - 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)


 - 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)

Revision 1.5 / (download) - annotate - [select for diffs], Mon Jun 12 12:07:39 2017 UTC (6 years, 6 months ago) by abs
Branch: MAIN
CVS Tags: pkgsrc-2018Q3-base, pkgsrc-2018Q3, pkgsrc-2018Q2-base, pkgsrc-2018Q2, pkgsrc-2018Q1-base, pkgsrc-2018Q1, pkgsrc-2017Q4-base, pkgsrc-2017Q4, pkgsrc-2017Q3-base, pkgsrc-2017Q3, pkgsrc-2017Q2-base, pkgsrc-2017Q2
Changes since 1.4: +5 -5 lines
Diff to previous 1.4 (colored)

Updated databases/sql-workbench to 122

Also some minor pkglint

Build 122 (2017-02-04)

    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.

Revision 1.4 / (download) - annotate - [select for diffs], Fri Jul 29 11:43:36 2016 UTC (7 years, 4 months ago) by abs
Branch: MAIN
CVS Tags: pkgsrc-2017Q1-base, pkgsrc-2017Q1, pkgsrc-2016Q4-base, pkgsrc-2016Q4, pkgsrc-2016Q3-base, pkgsrc-2016Q3
Changes since 1.3: +5 -5 lines
Diff to previous 1.3 (colored)

Updated databases/sql-workbench to 120


* 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 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

Revision 1.3 / (download) - annotate - [select for diffs], Thu Mar 3 17:43:45 2016 UTC (7 years, 9 months ago) by asau
Branch: MAIN
CVS Tags: pkgsrc-2016Q2-base, pkgsrc-2016Q2, pkgsrc-2016Q1-base, pkgsrc-2016Q1
Changes since 1.2: +5 -5 lines
Diff to previous 1.2 (colored)

Update to SQL Workbench/J build 119.

Build 119 (2016-01-31)


 * 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
 * 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

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
 * 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
 * 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)


 * 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
 * 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
 * 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
 * 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
 * "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
 * 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
 * -targetConnection and -referenceConnection for WbSchemaDiff
   and WbDataDiff were broken

Revision 1.2 / (download) - annotate - [select for diffs], Tue Nov 3 01:56:35 2015 UTC (8 years, 1 month ago) by agc
Branch: MAIN
CVS Tags: pkgsrc-2015Q4-base, pkgsrc-2015Q4
Changes since 1.1: +2 -1 lines
Diff to previous 1.1 (colored)

Add SHA512 digests for distfiles for databases category

Problems found with existing distfiles:
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.

Revision / (download) - annotate - [select for diffs] (vendor branch), Mon Jul 20 20:19:16 2015 UTC (8 years, 4 months ago) by asau
Branch: TNF
CVS Tags: pkgsrc-base, pkgsrc-2015Q3-base, pkgsrc-2015Q3
Changes since 1.1: +0 -0 lines
Diff to previous 1.1 (colored)

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.


 * 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).

Revision 1.1 / (download) - annotate - [select for diffs], Mon Jul 20 20:19:16 2015 UTC (8 years, 4 months ago) by asau
Branch: MAIN

Initial revision

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

CVSweb <>