- Data viewer:
- Record mode now supports multiple records view
- Double-click behavior in filters popup was fixed
- Spatial viewer now allows to copy point coordinates
- Source tables resolution was fixed for CTE queries and sub-selects
- Navigator:
- Quick filter was fixed (show connected only)
- “Set connection from navigator” action behavior was fixed
- SQL editor:
- Auto-completion for identifiers with special characters was fixed
- SQL console now opens for selected schema
- Table columns are shown in original order for auto-completion
- Formatting of queries with embedded comments was fixed
- Local variables coloring was added (Sybase, SQL Server, MySQL)
- Metadata editor:
- Metadata search now supports search in procedures/views definition
- Object info refresh was fixed
- Table triggers loading performance was significantly improved for most databases
- Clickhouse:
- Table DDL was fixed
- Nested comments support was added
- Data edit (update/delete) queries generator was fixed
- DB2 iSeries: schemas with long names loading was fixed
- Hive: constraints definition was fixed
- MySQL:
- Execution plan explain for CTE queries was fixed
- Use password escape was fixed
- PrestoDB/Trino: data and metadata editors were improved
- PostgreSQL:
- Data type fully-qualified name now used instead of scale/precision
- Custom data types (including geometry) resolution was improved
- SAP HANA: stored procedures results loader was improved (multiple cursors + atomic values)
- Snowflake: $$ parser was improved
- SQL Server:
- Temporary table support was improved (metadata load, SQL auto-suggest)
- datetime data type DDL was fixed
- Active schema selector was fixed
- BEGIN/END blocks support was added
- Vertica:
- Flex tables metadata was fixed
- Function body parser was fixed
DBeaver 21.1.2
Posted in Releases