DataGrip 2019.2 EAP 2

Maksim Sobolevskiy

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.

Comments below can no longer be edited.

2 Responses to DataGrip 2019.2 EAP 2

  1. Shane says:

    July 3, 2019

    “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.

    • Maksim Sobolevskiy says:

      July 3, 2019

      Yah, we just meant that Ctrl/Cmd+Shift+A goes for Find Action!