7.2

Sep 7 2020
Changes since 7.1:
  • General improvements:
    • Database driver edit dialog was fixed (legacy driver option is disabled by default)
    • We upgraded Eclipse platform version to 2020-06. It affects dark theme and General preferences and fixes several minor bugs
    • Simple view mode was fixed (redundant database objects were hidden)
    • Proxy configuration UI was fixed
    • MacOS installer was fixed (potential vulnerability was removed)
    • Query cancelling was improved (force cancel for hanging connections)
    • Transaction isolation level settings save was fixed
    • Error and debug logging was fixed
    • Problem with database list load was fixed (PostgreSQL, Redshift, MySQL, Oracle, SQL Server)
    • Default database name and default user name were added for many database drivers
    • Dark theme support was improved (tab folders, toolbars)
    • Support of find/replace in document presentation (json/xml) was added
    • AWS IAM auth: support session_token in default credentials was added
    • Incorrect behavior in VQB was fixed
  • Database navigator:
    • Connection type highlighting was redesigned
    • Simple view support was improved
    • “Force object refresh on editor open” action was fixed
    • Main toolbar UIX was improved (no disabled selectors)
    • Database tools context menu was fixed
    • Connection status icons and tooltips were redesigned
    • Icon decorations added for Git-integrated projects
    • Navigator view options were added in the context menu
    • Simple view support was improved (redundant objects removed from the navigator tree)
    • Icons for “Create new objects” action were fixed
    • Icons for “Create object” actions were fixed
    • Main menu File items were reordered
    • Heading and trailing spaces trim was added to all edit dialogs/panels
    • Statistics render was fixed for MacOS and Linux
    • Database size statistics was added for PostgreSQL, MySQL, SQL Server, DB2
  • Data viewer:
    • Wrong value extraction was fixed for expression aliases which conflict with table column names
    • Dictionary values separator configuration was added
    • Row coloring: support of gradient coloring for read-only columns was added
    • Now we refresh entire row after cell value update (handy if you have triggers)
    • Generate SQL context menu was fixed
    • Horizontal scroll with mouse wheel support was added
    • Export data in source code (PHP arrays) format was added
    • Bug with Ctrl+Backspace handler was fixed
    • Column ordering was fixed (for custom SQL queries)
    • UUID transform: version 2 support was added
  • Data formatter:
    • Action “reset to default” was fixed in preferences
    • Preference changes are immediately applied to open data editors
  • Data editor:
    • Unique key detection was fixed (for data editor)
    • Advanced paste of multiple rows was fixed (redundant rows create was removed)
    • Column filter dialog move/resize was fixed on Linux
    • Grid data rendering performance was improved
    • Auto-complete of column names was fixed in the filter panel
  • Data transfer:
    • Import from multiple CSV files was added
    • Import from files into new tables
    • Import from .xlsx files into tables
    • Data import preview dialog was added
    • Target table create/alter DDL now supports database-specific options
    • Virtual columns are ignored in SQL INSERTs export
    • Problem with data transfer wizard and Darkest Dark theme was fixed
    • Problem with timestamp format for CSV/XLSX export was fixed
    • Case sensitive table/column names resolution was fixed
  • Team work:
    • Problem with empty Git Repositories view was fixed
    • Git integration was added in project navigator view
  • Table statistics:
    • Rendering problems (redraw on scrolling) were fixed
    • Performance problems were fixed
    • SQL Server support was added
    • Performance for table statistics reading was improved
  • Data import: Open target table on finish
  • Data export: Custom data type formatting support was fixed
  • Object editor: “Reject changes” and command undo/redo command were fixed
  • Data migration: DDL generation was improved (apply the same column data type when source and target databases use the same driver)
  • Database tasks: PostgreSQL, MySQL and Oracle tools now can be saved as tasks
  • SSH configurator: UI controls layout was fixed
  • ERD editor: Extra coloring was added for multi-schema diagrams
  • Metadata editor: Edit property form rendering was improved (non-applicable fields are hidden)
  • Session manager: Problem with multiple windows was fixed
  • Spatial presentation: Tooltips rendering was fixed
  • Tasks management: Error handing was improved (for deleted tables)
  • SQL editor:
    • Results tab rename was fixed (now we save tab title between results refresh)
    • Parser of multiple SQL queries on a single line was fixed
    • Execution plan explain operation cancel was implemented
    • Coloring of numbers in scientific notation was fixed
    • Paste from source code: \n and \r characters handle was fixed (now we use proper line feeds)
    • Stored procedures call generation was fixed
    • Query cancel handler was improved (problem with UI stuck was fixed)
    • Now we show query information in the result tab tooltip
    • Query parser was fixed (active query extraction for Ctrl+Enter action)
    • Template variables (${word_selection} and ${line_selection}) support was fixed
    • Search/replace/undio/redo shortcuts were fixed in embedded editors (view/procedure sources)
    • Parameter binding was fixed for multiple occurrences of the same parameter
    • Smart commit mode behavior was fixed for PostgreSQL (post-error transaction recovery)
    • Delete indent with single backspace was enabled by default
    • Server log panel now works for data modification triggers
    • Extract query from source code now shows notification popup
    • Multiple queries execution is now allowed (in separate tabs)
  • PostgreSQL:
    • Vacuum tool was improved (run in auto-commit mode)
    • List of reserved keywords was updated
    • Table partition DDL was fixed
    • Data type DDL was improved + comment edit support was added
    • Default schema detection and search_path overwrite was fixed
    • Multi-dimension arrays support was added
    • Table DDL for inherited tables was fixed
    • Native client version was upgraded to version 12 (Windows)
    • Check constraints read was fixed (PG 12+)
    • SQL results limit was fixed (for queries with LIMIT/OFFSET/FETCH clauses)
    • Object DDL generator was improved (comments, permissions)
    • Support of case insensitive full-text search was added
    • Table partitions statistics was added
    • Cursor fetch was fixed
    • Native client was upgraded to version 12
    • Table OID support was fixed (PG 12)
    • PgPass parser was improved (support for escaped characters was added)
  • MySQL:
    • User permission management was fixed (FLUSH PRIVILEGES is not needed for newer server versions)
    • Unsigned INT and BIGINT data types support was added
    • CHECK constraints edit support was added
    • Database restore was fixed (binary data corruption)
    • Active database change in read-only connections was fixed
    • CHECK constraints support was added
    • Table copy operation was fixed
    • User password management was improved (to avoid FLUSH PRIVILEGES)
    • Problem with check constraints read was fixed
    • Table copy was fixed (bug with redundant indexes was resolved)
    • Table column resolving was fixed
  • Oracle:
    • Numeric data type modifiers (scale/precision) rendering was fixed
    • Materialized views read/create and delete was fixed (mviews were removed from table list)
    • Table statistics read was fixed
    • Schema indexes folder was added
    • Check constraints editor was added
    • Trigger status icon was fixed
    • Problem with connect as SYSDBA was fixed
    • Metadata read performance was increased (Tables, materialized views)
    • Columns and constraints were added in materialized view editor
    • Numeric data type precision read was fixed
    • Support of implicit cursors in query results was added
    • View DDL reading was improved (view comments are included in DDL)
    • TNS names search was fixed
    • Connection info was fixed for TNS/custom URL connections
    • Variables are now supported in custom JDBC URL
    • Materialized view comment editor was fixed
    • View definition reading was fixed (for non-DBA users)
    • Table reading now uses DBA views (optional)
    • Profile resources metadata reading was fixed
  • Redshift:
    • View with no schema binding support was added
    • Driver download was fixed
    • Problem with read-only resultsets was fixed
    • Alter column support was added
    • Support Redshift IAM authentication was added
    • Table size isn`t always shown as zero in DB Navigator
  • SQL Server:
    • Timestamp columns were marked as auto-generated
    • Database tools (index rebuild, triggers disable) were redesigned
  • Exasol:
    • Metadata read performance was improved
    • Metadata search support was added
    • Table references
    • Index create DDL was fixed
    • Table statistics read performance was improved
    • Database error type discovery was added (proper handle of “connection lost” errors)
    • Metadata read performance was improved
  • Sybase:
    • Support of text editing in views was added
    • Schema indexes reading was fixed
    • New table columns create was fixed
  • CockroachDB:
    • Direct table data edit support was fixed
    • Connectivity problem was fixed
  • Greenplum:
    • Metadata search was fixed (for procedures)
    • Table metadata reading was fixed
  • DynamoDB:
    • Table delete script is shown when table is deleting
    • Error when trying to execute “Select all rows” and “Select row counts” was fixed
    • Table filters support was added
    • Table edit support was added
    • Npe appearance when row is added/deleted/duplicated was fixed
    • DynamoDB tables limit was extended
    • Support cross-account IAM auth was added
  • Cassandra:
    • Now columns are shown in Property editor in Simple view
    • An ability to create/drop keyspaces from UI was added
    • An ability to open columns from ‘killrvideo’ keyspace
  • Netezza:
    • Support edit of procedures body and views definition was added
    • Additional DDL elements for Netezza
    • Statistics for databases was added
    • Table statistics
    • Sequences
    • Synonyms
    • Proper schema resolution
    • A session manager, with “kill session” function was added
  • MongoDB:
    • Now Grid is correctly shown in special case
    • Import from db\csv – data is imported correctly
    • Preview could be viewed when trying to import from CSV
    • Order in Result Set Order/Filter Settings was fixed
    • Changing format for Mongo Atlas values was fixed
    • Script btn in Delete collection/database dialogue shows a script
    • Tool bar Active Catalogue/Schema doesn`t change database name on the name written in connection settings after SQL execution.
    • Lists and documents are shown correctly in Text view
    • Support mongo->mongo data transfer
    • Collection rename support
  • Redis:
    • Misalignment in ERD tab availability was fixed
    • Keys can be edited
  • CouchDB: CouchDB support was added
  • Couchbase: Possibility to set Timeout for Couchbase was added
  • Firebird: New table and table column creation was fixed
  • HSQLDB: UUID data type support was added
  • Snowflake: SQL dialect support was fixed ($$ comments)
  • DB2: UI tools were converted into database tasks
  • Drivers:
    • SQreamDB driver was added
    • YugabyteDB driver was added
    • Google Spanner Official driver configuration was added