DataGrip 2023.1 EAP 3: Enhancements and Fixes

Oracle Datagrip, a powerful database tool, has released its latest Early Access Program (EAP) version 2023.1, packed with new features and bug fixes. In this article, we will dive into the key enhancements and resolutions that have been implemented in this release.

Firstly, the image preview in the data grid has been fixed, resolving a long-standing issue. Additionally, broken SQL completion for nested properties has been addressed, making it easier to write complex queries. Furthermore, the bug with loss of values in IN (...) clauses when there are more than 10 values has also been resolved.

The CREATE PROCEDURE and CREATE FUNCTION statements now correctly terminate with a space, as expected. Moreover, failing queries with Read access are now allowed from inside read-action (or EDT) only notifications in the Query console.

In terms of sequence management, DataGrip has introduced several improvements. Instead of specifying the sequence start value, you can now specify the next sequence value in the START WITH clause in both CREATE and ALTER statements. This provides greater flexibility when working with sequences.

When enabled, the Specify next value for sequences option allows DataGrip to add the next sequence value to DDL statements, making it easier to manage sequence behavior. If disabled, DataGrip will generate the sequence DDL with the start value in the START WITH clause.

Several other enhancements have been made, including support for EPHEMERAL columns, INTERSECT, and EXCEPT clauses, as well as improved alias resolution in UNNEST queries. Moreover, the introspection level has been expanded to Level 1, which allows you to click Refresh selected object to edit a specific object or view its sources.

Additionally, several improvements have been implemented to speed up introspection on Level 1, making it easier and faster to work with large numbers of schemas and database objects. Finally, DataGrip 2023.1 EAP 3 is out, and we recommend upgrading to experience these enhancements and fixes firsthand.

Oracle datagrip