DBeaver full changelog

- Data transfer:
- REPLACE/UPSERT support was added in SQL export format
- Target format selector was fixed (Linux)
- Bug in dump/restore credentials save was fixed
- Data viewer:
- Contrast color now used as foreground color
- Bug with results fetch size disable was fixed
- Preference pages structure was re-organized (get rid of Eclipse legacy)
- Database navigator:
- SQL editor context menu was enhanced
- "Link wit editor" command was fixed for SQL scripts
- Problem with empty/redundant tooltips was fixed
- SQL editor: active query cancel on editor close
- ER diagrams: table comments loader was fixed
- Sample database now can be created from the main menu
- Transaction deadlocks viewer was fixed
- PostgreSQL:
- Data type handler detection was fixed (uuid, name and other types)
- Array editor was fixed (proper array item type discover).
- Oracle:
- 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)
- MySQL:
- Dump/restore credentials override option was added
- "Disable foreign key checks" option was added in database restore wizard
- SQL Server: national charsets support was added for table/column comments
- Informix: check constraints read was added
- Hive: LIMIT clause support was added
- Intersystems IRIS driver was added
- Number of minor bugs were fixed

- Database navigator:
- 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
- Windows installer: shortcuts for "All Users" were fixed
- SSH tunnels:
- Support for OpenSSH key format was added
- Problem with dobule password prompt was fixed
- Data viewer:
- Grouping panel now supports column reordering
- Column modifier icons (key, read-only) were updated
- JSON/XML viewer performance was significantly improved
- SQL editor: toolbar buttons enablement 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
- MySQL: user credentials of mysqldump overwrite local configuration now
- SQL Server:
- SSL support was added
- Database create/drop/rename features were added
- PostgreSQL:
- 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
- Oracle: extra NLS parameters were added on the connection settings page
- Snowflake: active schema set command was fixed
- Derby: unique indexes metadata read was implemented
- SQLite: column autoincrement option support was added
- Firebird: data types information read was fixed
- Several other minor UI bugs were fixed

Major changes since 7.1:
- Simplified database structure view was added
- Database maintenance tools can be saved as tasks now
- Table and schema size statistics were added in the database navigator
- Import from multiple CSV files was added. Files can be imported into new or existing tables
- Many problems with UI freeze on disconnect or query cancel were fixed
- Database navigator rendering was redesigned
- A number of problems with keyboard shortcuts were fixed
- Git integration was improved: now we show file status in the Project Explorer view
- New database drivers were added: YugabyteDB and SQreamDB
Changes since 7.1.5:
- Problem with database list load was fixed (PostgreSQL, Redshift, MySQL, Oracle, SQL Server)
- Metadata editor: edit property form rendering was improved (non-applicable fields are hidden)
- Performance for table statistics reading was improved
- Data viewer:
- Column ordering was fixed (for custom SQL queries)
- UUID transform: version 2 support was added
- Default database name and default user name were added for many database drivers
- Data export: custom data type formatting support was fixed
- PostgreSQL:
- 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)
- Oracle:
- 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
- MariaDB/MySQL: table column resolving was fixed
- CockroachDB: connectivity problem was fixed
- Greenplum:
- Metadata search was fixed (for procedures)
- Table metadata reading was fixed
- Dark theme support was improved (tab folders, toolbars)
- A large number of minor UI bugfixes

- Data transfer:
- Import from multiple CSV files was added
- Import from files into new 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
- Database navigator:
- Statistics render was fixed for MacOS and Linux
- Database size statistics was added for PostgreSQL, MySQL, SQL Server, DB2
- Team work:
- Problem with empty Git Repositories view was fixed
- Git integration was added in project navigator view
- PostgreSQL:
- 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
- Oracle:
- TNS names search was fixed
- Connection info was fixed for TNS/custom URL connections
- Variables are now supported in custom JDBC URL (thanks to @insightfuls)
- MysQL:
- Problem with check constraints read was fixed
- Table copy was fixed (bug with redundant indexes was resolved)
- Redshift: problem with read-only resultsets was fixed
- Snowflake: SQL dialect support was fixed ($$ comments)
- A large number of minor UI improvements and bugfixes

- Data viewer:
- 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
- SQL Editor:
- 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
- Navigator:
- 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
- Session manager: problem with multiple windows was fixed
- SQL Server: Database tools (index rebuild, triggers disable) were redesigned
- Firebird: new table and table column creation was fixed
- PostgreSQL: Table partition DDL was fixed
- MySQL: CHECK constraints edit support was added
- Oracle:
- Table statistics read was fixed
- Schema indexes folder was added
- Check constraints editor was added
- Trigger status icon was fixed
- Exasol: (thanks to @Sargul)
- Metadata read performance was improved
- Metadata search support was added
- Table references
- Index create DDL was fixed
- Table statistics read performance was improved
- Redshift: driver download was fixed
- SQreamDB driver was added
- YugabyteDB driver was added
- We upgraded Eclipse platform version to 2020-06. It affects dark theme and General preferences and fixes several minor bugs

- Data viewer:
- Problem with unreachable last row/column was fixed
- "Open With" action now uses configuration from last data export
- Find/replace issues were fixed (scroll to found cell)
- Bug in reference panel was fixed (multiple value selection)
- Filter value auto-completion was fixed (popup close)
- Virtual unique keys management was improved
- SQL editor: multiline code templates apply was fixed (thanks to @VASilaev)
- Number of bugs were fixed in the Simple navigator view
- Transaction management was improved (redundant transaction commit confirmations were removed)
- GIS viewer: many new (and cool) tiles were added (thanks to @mkgrgis)
- Active catalog/schema selector UI was improved
- Connection edit dialog was fixed (error during page switch)
- Oracle:
- Connection settings (SID/Service) save was fixed
- Session terminate was fixed (for non-RAC databases)
- Exasol:
- Foreign key creation was fixed
- View DDL extraction was fixed (auto-format was disabled)
- HANA: unique key creation was fixed
- Firebird: procedure metadata refresh was fixed
- Problems with remote RDP connections (app crash) were fixed
- Japanese localization was significantly improved (thanks to @ScratchBuild)
- We have migrated to Eclipse platform 2020-03
- Many other minor bug fixes and improvements

- Database navigator:
- Simplified database structure view was added
- Navigator view settings and presets were added
- Object editor:
- Context menu was added to the object breadcrumbs
- Object alter script now can be opened in SQL editor
- Data editor:
- Preference and data format changes now applying immediately (without data refresh)
- Scrollbar position reset in columns reorder/filtering was fixed
- Number of selected rows/columns/cells now shown in the status bar
- Query filter history save/load was fixed
- Floating point numbers (4-byte precision) rendering was fixed
- SQL Editor: quick search tool was added (ctrl+alt+shift+f)
- Driver copy was fixed (problem with read-only URL)
- PostgreSQL:
- PGPASS support was fixed
- Database information (ctype, collate) reading was fixed
- Problems with default database change were fixed
- OID types rendering fix
- Domain metadata reading was fixed (base type qualified name)
- Extra options were added to database backup/restore wizards
- Redshift: data type resolution was fixed (array types)
- SQL Server:
- Driver download and "reset to default" was fixed
- Default schema detection was added
- Problems with read-only query results were fixed
- Column comments edit was fixed
- MySQL:
- Permission editor was fixed (schema privileges)
- Index rename support was added
- Exasol:
- Security tree (Exasol 7) was fixed
- Auto-completion for builtin functions was added
- Foreign keys metadata was fixed
- Oracle: "drop procedure" support was fixed
- SAP HANA: driver download was fixed
- Firebird: driver version was upgraded (4.0)
- Many other minor bug fixes

DBeaver 7.0 is our new major release.

Changes since 6.0:
- Tasks management: data transfer, backup-restore, SQL execution
- Data viewer and data editor UI major improvements:
- GIS/geo-spatial viewer
- JSON viewer
- Logical columns, primary and foreign keys
- References panel
- Advanced row coloring
- SQL editor major improvements:
- Smart-commit mode
- Enhanced SQL parser and auto-complete proposals
- Git integration
- SSH agents and jump servers support
- And a lot of other great things
Moreover:
- We increased number of supported drivers to 81
- We closed almost 2000 issues on GitHub.
Thank you for your support!

Changes since 6.3.5:
- SQL script execute task:
- Support of multiple scripts was added
- Support of multiple connections was added
- Configuration wizard was completely redesigned
- SQL editor:
- Auto-complete proposals were colorized
- Auto-complete for table column possible values
- Synonyms are now resolved as tables
- Data viewer:
- Filter panel auto-completion was fixed
- Value viewer panel refresh was fixed
- Boolean column transformation was added (view numeric columns as checkboxes)
- Import from CSV: column mappings was fixed
- Popup panels unexpected close was fixed
- Invalidation of dead SSH tunnels was fixed
- PostgreSQL:
- Type cast for updates and filters is now used
- Timestamp scale edit was fixed
- SQL Server:
- Driver version upgrade (to 8.2)
- Data import for IDENTITY columns was fixed
- MySQL: permission editor supports schema masks
- Oracle:
- PL/SQL parser was fixed
- Comment editor for views and functions was fixed
- TIMESTAMP WITH TIMEZONE support was improved
- HANA:
- GIS (geometry) data types support was improved (by @stefanuhrig)
- Table column drop was fixed
- OmniSci: driver version was updated.
- Linux: UI freezes were fixed
- A few minor UI improvements (icons, English localization, ERD colors, shortcuts)
- A lot of minor bug fixes

- Data viewer:
- Read-only columns UI was improved (icon + explanation were added)
- Filter text content assistant was significantly improved
- Row count calculation control UI ws fixed
- "Set default value" shortcut was changed
- Ordering in record mode was fixed
- Data change confirmation was fixed
- Plaintext presentation rendering was fixed (extra spaces)
- Numbers native representation mode (no client-side formatting) was added
- SQL editor:
- Export from query task was fixed
- Output tab now remains active after query execute
- Auto-commit toggle was fixed (rollback is performed on mode switch)
- Connection initialization was fixed ("Not connected to a database" bug)
- Column values assistance was added
- Numbers color and font was fixed
- ERD viewer:
- Entity/schema diagram "reset" action was added
- "Show views" option handle was fixed
- Connections and drivers:
- Variables support was improved (now all properties may contain variables)
- Maven artifact version resolution was fixed (null version bug)
- External drivers configuration support was added (see wiki)
- PostgreSQL:
- Query cancellation was fixed
- Hyperlinks and "Go to object" action were fixed (now they use current database instead of default one)
- Schema privileges were added in DDL
- Indexes read was fixed (redundant primary key constraint was removed)
- Arrays of domain types support was fixed
- Column copy-paste support was added
- MySQL:
- Identifiers redundant quotation was fixed
- Column copy-paste support was added
- Oracle:
- Default schema detection was fixed
- Double compilation of package was fixed
- PL/SQL parser was improved (case .. when .. end)
- DB2: alter column DDL was fixed (column modifiers were added)
- SQL Server: metadata search was fixed (wrong object types bug)
- AWS Athena: error position highlighting was added
- Sybase: legacy versions (12 and earlier) support was improved
- A lot of minor bugfixes

- A lot of minor bugfixes