DBE-12772 : We fixed the resolution of standard attributes for collection types (for example, COUNT).

– Incorrect usages of %TYPE are reported as warnings. – Cursor parameter references qualified by a cursor name are resolved correctly. – Recursive references to nested routines are resolved correctly. – Public synonyms are now correctly placed in the PUBLIC schema.

DBE-5497 : We fixed a few problems with Oracle collection methods:.

DBE-16871 : The Unexpected value error no longer pops up when previewing a table.ĭBE-16831: A setting to specify the default resolve mode used in the console has been added to Preferences | Database | Query execution | Other.

DBE-12109 : Semicolons are no longer omitted in Oracle Aggregate Functions.

DBE-10555: Whenever you copy and paste something, the IDE now correctly analyzes the selection (instead of the cursor position).

DBE-14074: Named parameters are detected correctly.

DBE-16250: There are no more empty spaces in in-editor results, as the table now adjusts its height to match the height of the results.

When the checkbox is enabled, rows will have alternating colors. DBE-3572: We’ve added an Alternate row colors setting for results tables.DBE-17329 : Virtual view creation is now also available in read-only mode.DBE-16393: We’ve added a source editor to the Modify view.DBE-11012 : The SQLite native library is now unpacked to the system folder.DBE-16417 : Current schema detection now works for any database.Now everything but the list of users will be loaded. If the user permissions did not allow retrieving a list of database users, the rest of the database objects were not loaded either. DBE-12404 : We fixed an issue with interrupting object introspection.

DBE-9087 : When using the clause REFERENCING, the trigger’s DDL is generated correctly.DBE-10603 : The Quick Definition now works as expected.DBE-6986 : The ROW_FORMAT clause/syntax is now supported.You can create a trigger X in schema A to table E in schema B, and it will be shown in schema B under the host table E. DBE-12578 : Cross database triggers are now supported.DBE-10812 : The Drop context menu command now works as expected.DBE-17263: Data source content statistics is again displayed in the Quick Documentation popup.DBE-6276 : DDL navigation to security policies now works as expected.DBE-11946 : An issue with Place constraints was fixed.DBE-13186 : Inspections no longer erroneously report extra code.DBE-12139 : The ENCRYPTION syntax is now supported.DBE-16311 : FOR UPDATE in nested queries is now supported.DBE-14796 : Problems with LAG and LEAD functions have been fixed.DBE-9219 : Сase settings when completing exact-case names are now ignored.DBE-15973 : The WINDOW clause is now supported.The other fixes in this area are more or less self-explanatory: If you have configured a special style for SQL2016 and the Inherit general SQL style checkbox in Preferences is not enabled, then you will need to reconfigure it. DBE-14440 : We fixed the bug with saving style settings.Now, if you want to preserve the old Formatter behavior (without the space), you can change the Space after keyword setting to No in Preferences | Editor | Code Style | SQL (go to the Queries tab ). For this part, we also added a new setting. Now it works as expected, and DataGrip can also add a space between the EXISTS keyword and the left parenthesis. DBE-4469: We fixed the problem where SQL Formatter didn’t apply the right style for a subquery in the EXISTS clause.Of course, you can already get the benefits of these fixes by downloading our EAP build! Working with code Today we’ll cover what we’ve managed to fix so far. Our 2023.1 release cycle is all about quality, which means we’re working on the bugs that have accumulated in our public issue tracker.

Datagrip mac failed