DataGrip 2019.2 EAP 2

Hello! Please welcome the newest build of our DataGrip 2019.2 EAP.

The Full-text Search dialog has a nice new look.

FTS

The whole mechanism has had several improvements made to it:

– In PostgreSQL, MySQL, and MariaDB you can now switch it to only search in columns that are indexed. To use this mode, choose ‘Only columns with full-text search indexes’ in Search in the drop-down menu.

The query in PostgreSQL will be: where col @@ plainto_tsquery('query')
The query in MySQL and mariaDB will be: where match(col) against ('query' in natural language mode)

– The search looks in columns which don’t support the LIKE operator, for instance, columns of JSON type. Values in these columns are converted to string type beforehand.

– In Cassandra, DataGrip creates several queries for one table, because the OR condition isn’t supported by the database.

Database tree

Drag-and-drop now works for creating groups in the database explorer.

If you want to create a new group, just drag-and-drop one data source onto the other.
If you want to place the data source into an existing group, drag-and-drop it there.

DragnDrop

Working with queries

Before, when working in the read-only mode we had some inconsistency: if a user wanted to run an update query from the read-only mode, we turned off only the IDE-level mode, but not the JDBC one (DBE-8145). Now though, we turn off both so you can run the query if you really need to.

ReadOnlyMode

A new action is available: Select current statement. You can get to it from Find Action (Ctrl/Cmd+Shift+A) or assign it a shortcut of its own.

SelectCurrentStatement

New combined items are now in code completion: IS NULL and IS NOT NULL.

INN

And we’ve added another intention action: now you can convert GROUP BY to DISTINCT if all the columns of a SELECT clause are presented in a GROUP BY clause.

GroupByIntention

That’s all for this new EAP! Stay tuned for the next EAP release coming your way; 2019.2 is going to be cool.

DataGrip team.

This entry was posted in Uncategorized. Bookmark the permalink.

2 Responses to DataGrip 2019.2 EAP 2

  1. Shane says:

    “A new action is available: Select current statement. You can get to it from Find Action (Ctrl/Cmd+Shift+A) or assign it a shortcut of its own.”

    Brilliant! Very happy for this feature – I was looking this recently.

    One thing to note, Ctrl+Shift+A was bound to “Find Action” for me (says the same on here too: https://www.jetbrains.com/help/datagrip/mastering-keyboard-shortcuts.html), so “Select current statement” was left unbound for me.

Leave a Reply

Your email address will not be published. Required fields are marked *