Changelist:

• Results view: referencing tables view (ctrl+1)
• Results view: plain text presentation configuration
• Results view: column ordering shortcut (ctrl+0)
• Results view: boolean value editor was fixed (MacOS)
• Results view: editor activation fix (caps lock handle)
• SQL editor: auto-complete was fixed
• SQL editor: query extraction was fixed (parameters position)
• SQL formatter fix
• MacOS installer with bundled JRE
• Active schema switcher command (ctrl+shift+a)
• Navigator: connections color render was fixed
• SQL query row count function was fixed (SQL transformation)
• Older Eclipse version support was fixed (API invocations)
• Vertica: new metadata browser (projections, nodes, sequences, procedures source)
• PostgreSQL: constraints DDL reading was fixed, access methods model was fixed
• PostgreSQL: database restore command line parameters fixed
• PostgreSQL: array value render eas fixed
• PostgreSQL: data export fixed (multi-row format)
• Oracle: show expressions for function-based indexes
• Oracle: DATE data type render was fixed
• DB2: DECIMAL parameters binding was fixed
• SQL Server: sequences viewer was added
• SQL Server: fix autocompletion for table with @ and # characters
• Apache Solr driver was added
• Internationalization and localization (Chinese) were enhanced.
• Misc UI fixes

Changelist:

• Connection/schema selectors UI was improved
• Shortcuts for connection schema select (CTRL+9, CTRL+0)
• SQL error handle was fixed (error type detection, reconnect activation)
• SELECT COUNT(*) transformer was fixed
• SQL completion: multiple bug fixes
• SQL editor: single line comment toggle was fixed
• SQL editor: script execution UI config (editor pane maximize is now configurable)
• SQL editor: support association with connections from another project
• Database editor: auto-save doesn’t affect data editors
• Results viewer: varchar to binary column view transformer
• Results viewer: status label was fixed
• Results viewer: timestamp value editor was fixed
• PostgreSQL: view DDL was fixed (for alter view)
• MySQL/MariaDB: quoted schema name handle fixed
• Oracle: DATE data type support was fixed
• Oracle: execution plan for queries with parameters
• Oracle: sessions SQL read was improved
• SQL Server: native timestamp format fixed
• Data search: UI was fixed (performance)
• MetaData search: UI was fixed (tree structure)
• ER diagrams: datasource info in project explorer
• SSH tunnel config enhanced (local port number)
• i18n model enhancement
• Chinese localization
• Hex editor UI was fixed (hex panel stretching, preferences)
• Keyboard shortcuts were fixed (conflicts with other Eclipse solutions)
• Cloudera Impala driver config was added
• CUBRID driver config was added
• Office and SVG extensions moved to separate update sites (marketplace)
• Misc UI fixes

Brief changelist:

• Results editor: zoom in/zoom out support
• Stored procedures results visualization fix
• Active database/schema switcher was fixed
• Bootstrap queries processing was fixed (prepared statement)
• Command line parameters processing was fixed
• Views/triggers create/edit was fixed
• Metadata compare: compare views source
• Running queries in background: UI freeze fix
• Results viewer: columns width configuration
• Installers icons/splash screen were updated
• Chinese localization additions (-nl zh)
• Connection invalidate command was fixed
• SQL generation was improved (FQ names config for DDL)
• Oracle: PL/SQL blocks parser was fixed
• Oracle: FLOAT (NUMBER) data type edit was fixed
• MySQL: extra options in database dump wizard
• MySQL: database charset/collation edit
• DB2: show aliases in SQL auto-completion
• PostgreSQL: permissions panel was redesigned
• SQLite: data types properties
• Misc UI fixes

Note: we have re-registered all certificates to the Rider Soft LTD company. Windows executables are signed with the Symantec Code-Sign certificate. Windows 10 may warn about this certificate during one or two weeks – that’s ok.

Changelist:

• Java 9 support was fixed
• SQL Editor: connection/schema selectors redesign
• SQL Editor: divider position save
• SQL Editor: BOM for external SQL files support was added
• SQL Editor: queries folding was fixed
• SQL error chain evaluation was fixed
• SQL autocomplete for quoted and/or national identifiers was fixed
• Results viewer: cursor reposition on refresh/mode change was fixed
• Results viewer: reset all colorings action was added
• Results viewer: reflect data changes in transaction monitor
• Results viewer: right-aligned cells (numbers/dates) rendering was fixed
• Results viewer: columns drag-n-drop was redesigned (now activated on column icon dragging)
• Results viewer: multi-cell paste support was added
• SQL Editor/results viewer: SELECT COUNT query transformation was fixed (omit order)
• Dark theme support was improved
• Support of null scale/precision for numeric data types was added
• SQL generator: IS NULL/IS NOT NULL support was added
• SQL generator: omit schema name feature (configurable)
• Object editor: changes save procedure was fixed (+UI fix)
• Office (XLSX) export: numeric/boolean cells formatting was fixed
• Global schema/tables filters were fixed (MySQL/PostgreSQL)
• Connections copy/paste was fixed
• MySQL/MariaDB tables read was fixed (quoted identifiers)
• Vertica: JDBC URL was fixed (database is optional)
• Vertica: current schema detection/update
• PostgreSQL: advanced data types (postgis, json, etc) resolution fix
• PostgreSQL: procedures fully qualified names fix
• DB2: primary key drop/edit fix
• Oracle: synonyms read was fixed
• Oracle: primary key drop/edit fix
• SQL Server: GO delimiters evaluation was fixed
• Minor UI fixes

Changelist:

• Eclipse Oxygen (E4.7) is now default base platform. A lot of minor improvements/fixes comes along with it
• Chinese, Russian, German localizations are back in beta test
• Results viewer: UUID value transformer (from binary) was added
• Results viewer: multi-cell paste support was added
• Results viewer: aggregate functions for char/varchar columns
• Results viewer: filter editor dialog UI was fixed
• Connection invalidate timeout was added
• Workspace preference page was added in standalone version
• Database navigator refresh performance was fixed
• Extra command line parameters support (-closeTabs, -disconnectAll)
• SQL Editor: delimiters parser was fixed ($$ delimiters)
• SQL Editor: unsafe queries (DELETE/UPDATE without WHERE) warning was added
• SQL Editor: server-side ouput reading was redesigned (output for scripts was fixed)
• SQL Editor: SQL completion preference page was fixed (global search)
• SQL Editor: SQL completion for unicode identifiers was fixed
• SQL Editor: parameters binding (NULL value) was fixed
• SQL Editor: status message update was fixed
• ER diagrams: column comments now can be enabled on diagram
• ER diagrams: dark theme support was fixed (css)
• Object filters was fixed (asterisk in schema names)
• Oracle: zero scale for numeric data types
• Oracle: REF CURSOR read was fixed (in value view dialog)
• PostgreSQL: big table data export was fixed (memory consumption)
• PostgreSQL: table indexes DDL was fixed (read from server)
• PostgreSQL: sequences were excluded from table list
• PostgreSQL: NULL array elements reading was fixed
• Firebird: column charsets, binary columns support was added
• PrestoDB driver config was added
• UI freeze on transactions isolation level detect was fixed
• Minor UI fixes

Changelist:

• SQL editor: FK navigation was improved (open reference in new tab)
• SQL editor: code folding was added
• SQL editor: morph delimited text feature
• SQL editor: SQL formatting was fixed (Oracle)
• SQL editor: autocompletion was fixed (databases without schemas)
• ERD: diagram rendering/nodes selection was fixed
• ERD: export to SVG format was fixed
• XML editor: code folding was added
• Results viewer: CLOB reading was improved
• Results viewer: connection name in status bar (optional)
• Results viewer: copy column names action was fixed
• Results viewer: complex types (structs, arrays, objects) rendering is now configurable
• Data edit: big decimal values binding was fixed
• Metadata editor: remember editor tab sizes
• Database navigator: double-click behavior is now configurable (expand by default)
• Database navigator: column data types are visible in tree (optional)
• Bootstrap queries can use local variables
• Connections config file loading was fixed (make force refresh)
• Error handling: extract SQL error chain on client-side
• MySQL: DDL read was fixed (non-English identifiers/comments)
• MySQL: default driver version was changed to 5.1.44
• PostgreSQL: database create/drop support was added
• PostgreSQL: LIMIT/OFFSET support (for big tables export)
• PostgreSQL: default generic driver version was changed to 9.4.1212
• PostgreSQL: block statements processing was fixed
• FireBird: domain types support (read-only)
• SQLite: full table DDL (with indexes) support
• Hive: query limits config was changed
• Number of minor UI fixes

Changelist:

• Sample database was added (SQLite)
• New connection create fix (ordering in DB navigator)
• Results viewer: local ordering fix (show confirmation about data loss)
• Results viewer: copy column names/row numbers configuration dialog
• ERD: bring to front and send to back actions
• ERD: custom diagram coloring
• ERD: diagram export fix (NPE)
• ERD: SVG format export (optional extension)
• MySQL: SOURCE keyword handler was fixed
• MySQL: local client install detection was fixed
• PostgreSQL: XML value edit fix
• PostgreSQL: default tablespace info
• Generic driver: foreign keys loading fix
• Redshift: driver version update

Brief changelist:

• Results viewer: save filters settings for each table
• Results viewer: columns reordering with drag-n-drop
• Results viewer: dark theme support was improved
• SQL editor: variables support was fixed (global vars)
• SQL Editor: hyperlinks on quoted identifiers were fixed
• SQL Editor: autocomplete of quoted identifiers was fixed
• SQL scripts create was fixed (for new projects)
• Triggers source viewer was fixed (empty trigger body)
• Auto-complete: optional support of global (in all schemas) tables search
• Checkbox editor UI was fixed
• Database/schema selector was fixed (application minimize problem)
• Custom (named) object filters support was added
• Locale configuration was fixed
• Custom SQL queries ordering fix (quoted column names)
• Exasol: object comments support improved, DEFINE command support
• Oracle: all table triggers folder was added
• PostgreSQL: SSL configuration UI was fixed
• Informix: active database change was added
• Informix: column names (instead of descriptions) in results viewer
• Informix: triggers reading was fixed
• Drivers download was fixed

Changelist:

• Named filters support was added
• Data formats: locale config on Linux was fixed
• Custom SQL query ordering was fixed
• Office extension install in CE version was fixed
• Entity delete confirmation was fixed (multiple objects delete)
• Debug log configuration was added
• Query manager coloring was fixed
• ERD: support of dark theme was fixed
• Windows: taskbar notifications enhancements (for data transfer and external tools)
• Version update check was fixed
• Command line enhancements (auto-commit option)
• Full-text search processor was fixed (fail on first error)
• SQL Editor: support of dynamic include of other scripts
• SQL Editor: support of different quote chars
• SQL Editor: script commands processing was fixed
• SQL Editor: single line comments toggle was fixed
• SQL Editor: open object (F4) shortcut now works in procedures/packages
• SQL Editor: connection delete handle was fixed
• Results viewer: shortcuts redefine was fixed
• Results viewer: filter proposal was fixed (quoted identifiers)
• Results viewer: find/replace highlights search string
• Results viewer: right justify numbers and dates (configurable)
• Database selector was fixed (minimize on some platforms)
• PostgreSQL: access methods/operators metadata support was added
• PostgreSQL: database dump using inserts (thanks to Alma Garcia)
• PostgreSQL: SSL configuration page was fixed
• PostgreSQL: DDL generator in generic driver was fixed
• PostgreSQL: update connection setting on different database activation
• Oracle: compile procedure/package error handling was fixed
• SQL Server: support of [] quotes
• Multiple UI fixes (including UI freeze on some platforms)