Dec 7 2020

• General improvements:
  • Preference pages structure was reorganized (in the standalone and plugin versions)
  • Sample database now can be created from the main menu
  • Several UI freeze issues were fixed (deadlocks)
  • Transaction deadlocks viewer was fixed
  • Boolean value editor UI was changed (text instead of icons)
  • User authentication UI was fixed when “Save password” option is off
  • Project delete now requires confirmation of project files delete
  • Script can be fully deleted in case table is delete from ERD
• A lot of improvements for MacOS:
  • Problem with toggle checkboxes was fixed
  • Problems with inline value editors were fixed
  • Problem with connection editor open on single click was fixed
  • Problem with metadata viewer in BigSur was fixed
• Database navigator:
  • Filters now support masks escape (_ and % characters)
  • Connection state icons were replaced and adapted to dark themes
  • View only connected data sources filter was added
  • Quick search in connections/schemas options were added
  • Multiple objects delete confirmation dialog was redesigned
  • Tooltips visibility configuration was added in preferences
  • SQL editor context menu was enhanced
  • “Link with editor” command was fixed for SQL scripts
  • Problem with empty/redundant tooltips was fixed
• Data viewer:
  • Grouping panel now supports column reordering
  • Column modifier icons (key, read-only) were updated
  • Column reordering UI was fixed
  • JSON/XML viewer performance was significantly improved
  • Minimum fetch size now limited by 100 rows
  • Bug with results fetch size disable was fixed
  • Contrast color now used as foreground color
  • ROWID columns support was fixed
  • Binary values copy-paste support was added
  • Column auto-completion in the filter panel was fixed
• Data transfer:
  • Native client selector was fixed
  • Extra file name pattern variables were added
  • Native date/timestamp format support was added to the SQL INSERTS export
  • Extra formatting options were added to the SQL INSERTS format
  • Export in SQL INSERT format: support of various INSERT/REPLACE/UPSERT dialects was added
  • SQL INSERT query generator now skips auto-generated columns
  • Data preview was fixed for custom SQL queries
  • Binary format mapping was fixed (BLOB->binary)
  • Target table name mapping was improved
  • Context data context menu item visibility was fixed
  • SQL format: extra options were added (including INSERT OR REPLACE support)
  • REPLACE/UPSERT support was added in SQL export format
  • HTML format: additional export options were added
  • DbUnit format support was improved
  • Target format selector was fixed (Linux)
  • Bug in dump/restore credentials save was fixed
  • Automatic columns mapping added for CSV without header column
  • Export from SQL query with custom variables: UIX was improved
  • Problem with active schema switch during task execute was fixed
  • Export from query: task UI configuration was fixed (active schema select)
  • Incorrect preview in case of import from table to table was fixed
  • Now export from database to database is possible
  • Problem with incorrect auto-assigned name for exported resultset was fixed
  • Now export selected row only to excel is possible
  • DND works if a composite task is created inside a composite task
• Import from CSV/XLSX:
  • Wrong rows can be skipped (with disabled “Batch import” option)
  • Import parameters documentation was updated
  • Date columns support was added
  • Timezone parameter was added for date/time columns
• SSH:
  • Support for OpenSSH key format was added
  • Problem with double password prompt was fixed
  • Bug with variables in connection parameters was fixed
  • Private key format conversion was improved (Linux)
• Command line:
  • Connection credentials now can be passed along with connection name/id
  • Running task from command line can be done in headlesss (console) mode
  • Support custom variables in CLI was added
• Windows installer:
  • Shortcuts for “All Users” were fixed
• ER diagrams:
  • Table comments loader was fixed
  • Able copy-paste was fixed
• Scheduler:
  • Hourly spinner in scheduling dialog was fixed
  • Cron scheduler support was added on Linux/MacOS
  • Possibility to enter invalid data was removed
  • Month names in Linux scheduler were corrected
  • Now deleted tasks do not remain scheduled
• AWS:
  • Support of SQL Server, Oracle, MariaDB in AWS RDS was added
  • Connect to Redshift after switching from IAM to DB native was fixed
• SQL Editor:
  • Query Builder enhancements were added
  • Editor tab title now can include active database/schema name
  • Toolbar buttons enablement was fixed
  • “Auto-save on edit” option was added
  • Procedures auto-completion was improved (use signature or parameter names depending on context)
  • Query cancel on editor close was fixed
  • Disable auto-formatting inside comments
  • Active query cancel on editor close
  • Folding support was improved and enabled by default
  • Current/selected word highlighting support was improved
  • SQL formatting was fixed for DDL queries (like CREATE TABLE)
  • “Find in Google” command was added
  • SQL-related preference pages were redesigned
  • Parser of complex SQL blocks (e. g. PL/SQL) was significantly improved
  • Problem with missing query results for some DDL queries was fixed
  • Complex SQL queries parser was improved
  • Query folding now respects active SQL dialect
  • Problem with focus loss after query execute was fixed
• PostgreSQL:
  • Latest PostGIS driver mapping was added
  • Geometry data types export was improved (proper SQL format + SRID)
  • Hidden databases can be loaded in the database navigator
  • Interval data type DDL was improved
  • Table storage parameters were added to DDL
  • “Connect as role” option was added in the connection settings
  • Materialized view comment edit was fixed
  • Trigger comment editor was added
  • Serial data types support was improved
  • Trigger DDL was fixed
  • $$ rule parser was fixed
  • Data type handler detection was fixed (uuid, name and other types)
  • Array editor was fixed (proper array item type discover).
  • Arrays edit support was fixed
  • Inet and other custom data types edit was fixed
  • “Generate SQL” action for varchar arrays was fixed
  • Create/alter trigger functions were fixed
  • Partition create/drop/alter actions were added
  • Table DDL was fixed (serial columns)
  • Role members/permissions viewer was fixed
  • Permission editor now supports sequences and materialized views
  • Bug with partition list read was fixed
• MySQL:
  • Driver “MySQL 8” is now the default driver. “MySQL 5” driver can be used for older server versions.
  • User credentials of mysqldump overwrite local configuration now
  • Zerofill flag support was added
  • NULL values of “text” type rendering was fixed
  • Dump/restore credentials override option was added
  • “Disable foreign key checks” option was added in database restore wizard
  • Privileges editor UI was fixed
• Oracle:
  • Tables/views load performance was improved on some systems
  • Extra NLS parameters were added on the connection settings page
  • Expired password change feature was fixed
  • Connectivity problem (“ONS configuration failed”) was fixed
  • Oracle 8 support was fixed (metadata read queries)
  • Ref cursors support was added
  • Multi-row INSERT support was added (for export in SQL format)
  • View and materialized view DDL was fixed (comments)
  • Extra metadata read performance options were added
  • Foreign key metadata read was fixed (ON DELETE rules)
  • View DDL was fixed (column comments)
  • PL/SQL parser was significantly improved
  • View DDL read was fixed
  • Session manager now supports Oracle 9 and 8
• SQL Server:
  • Extra T-SQL dialect keywords were added
  • SSL support was added
  • Database create/drop/rename features were added
  • Data read from clustered tables was fixed
  • National charsets support was added for table/column comments
  • Index create UI was improved (index type selector)
• Netezza:
  • Columns and table comments now available in DDL tab and Generate SQL
  • DDL with “Show comments” button.
  • Now comments can be added to views via UI.
  • Sequence DDL tab added
  • Ability to rename and delete sequence via UI added
  • Synonyms DDL tab added
  • Ability to rename tables via UI added
  • More functions to Netezza were added
• Hive:
  • LIMIT clause support was added
  • Indexes metadata read was added
  • Index create/drop functions were added
  • Column add/delete support was added
  • Table rename support was added
  • SQL dialect was improved (extra keywords)
• MongoDB:
  • Text view can be open
  • Remove old data function was fixed
  • Filter history appears in MongoDB
  • DELETE queries support was added
  • Support aggregation with SQL queries (GROUP BY) was added
  • MongoDB 2.x support was added
• Informix:
  • Driver was updated to the latest version
  • Schemas/tables metadata extraction was fixed
  • Error in database switch in transactional mode was fixed
  • Check constraints read was added
• SQLite:
  • Column autoincrement option support was added
  • Column drop feature was added
  • Table column delete feature was added
• DynamoDB:
  • Partitions
  • Connection to DynamoDB using profiles was fixed
  • Scripts generated by Generate SQL were fixed
• Firebird:
  • Data types information read was fixed
  • Problem with missing views was fixed. View source editor was fixed
• BigQuery:
  • Problem with missing resultsets was fixed
  • Driver version was upgraded
• DocumentDB: DocumentDB support was added
• CockroarchDB: Role manager was fixed
• DB2: Runstats utility support was fixed (wrong syntax)
• Snowflake: Active schema set command was fixed
• Derby: Unique indexes metadata read was implemented
• HANA: Triggers metadata reading was fixed (bug with wrong schema)
• Teradata: Active schema selector was added
• Exasol: Table index create UI was fixed
• CUBRID: driver configuration was fixed
• Intersystems IRIS: driver was added