- 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
- Table statistics:
- Rendering problems (redraw on scrolling) were fixed
- Performance problems were fixed
- SQL Server support was added
- 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
- Data formatter:
- Action “reset to default” was fixed in preferences
- Preference changes are immediately applied to open data editors
- 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
- Object editor: “reject changes” and command undo/redo command were fixed
- Data import: open target table on finish
- 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
- Database driver edit dialog was fixed (legacy driver option is disabled by default)
- MySQL:
- User permission management was fixed (FLUSH PRIVILEGES is not needed for newer server versions)
- Unsigned INT and BIGINT data types support was added
- Oracle:
- Numeric data type modifiers (scale/precision) rendering was fixed
- Materialized views read/create and delete was fixed (mviews were removed from table list)
- PostgreSQL:
- Vacuum tool was improved (run in auto-commit mode)
- List of reserved keywords was updated
- Redshift: View with no schema binding support was added
- SQL Server: timestamp columns were marked as auto-generated
- Big number of minor UI and database-specific bugs were fixed
DBeaver 7.1.1
Posted in Releases